Skip to Main Content

Database Software

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!

Error "ORA-01589: must use RESETLOGS or NORESETLOGS option for database open " occurred while starti

2723683Aug 15 2014 — edited Sep 9 2014

I am trying to open a DR database after a Primary control file being restored in DR. As well as DR being restored. When the Database was started following was observed.

SQL> startup

ORACLE instance started.

Total System Global Area 1570009088 bytes

Fixed Size                  2228704 bytes

Variable Size            1006636576 bytes

Database Buffers          553648128 bytes

Redo Buffers                7495680 bytes

Database mounted.

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

SQL> alter database open NORESETLOGS ;

alter database open NORESETLOGS

*

ERROR at line 1:

ORA-01588: must use RESETLOGS option for database open

I got stuck over here please help.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2014
Added on Aug 15 2014
7 comments
14,279 views