4 Replies Latest reply: Aug 7, 2010 5:29 AM by CKPT RSS

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

    user645399
      Dear Buddies,

      I am trying to recover my database to a certain time and after I performed some catalog (for my backups and arch files), now I see this error. Earlier I had errors on some datafiles missing.

      Can I perform
      alter database open resetlog
      and then recover my database to a certain time?
      Microsoft Windows [Version 5.2.3790]
      (C) Copyright 1985-2003 Microsoft Corp.
      
      C:\Documents and Settings\Administrator>set oracle_sid=dev
      
      C:\Documents and Settings\Administrator>sqlplus /nolog
      
      SQL*Plus: Release 10.2.0.1.0 - Production on Sat Aug 7 10:13:03 2010
      
      Copyright (c) 1982, 2005, Oracle.  All rights reserved.
      
      SQL> conn sys as sysdba
      Enter password:
      Connected.
      SQL> select open_mode from v$database;
      
      OPEN_MODE
      ----------
      MOUNTED
      
      SQL> alter database open;
      alter database open
      *
      ERROR at line 1:
      ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
      
      
      SQL> $rman target /
      
      Recovery Manager: Release 10.2.0.1.0 - Production on Sat Aug 7 10:18:20 2010
      
      Copyright (c) 1982, 2005, Oracle.  All rights reserved.
      
      connected to target database: DEV (DBID=2455006062, not open)
      
      RMAN> list incarnation
      2> ;
      
      using target database control file instead of recovery catalog
      
      List of Database Incarnations
      DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
      ------- ------- -------- ---------------- --- ---------- ----------
      1       1       DEV  2455006062       CURRENT 14434273   09-APR-10
      2       2       DEV  2455006062       ORPHAN  14770169   09-APR-10
      
      RMAN>