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 |
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 |
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 |
Free forum by Nabble | Edit this page |