你在这里

Oracle DB force open failing

Posted by PDSERVICE on 7月 21, 2021 In

We are unable to open the DB with force option. We are getting below errors.

alter database open

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

alter database open resetlogs

ERROR at line 1:

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00604: error occurred at recursive SQL level 1

ORA-01555: snapshot too old: rollback segment number with name "" too small

Error 604 happened during db open, shutting down database

USER: terminating instance due to error 604

Instance terminated by USER, pid = 24632

ORA-1092 signalled during: alter database open resetlogs...

We can provide two recovery options:

1. We provide remote assistance , help you fix the ORA-01555 problem , and online the tablespace .

2. We provide dbrecover for oracle , the software can read the offline datafile , and retrive the data . This option takes 1350 USD.

Let me know if you're interested.