RMAN backup issue

Posted by karthikmca.bhc on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/RMAN-backup-issue-tp8829.html

Hi Support,

My rman backup is running for very long time and when i check the alert.log that shows below entries. Please provide workaround/fix.

run
{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
allocate channel c5 device type disk;
crosscheck archivelog all;
crosscheck backup;
sql 'alter system switch logfile';
sql 'alter system archive log current';
set maxcorrupt for datafile 352 to 9999;
backup tag 'EUDEMO_RMAN_BACKUP' as compressed backupset format '/rman_backup/%D%M%Y/rman_db_%s_%d_%D_%U.dbf' database include current controlfile plus archivelog delete input;
sql 'alter system switch logfile';
delete noprompt obsolete recovery window of 183 days;
crosscheck backup;
crosscheck archivelog all;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
}

Alert Log:
-----------
Thu Oct 01 22:26:07 2020
Hex dump of (file 352, block 167087) in trace file /u01/oracle/db/tech_st/12.1.0.1/admin/demo_eudemo/diag/rdbms/demo/demo/trace/demo_ora_3981.trc

Corrupt block relative dba: 0x58028caf (file 352, block 167087)
Completely zero block found during validation

Reread of blocknum=167087, file=/u01/oracle/db/apps_st/data/system09.dbf. found same corrupt data
Reread of blocknum=167087, file=/u01/oracle/db/apps_st/data/system09.dbf. found same corrupt data
Reread of blocknum=167087, file=/u01/oracle/db/apps_st/data/system09.dbf. found same corrupt data
Reread of blocknum=167087, file=/u01/oracle/db/apps_st/data/system09.dbf. found same corrupt data
Reread of blocknum=167087, file=/u01/oracle/db/apps_st/data/system09.dbf. found same corrupt data
Thu Oct 01 22:26:35 2020
Incremental checkpoint up to RBA [0x30.37483.0], current log tail at RBA [0x30.38474.0]
Thu Oct 01 22:27:00 2020
Hex dump of (file 352, block 167088) in trace file /u01/oracle/db/tech_st/12.1.0.1/admin/demo_eudemo/diag/rdbms/demo/demo/trace/demo_ora_3981.trc

Corrupt block relative dba: 0x58028cb0 (file 352, block 167088)
Completely zero block found during validation

Reread of blocknum=167088, file=/u01/oracle/db/apps_st/data/system09.dbf. found same corrupt data
Reread of blocknum=167088, file=/u01/oracle/db/apps_st/data/system09.dbf. found same corrupt data
Reread of blocknum=167088, file=/u01/oracle/db/apps_st/data/system09.dbf. found same corrupt data
Reread of blocknum=167088, file=/u01/oracle/db/apps_st/data/system09.dbf. found same corrupt data
Reread of blocknum=167088, file=/u01/oracle/db/apps_st/data/system09.dbf. found same corrupt data
Thu Oct 01 22:27:52 2020
Hex dump of (file 352, block 167089) in trace file /u01/oracle/db/tech_st/12.1.0.1/admin/demo_eudemo/diag/rdbms/demo/demo/trace/demo_ora_3981.trc

Corrupt block relative dba: 0x58028cb1 (file 352, block 167089)
Completely zero block found during validation

Reread of blocknum=167089, file=/u01/oracle/db/apps_st/data/system09.dbf. found same corrupt data
Reread of blocknum=167089, file=/u01/oracle/db/apps_st/data/system09.dbf. found same corrupt data
Reread of blocknum=167089, file=/u01/oracle/db/apps_st/data/system09.dbf. found same corrupt data
Reread of blocknum=167089, file=/u01/oracle/db/apps_st/data/system09.dbf. found same corrupt data
Reread of blocknum=167089, file=/u01/oracle/db/apps_st/data/system09.dbf. found same corrupt data
Thu Oct 01 22:28:44 2020
Hex dump of (file 352, block 167090) in trace file /u01/oracle/db/tech_st/12.1.0.1/admin/demo_eudemo/diag/rdbms/demo/demo/trace/demo_ora_3981.trc