Hi, I am getting the following message when i try to start my database:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 2
ORA-08103: object no longer exists
Thu Oct 07 02:58:45 2004
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 736
I moved the datafiles to a new location and had this problem:
SQL> alter database rename file 'C:\ORACLE\ORADATA\TRAIN1\UNDOTBS01.DBF' to 'E:\
SQL> alter database open;
alter database open
ERROR at line 1:
ORA-01122: database file 2 failed verification check
ORA-01110: data file 2: 'E:\ORACLE\ORADATA\TRAIN1\UNDOTBS011.DBF'
ORA-01251: Unknown File Header Version read for file number 2
ORA-1092 signalled during: ALTER DATABASE OPEN...
I dropped the datafile and now have the problem above. I cannot restore the UNDOTBS011.DBF.
Is there anyway to get around this?
1) Create new UNDO tablespace, make it the default.
2) Say goodbye to anything you had in the previous UNDO tablespace. Then get rid of it.
3) Make sure you have a good backup & recovery plan/system. What do you think happens to a tablespace when you whack one of its datafiles? You're lucky you didn't do this to a relevant data type of datafile.
4) Read, study, learn. Which Oracle DBA reference book do you own?
Have you tried recreating the control file? do an alter database backup controlfile to trace; Find the file that was created in you bdump folder and edit it. Take out all of the comments and references to your undo tablespace and then run that against the database as sys. But make sure that you set UNDO_MANAGEMENT = manual;
This should remove the missing tablespace from your database, you should then be able to open the database and recreate the undo tablespace and change UNDO_MANAGEMENT = auto;