alter database open - fails | no resetlogs
513342Oct 26 2006 — edited Feb 15 2007I´ve damaged controlfile01.dbf and system01.dbf (just testing around on testdb) and recovered them without any problems. Now I just want to alter my database into open mode and get this error:
SQL> startup mount;
ORACLE instance started.
Total System Global Area 2485096400 bytes
Fixed Size 745424 bytes
Variable Size 1677721600 bytes
Database Buffers 805306368 bytes
Redo Buffers 1323008 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
I´ve googled around and found some good answers, but - i still got a problem.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
JServer Release 9.2.0.7.0 - Production
SQL> select log_mode from v$database;
LOG_MODE
------------
ARCHIVELOG
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 1032442852 generated at 10/20/2006 15:05:38 needed for thread
1
ORA-00289: suggestion : /oracle/logs/cs2p/archive/1_915.dbf << 1_915 does not exist
ORA-00280: change 1032442852 for thread 1 is in sequence #915
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/oracle/logs/cs2p/archive/1_914.dbf << set by me
ORA-00310: archived log contains sequence 914; sequence 915 required
ORA-00334: archived log: '/oracle/logs/cs2p/archive/1_914.dbf'
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 2 needs more recovery to be consistent
ORA-01110: data file 2: '/oracle/orasys/cs2p/undotbs01.dbf'
So how do I recreate undotbs01.dbf? I haven´t damaged it in any way...
Thanks for your help!
Kind regards,
Thomas