Home » RDBMS Server » Backup & Recovery » ORA-01139: RESETLOGS option only valid after an incomplete database recovery (oracle 11.2.0.3 on linux 2.6.18-274.el5)
ORA-01139: RESETLOGS option only valid after an incomplete database recovery [message #585074] Tue, 21 May 2013 14:52 Go to next message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
restored from tape a backup then issued rman command

RMAN> restore database;

Starting restore at 21-MAY-13
Finished restore at 21-MAY-13

RMAN> alter database open;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 05/21/2013 15:36:15
ORA-01190: control file or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/u02/oradata/system01.dbf'

from a trc file
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
Successfully dispatched
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----

*** 2013-05-21 15:40:02.461
Completed Media Recovery
Slave exiting with ORA-283 exception
ORA-00283: recovery session canceled due to errors
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '/u02/oradata/system01.dbf'
Re: ORA-01139: RESETLOGS option only valid after an incomplete database recovery [message #585089 is a reply to message #585074] Wed, 22 May 2013 00:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-19909: datafile %s belongs to an orphan incarnation
 *Cause: Either the specified datafile was restored from a backup that was
         taken during a period of time that has already been discarded by
         a RESETLOGS operation, or Oracle cannot identify which database
         incarnation the file belongs to.  The alert log contains more
         information.
 *Action: Restore a backup of this file that belongs to either the current
          or a prior incarnation of the database.  If you are using RMAN
          to restore, RMAN will automatically select a correct backup.

Regards
Michel
Re: ORA-01139: RESETLOGS option only valid after an incomplete database recovery [message #585197 is a reply to message #585074] Wed, 22 May 2013 22:28 Go to previous message
Markwillium
Messages: 13
Registered: December 2010
Location: India
Junior Member
See if it can help you
http://tinyurl.com/nhqkyx9
Previous Topic: ORA-19809: limit exceeded for recovery files
Next Topic: indexes of sysman
Goto Forum:
  


Current Time: Thu Mar 28 10:49:23 CDT 2024