使用rman应用归档时的报错问题
starting media recovery
media recovery failed
released channel: c0
released channel: c1
released channel: c2
released channel: c3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/16/2018 16:21:59
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '+DATA/xxx/datafile/system.286.995036877'
登陆到rman中
RMAN> list incarnation of database;
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 CFCDB 1187042598 PARENT 1 10-MAY-08
2 2 CFCDB 1187042598 PARENT 538113 06-JUL-10
3 3 CFCDB 1187042598 PARENT 6400217429 24-DEC-14
4 4 CFCDB 1187042598 CURRENT 103548227555 07-DEC-18
显示当前控制文件中记录了4个incarnation
从alert 日志中找到匹配的incarnation# 编号
Datafile 1 (ckpscn 105099829968) is orphaned on incarnation#=3
> reset database to incarnation 3
重新进行归档日志恢复
成功恢复
本文标题:rman-incarnation
文章起源:
http://kswsj.cn/article/piehig.html