ORA-01177 ON OPEN RESETLOGS AFTER SUCCESSFUL POINT-IN-TIME RECOVERY (Doc ID 1439908.1)

Last updated on APRIL 21, 2015

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 to 11.2.0.3 - Release: 11.2 to 11.2
Information in this document applies to any platform.

Goal

After successful point-in-time restore and recover operation, an error is raised on open resetlogs for a datafile that does not get restored:

RMAN> run {
2> set until time "to_date('22-MAR-2012 01:24:09', 'DD-MON-YYYY HH24:MI:SS')";
3> restore database;
4> recover database;
5> alter database open resetlogs;
6> }
...
channel ORA_SBT_TAPE_1: restoring datafile 00001 to D:\APP\ORACLE\ORADATA\ORCL\SY
STEM01.DBF
channel ORA_SBT_TAPE_1: restoring datafile 00002 to D:\APP\ORACLE\ORADATA\ORCL\SY
SAUX01.DBF
channel ORA_SBT_TAPE_1: restoring datafile 00004 to D:\APP\ORACLE\ORADATA\ORCL\PA
TROL_DATA01.DBF
channel ORA_SBT_TAPE_1: restoring datafile 00005 to D:\APP\ORACLE\ORADATA\ORCL\US
ERS01.DBF
channel ORA_SBT_TAPE_1: reading from backup piece db_bak_245_1_778554117
channel ORA_SBT_TAPE_1: piece handle=db_bak_245_1_778554117 tag=FULL_DB_BACKUP_T
O_BUR
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:02:46
channel ORA_SBT_TAPE_1: starting datafile backup set restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_SBT_TAPE_1: restoring datafile 00003 to E:\APP\ORACLE\ORADATA\ORCL\UN
DOTBS01.DBF
channel ORA_SBT_TAPE_1: restoring datafile 00006 to D:\APP\ORACLE\ORADATA\ORCL\HP
OM_DATA01.DBF
channel ORA_SBT_TAPE_1: restoring datafile 00007 to D:\APP\ORACLE\ORADATA\ORCL\AU
...
archived log file name=F:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2012_03_
22\O1_MF_1_277_7PPC2842_.ARC RECID=191 STAMP=778585352
archived log file name=F:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2012_03_
22\O1_MF_1_278_7POTMOCJ_.ARC thread=1 sequence=278
media recovery complete, elapsed time: 00:00:00
Finished recover at 22-MAR-12

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
ORA-03114: not connected to ORACLE
RMAN-03002: failure of alter db command at 03/22/2012 09:43:52
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01177: data file does not match dictionary - probably old incarnation
ORA-01110: data file 9: 'E:\APP\ORACLE\ORADATA\ORCL\USER_CONFIG_01.DBF'
Process ID: 2676
Session ID: 2740 Serial number: 10
ORACLE error from target database:
ORA-03114: not connected to ORACLE


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms