Symptom
After restoring and recovering a database, when trying to open with resetlogs option, it fails with error below:
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-30012: undo tablespace 'PSAPUNDO' does not exist or of wrong type
Process ID: 9381
Session ID: 207 Serial number: 43771
Read more...
Environment
- Oracle RDBMS any version
- Not restricted to any OS platform
- Not restricted to any SAP Product
Product
SAP NetWeaver all versions
Keywords
KBA , BC-DB-ORA-DBA , Database Administration , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview