Subscribe YouTube Channel For More Live Tutorials

ORA-19599: block number is corrupt in archived log

Error : Getting error when backing up archivelogs:

Customer Recommended

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 09/30/2020 01:13:45
ORA-19599: block number 32744 is corrupt in archived log /archives/prod/1_1051221990_20.arc

Solution

You can use rman 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/

3) Once done Run a Crosscheck command from RMAN to Mark the archivelog as expired.

    RMAN> Crosscheck copy of archivelog all ;

Or

   RMAN> Crosscheck archivelog '<Path and name of corrupted archivelog>' ;