Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN-06059 expected archived log not found

user12100209Feb 4 2011 — edited Feb 7 2011
Hello experts

Very often the RMAN backup notice me the following error:

RMAN-06059 expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file +BD2/db/archivelog/2011_01_27/thread_2_seq_6794.4744.741546565
ORA-17503: ksfdopn:2 Failed to open file +BD2/db/archivelog/2011_01_27/thread_2_seq_6794.4744.741546565
ORA-15012: ASM file '+BD2/db/archivelog/2011_01_27/thread_2_seq_6794.4744.741546565' does not exist

Normaly I do a crosscheck of archivelog all, then I remove expired archivelog all and finally I do a level 0 backup. That solve the problem but I would like to know about the causes of the lost of one archivelog. Many time the trace that does not exist has been backed the day before so I do not know why the rman need it again.
Here is the script I use to back up:

$ORACLE_HOME/bin/rman LOG=rman.log<<EOF >/dev/null

connect TARGET /;

sql 'alter system archive log current';

backup as compressed backupset check logical TAG "RMAN_REDOS" archivelog all delete input format 'SAVE';
backup current controlfile for standby format 'CONTROL';

When I check error, I see that this archived log still is on control file rman catalog and isn“t on +ASM 'cause it was saved already.
When I check rman 's log I see that the file was backed in a before backup.

Could you please notice me about the causes?
Do you have any suggestion for me?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2011
Added on Feb 4 2011
6 comments
2,343 views