Dear Legends,
I'm not able to recover Oracle DB 10gR2 in windows XP 32bit without UNDO Table space. Since my UNDO Tablespace has been corrupted and went to 0bytes, it happens due to OS Filesystem check.
Tries so for,
1. Deleted the 0bytes UNDO TBS and tried to restore UNDO TBS from Production to Test - failed, following are the error
sql> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF'
Process ID:0
Session ID: 159 Serial number: 3
Tried deleting the UNDO TBS by offfline drop and also manual delete. I used various references as follows
1.
1061824
2.
936567
3.
263461
4. http://practical-tech.blogspot.in/2011/07/undo-tablespace-recovery-in-case-of-no.html
5. http://www.iselfschooling.com/mc4articles2/undotbs-recovery.htm
6. http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5669213349582
7. http://colbran.co.za/wordpress/open-a-database-without-the-undo-tablespace/
like these I have tried using metalink also. All resources say that I have to open the Database, where in my case it is not possible.
Waiting for a solution, Any kind of help would be appreciated much.
Thanks in advance
Regards,
Karthik