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;
ORA-19909: datafile 1 belongs to an orphan incarnation
来源:这里教程网
时间:2026-03-03 13:53:25
作者:
编辑推荐:
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- Oracle数据库不同损坏级别的恢复详解
Oracle数据库不同损坏级别的恢复详解
26-03-03 - oracle修改用户密码的方法
oracle修改用户密码的方法
26-03-03 - Oracle RAC+DG环境搭建(CentOS 7+Oracle 12C)( 十) 部署 DataGuard
- Oracle 12C单实例环境下 GoldenGate 12C的单向复制模式的搭建部署
- Debian依赖关系问题解决(新手也能轻松修复apt和dpkg依赖错误)
Debian依赖关系问题解决(新手也能轻松修复apt和dpkg依赖错误)
26-03-03 - ORACLE for windows 审计文件xml文件过多导致数据库启动报错ORA-09925
- Oracle启动两个监听
Oracle启动两个监听
26-03-03 - 11g ADG 出现FAL[client,USER]:error 12154 connect to orcl for fetching gap
- Oracle中的12C新特性-容器数据库概念-基本操作
Oracle中的12C新特性-容器数据库概念-基本操作
26-03-03 - Debian模型评估指标(在Debian系统中计算机器学习模型性能的完整指南)
