Sunday, August 8, 2010

RMAN Backup Failed With ORA-19625

While taking daily database backup using RMAN it fails with this error ORA-19625 like the following scenario

RMAN> run{
allocate channel c1 device type disk;
backup incremental level 0 database plus archivelog delete input;
}

allocated channel: c1
channel c1: sid=136 devtype=DISK


Starting backup at 04-AUG-10
current log archived
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 08/04/2010 23:05:55
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/app/oracle/oradata/ORCL/Archive/1_20_721258430.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


When I checked the archived redo log file /u01/app/oracle/oradata/ORCL/Archive/1_20_721258430.dbf I found it was deleted by mistake from the operating system.

To recover from this error and complete the backup process I had to run this command crosscheck archivelog all from RMAN prompt to let RMAN ignore the missing file and complete taking backup.

RMAN> crosscheck archivelog all;


After that I ran the backup command and it completed successfully.

No comments: