Hi,
Our SAP system is down as undo tablespace PSAPUNDO got corrupted and needed recovery.
I have created a new undo table PSAPUNDO2 with the following commands:
SQL >create undo tablespace PSAPUNDO2 datafile 'D:\Oracle\SOL\sapdata1
\undo_2\UNDO.DATA2' size 700
and altered the system.
SQL>alter system set undo_tablespace=PSAPUNDO2 scope=spfile;
I have not dropped the pls tablespace PSAPUNDO.
Now as I try to restart oracle I cannot restart it normally and getting the error:
ora-01092: oracle instance terminated. disconnection forced
So I have given the command:
shutdown immediate
> startup mount
> alter database open
and got the same error:
ora-01092: oracle instance terminated. disconnection forced
Last few lines of the alert log is as follows:
Thu Jan 03 21:29:51 2013
Errors in file d:\oracle\sol\saptrace\background\sol_lgwr_8340.trc:
ORA-30012: undo tablespace '' does not exist or of wrong type
Thu Jan 03 21:29:51 2013
Errors in file d:\oracle\sol\saptrace\background\sol_dbw0_10200.trc:
ORA-30012: undo tablespace '' does not exist or of wrong type
Thu Jan 03 21:29:51 2013
Errors in file d:\oracle\sol\saptrace\background\sol_mman_5852.trc:
ORA-30012: undo tablespace '' does not exist or of wrong type
Thu Jan 03 21:29:51 2013
Errors in file d:\oracle\sol\saptrace\background\sol_psp0_8576.trc:
ORA-30012: undo tablespace '' does not exist or of wrong type
Thu Jan 03 21:29:52 2013
Instance terminated by USER, pid = 9792
ORA-1092 signalled during: ALTER DATABASE OPEN...
Edited by: 979935 on Jan 4, 2013 6:24 AM