This content has been marked as final. Show 4 replies
Find which achivelog is corrupted and move the corrupted archive log to different directory, then crosscheck and take the backup. To do this,1 person found this helpful
RMAN>Validate archivelog all; then, Move the corrupted archive log
RMAN>crosscheck archivelog all;
RMAN>Backup archivelog all;
Hello;1 person found this helpful
RESTORE VALIDATE reads all of the backup files that would be needed to restore the specified objects, but the objects are not actually restored to disk.
If a backup piece is missing or corrupt the restore validate will automatically check for the availability of previous backups.
RMAN restore database validate check logical;
Repair block corruptions using Data Recovery Advisor in Oracle 11g
restore archivelog all validate;
You need to exclude that archivelog from the backup. Rename the archivelog (using asmcmd) and then run CROSSCHECK ARCHIVELOG ALL so that Oracle would mark it as "Expired" when it doesn't find the archivelog. (You can also run a DELETE ARCHIVELOG or DELETE EXPIRED ARCHIVELOG to logically delete it).
You must document that missing archivelog so that any future recovery required knows that this archivelog is not available, therefore a point in time recovery to any point from the last backup before this archivelog upto a point in time of the archivelog or subsequent to it upto the next backup would not be possible.
Needless to say, take a fresh database backup.
Hemant K Chitale
1 person found this helpful
RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;You can remove this log with command
Starting backup at 24-MAR-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DG1/kvxcprd/datafile/system.260.777756857
input datafile fno=00003 name=+DG1/kvxcprd/datafile/sysaux.268.777756857
input datafile fno=00002 name=+DG1/kvxcprd/datafile/undotbs1.263.777756857
input datafile fno=00005 name=+DG1/kvxcprd/datafile/undotbs2.264.777756983
input datafile fno=00004 name=+DG1/kvxcprd/datafile/users.267.777756857
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=2 sequence=17 recid=26 stamp=810915691
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/24/2013 14:37:11
ORA-19599: block number 1985 is corrupt in archived log +FG/kvxcprd/archivelog/2013_03_24/thread_2_seq_17.269.810915689
rman> delete archivelog '+FG/kvxcprd/archivelog/2013_03_24/thread_2_seq_17.269.810915689';