Database Backup and Recovery (MOSC)

MOSC Banner

after lost DB server , can't open DB  ORA-01092 ORA-01555:

We lost one of our old historical DB server , I found only the datafiles on the storage , I created new spfile and control file try to open database but got the following errors:

SQL> ALTER DATABASE OPEN;

 ALTER DATABASE OPEN * ERROR at line 1:

 ORA-01092: ORACLE instance terminated. Disconnection forced 

ORA-00704: bootstrap process failure 

ORA-00704: bootstrap process failure

 ORA-00604: error occurred at recursive SQL level 1 

ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8_4073472757$" too small Process ID: 11820 Session ID: 145 Serial number: 3

I tried to use the following parameters but still failed to open the database:
*.event="10015 trace name context forever, level 10:10513 trace name context forever, level 2:10511 trace name context forever, level 2"

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