ORA-19910 异常
2025-05-19 09:04:38 阅读次数:2
ORA,异常
问题描述:重置incarnation时,报错ORA-19910,如下所示:
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 ORCL 1642676218 PARENT 1 24-AUG-13
2 2 ORCL 1642676218 PARENT 925702 08-SEP-22
3 3 ORCL 1642676218 CURRENT 938040 08-SEP-22
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 09/09/2022 21:15:07
ORA-19910: can not change recovery target incarnation in control file
异常原因:重置到incarnation 2,需要到mount阶段执行.
RMAN> shutdown immediate
database closed
database dismounted
Oracle instance shut down
RMAN> startup mount;
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 1586708480 bytes
Fixed Size 2253624 bytes
Variable Size 989859016 bytes
Database Buffers 587202560 bytes
Redo Buffers 7393280 bytes
RMAN> reset database to incarnation 2;
database reset to incarnation 2
RMAN> alter database open;
database opened
版权声明:本文内容来自第三方投稿或授权转载,原文地址:https://blog.51cto.com/u_12991611/5666719,作者:Liujun_Deng,版权归原作者所有。本网站转在其作品的目的在于传递更多信息,不拥有版权,亦不承担相应法律责任。如因作品内容、版权等问题需要同本网站联系,请发邮件至ctyunbbs@chinatelecom.cn沟通。
上一篇:判断dmp文件的导出方式是exp or expdp
下一篇:地址与指针