ORA-19599 When Backing up an Archivelog that is Corrupt

刘泽宇

现象：
Getting error when backing up archivelogs:

RMAN-03015: error occurred in stored script backup_al_all_tape_dwdb2
RMAN-03009: failure of backup command on t1 channel at 10/03/2007 12:29:13
ORA-19599: block number 2181011 is corrupt in archived log /<path>/<SID>_2_9482.arc

原因：
Oracle through RMAN is finding corruption in the archivelog file '/<path>/<SID>_2_9482.arc'.


处理方法：
RMAN can be used to check archivelogs for corruption.

1) Validate all archivelogs for corruption:

RMAN> validate archivelog all;
2) Move any corrupted archivelog to a temporary directory using an operating system command such as cp.  For example:

$ mv /<path>/<SID>_2_9482.arc /tmp/
If archivelog files are on ASM, the following can be used:
How to Move a Datafile from Filesystem to ASM Using ASMCMD CP Command. (Doc ID 1610615.1)

3) Once the archivelog files is not residing in expected location, run the crosscheck command in RMAN to mark it as expired.

RMAN> crosscheck copy of archivelog all ;

Or

RMAN> crosscheck archivelog '<Path and name of corrupted archivelog>' ;   <== by full path and name
RMAN> crosscheck archivelog sequence 9482 thread 2;     <== by sequence and thread numbers

4) Re-execute the archivelog backup