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:
Post a Comment