Database Backup and Recovery (MOSC)

MOSC Banner

urgent, system file (system01.dbf) error, how to fix it and exp data?

edited Mar 20, 2012 8:03AM in Database Backup and Recovery (MOSC) 2 commentsAnswered
our db is running without backup, and today our db was broken by disk error, after fixed disk issue, I try to start db and then exp data and create a new db.

after recover database until cancel and startup db with _allow_resetlogs_corruption=true ,now db can be opened, but can not do shutdown with error ora-600 [4193], [31358], [31362], [], [], [], [], [] and ORA-00604,ORA-01578 Oracle data block corrupted(file 1,block#60322),ORA-01110: datafile 1: d:\oradata\system01.dbf . and now I can not create any object, it was failed with error ora-600 [kcbgcur_9].

pls help me, how to fix this issue and export my data?my db version is 10.2.0.1 and os is win2003 sp2. thanks a lot.

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