This is how I solved the problem. ORA-01033 [message #421603] |
Wed, 09 September 2009 06:22 |
kikenovic
Messages: 1 Registered: September 2009 Location: Indiana
|
Junior Member |
|
|
Cowa, thanks a lot!!! you saved my life, thanks for posting your solution.
Here is my story:
SQL> connect / as sysdba
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 823207056 bytes
Fixed Size 455824 bytes
Variable Size 612368384 bytes
Database Buffers 209715200 bytes
Redo Buffers 667648 bytes
SQL> alter database mount;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: 'D:\ORACLE\ORADATA\PCSF2\UNDOTBS01.DBF
SQL> recover datafile 'D:\ORACLE\ORADATA\PCSF2\UNDOTBS01.DBF';
Media recovery complete.
SQL> alter database open;
Database altered.
SQL>
After that, everything went back to normal.
|
|
|
|