How to open a database without resetlogs

You do a restore of backup where online logs are present.

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

If you recreate the controlfile after startup nomount, the DB would open without needing RESETLOGS;

SQL> alter database backup controlfile to trace;

SQL> startup nomount

Note: rename OLD

controlfiles prior to re-creating the controlfile.

--------------control.sql -------------

CREATE CONTROLFILE

REUSE DATABASE "V102" NORESETLOGS ARCHIVELOG

MAXLOGFILES 50

MAXLOGMEMBERS 5

MAXDATAFILES 100

MAXINSTANCES

1

MAXLOGHISTORY 226

LOGFILE

GROUP 1 '/just11i/dbdata/redo01.log' SIZE 100M,

GROUP 2 '/just11i/dbdata/redo02.log' SIZE 100M,

GROUP

3 '/just11i/dbdata/redo03.log' SIZE 100M

-- STANDBY LOGFILE

DATAFILE

'/just11i/dbdata/system01.dbf',

'/just11i/dbdata/undotbs01.dbf',

'/just11i/dbdata/cwmlite01.dbf',

'/just11i/dbdata/drsys01.dbf',

'/just11i/dbdata/example01.dbf',

'/just11i/dbdata/indx01.dbf',

'/just11i/dbdata/odm01.dbf',

'/just11i/dbdata/tools01.dbf',

'/just11i/dbdata/users01.dbf',

'/just11i/dbdata/xdb01.dbf'

CHARACTER

SET WE8ISO8859P1

;

SQL> @/tmp/control.sql

Control file created.

SQL> alter database open;

Database altered.