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"