Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Database corruption in "system09.dbf" file

edited Aug 20, 2021 9:33AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered ✓
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.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center