ORA-19909: datafile 1 belongs to an orphan incarnation

来源:这里教程网 时间:2026-03-03 13:53:25 作者:

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;

相关推荐