Thursday, 2 May 2013

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

You will receive an error ORA-01589 when you open database
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> shutdown abort;
SQL> startup mount;
$ rman target / catalog_user/catalog_user_password@catalogdb
RMAN> recover database;
SQL> alter database open resetlogs;
RMAN> reset database;

if you open database with resetlogs, SCN number will be zero. In this situation
all previous backups will be invalid. You must full backup.
Posted by at

5 comments:

  1. Anonymous9 August 2013 at 09:22

    Thank you for your post! It helped

    ReplyDelete
  2. Unknown12 August 2013 at 01:39

    Most welcome.

    ReplyDelete
  3. Nagaraj18 October 2013 at 01:31

    Thanks buddy

    ReplyDelete
  4. Unknown21 February 2014 at 08:51

    hi brother ,how are you. i want to know about TKPROOF,sqltrace,costbased optimiztion.how they can used in oracle 11g r2. please kindly send the real time time sceniarious to my maild :gurajanaramesh375@gmail.com.

    ReplyDelete
  5. Anonymous30 January 2015 at 08:03

    Thanks a lot!!!

    ReplyDelete

Subscribe to: Post Comments (Atom)