Database corruption in "system09.dbf" file
Hi AllI was migrating Oracle EBS single node database to RAC node Database during creating templet for current database I encountered error for data corruption.
I executed DBVERIFY utility and found more than block corruption in Datafile "system09.db"
DBVERIFY output summary follows.
DBVERIFY - Verification complete
Total Pages Examined : 192128
Total Pages Processed (Data) : 73992
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 36966
Total Pages Failing (Index): 0
Total Pages Processed (Other): 3955
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 50742
Total Pages Marked Corrupt : 26473
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 3090683342 (1389.3090683342)
Found metalink document "More than 20000 Blocks Corrupted in system09.dbf After Fresh Installation of E-Business Suite R12.1.1 on Linux x86_64 Platform [ID 840963.1]" explaining exectly same issue. Solution is reinstallation. But I cannot reinstall at this stage we have lot for data/implementation on our current EBS instance.
I executed DBVERIFY utility and found more than block corruption in Datafile "system09.db"
DBVERIFY output summary follows.
DBVERIFY - Verification complete
Total Pages Examined : 192128
Total Pages Processed (Data) : 73992
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 36966
Total Pages Failing (Index): 0
Total Pages Processed (Other): 3955
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 50742
Total Pages Marked Corrupt : 26473
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 3090683342 (1389.3090683342)
Found metalink document "More than 20000 Blocks Corrupted in system09.dbf After Fresh Installation of E-Business Suite R12.1.1 on Linux x86_64 Platform [ID 840963.1]" explaining exectly same issue. Solution is reinstallation. But I cannot reinstall at this stage we have lot for data/implementation on our current EBS instance.
Tagged:
0