RMAN backup issue

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

RMAN backup issue

karthikmca.bhc
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
Reply | Threaded
Open this post in threaded view
|

Re: RMAN backup issue

ErmanArslansOracleBlog
Administrator
This is an EBS 12.1 I guess..
So, this issue is already documented and adressed.
You should follow MOS Note : More than 20000 Blocks Corrupted in system09.dbf After Fresh Installation of E-Business Suite R12.1.1 on Linux x86_64 Platform (Doc ID 840963.1)

Basically, you will do -> alter database datafile '<DIR>/db/apps_st/data/system09.dbf' resize 1000M;
or you will use the latest rapidwiz version as per MOS Note:798258.1
Reply | Threaded
Open this post in threaded view
|

Re: RMAN backup issue

karthikmca.bhc
Thanks Erman for the valuable resolutions which really worked and my issue is resolved by below in my fresh R12.1.1 instance.

alter database datafile '<DIR>/db/apps_st/data/system09.dbf' resize 1000M;


The same solution doesnt work on the 12.1.3 appliance which oracle supplied.

Thanks once again.

Regards,
Karthik