Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

alter database open - fails | no resetlogs

513342Oct 26 2006 — edited Feb 15 2007
I´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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 15 2007
Added on Oct 26 2006
23 comments
3,211 views