RMAN-06059: expected archived log not found, loss of archived log compromises recoverability


Starting backup at 04-JUN-14
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1161 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 06/04/2014 11:43:54
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /u01/app/oracle/arch/1_3259_750090831.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


Solution: 

Logan RMAN:

rman target=sys/password@SID catalog sysman/passowrd@rman_sid


RMAN> crosscheck archivelog all;

RMAN> delete noprompt expired archivelog all;

Then try to take full backup.

1 comment:

inflation hedge funds said...

Thanks for the informative article! waiting for your next post global macro hedge funds