I lost datafiles of rollback segment of Test DB and it is closed now => I can not drop the tablespace.
Database was not in archive log mode, but lossing of last changes is OK.
What is the best way to get database opened?
So far I used 'CREATE CONTROLFILE' with entries for lost files removed, but got an error on 'ALTER DATABASE OPEN RESETLOGS':
SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'G:\ORACLE\ORADATA\ORCC\SYSTEM01.DBF'
I have no cold backup (DB crashed before it was made but after it was created and application schema installed)
So is there a method to get rid of this error
"ORA-01194: file 1 needs more recovery to be consistent "?
What does is actually indicate?
well if lnd didnt shutdown the database with abort option he might as well drop the datafile with offline drop option then open the database and drop the rbs tablespace, at least with this he might have a chance to open the database...
Actually, the database (and OS) crashed.
The status is that I have all datafiles+control file except of rollback tablespace.
P.S. Generally this recovery is not a big deal, I just want to save some work and make some things more clear regarding db recovery.
What I do not understand is
why Oracle requires recovery for datafile when I try to open database. What in general should happen for this condition?
All considerations including some view into Oracle internals is welcommed.