rman-incarnation-创新互联
使用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://mswzjz.cn/article/dhophe.html
另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。
网站名称：rman-incarnation-创新互联
文章网址：http://mswzjz.cn/article/dhophe.html