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.

5 comments:

  1. Thank you for your post! It helped

    ReplyDelete
  2. 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
  3. Thanks a lot!!!

    ReplyDelete