ORA-19909: datafile 1 belongs to an orphan incarnation

ORA-19909: datafile 1 belongs to an orphan incarnation

ORA-01110: data file 1: '+DATA/lvdb_yt/datafile/system.434.969694045'

Managed Standby Recovery not using Real Time Apply

Wed Jun 19 16:37:04 2019

Data Mining and Real Application Testing options

[oracle@yt-rac1 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Jun 20 09:59:51 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: XXDB (DBID=3142346740)

RMAN>  list incarnation;

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       XXDB     3142346740       PARENT  1          24-AUG-13

2       2       XXDB     3142346740       PARENT  925702     06-MAR-17

3       3       XXDB     3142346740       CURRENT 41369544169 17-JUN-19

RMAN> reset database to incarnation 2;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of reset database command on default channel at 06/20/2019 10:00:08

ORA-19910: can not change recovery target incarnation in control file

RMAN> exit

Recovery Manager complete.

[oracle@yt-rac1 ~]$ ps -ef|grep LOCAL=NO

oracle    56712      1  0 09:11 ?        00:00:00 oracleXXDB3 (LOCAL=NO)

oracle    60368      1  1 Jun19 ?        00:14:32 oracleXXDB3 (LOCAL=NO)

oracle    60370      1  2 Jun19 ?        00:30:43 oracleXXDB3 (LOCAL=NO)

oracle    71435      1  0 09:23 ?        00:00:02 oracleXXDB3 (LOCAL=NO)

oracle   110235      1  4 09:55 ?        00:00:12 oracleXXDB3 (LOCAL=NO)

oracle   116790  36536  0 10:00 pts/0    00:00:00 grep LOCAL=NO

[oracle@yt-rac1 ~]$ s

-bash: s: command not found

[oracle@yt-rac1 ~]$ 

[oracle@yt-rac1 ~]$ 

[oracle@yt-rac1 ~]$ 

[oracle@yt-rac1 ~]$ 

[oracle@yt-rac1 ~]$ 

[oracle@yt-rac1 ~]$ ora sim

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 20 13:51:21 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> shut immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 1.2827E+11 bytes

Fixed Size                  2269072 bytes

Variable Size            3.5702E+10 bytes

Database Buffers         9.1805E+10 bytes

Redo Buffers              764678144 bytes

Database mounted.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

[oracle@yt-rac1 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Jun 20 13:52:54 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: XXDB (DBID=3142346740, not open)

RMAN> list incarnation;

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       xxDB     3142346740       PARENT  1          24-AUG-13

2       2       xxDB     3142346740       PARENT  925702     06-MAR-17

3       3       xxDB     3142346740       CURRENT 41369544169 17-JUN-19

RMAN>  reset database to incarnation 2;

database reset to incarnation 2

RMAN> 

RMAN> 

recover database;