DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Friday, January 13, 2017

 ORA-19625 will encounter when the archives are obsolete.

Description:

There has been a major crash in the storage. A RAID volume failed and then we created those mount point again. The oracle DB was restored from RMAN backup, but after that we are facing challenges to take both hot and cold backup using RMAN . 

Look for all the following:

I find below error.




Above error ORA-19625 will encounter when the archives are obsolete or when expired means (physically not there in your location).

So what next run and see whether that archive are there in your archive location are not.
Database with a recovery catalog.
$ Export ORACLE_SID=<instance name>
$ Rman
RMAN> connect target /
RMAN> crosscheck archivelog all;
RMAN>delete expired archivelog all;
Then also no use I encountered same above error when I run hot backup script.

RMAN> exit

Workaround:

Connect through catalog and to repeat the same above steps.

$ rman target sys/<password>@<tnssevice> catalog <user>/<pwd>@<tnssevice>
Why above step required ?
Previously we delete expired logs from target machine but from catalog control file still there.
That’s the reason I connected to target and catalog
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
RMAN>exit
Now issue resolved.

No comments: