ORA-19575: expected blocks in file location RMAN

ORA-19575: expected 1814132 blocks in file /archive/DB_1_158247_747682823.arc

Seems archive file is corrupted nothing to do with this file. During archive backup from RMAN script file seems to be corrupted and through error ORA-19575. If we have mirror image of Archive file available then we replace with that file other wise we need to uncatalog the file from control file. So that RMAN backup run without errors.

Solution:

1. Rename the file present in the location.

mv  /archive/PROD_1_158247_747682823.arc   /archive/PROD_1_158247_747682823.arc_bkp

2. Uncatalog the file with following command.

RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
change archivelog sequence 158247 uncatalog;
RELEASE CHANNEL ch00;
}

3. Run the regular backup of archive.

RUN {<
# backup all archive logs
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
sql 'alter system switch logfile';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
}

4. Its working fine.
 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.