使用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
原创
©著作权归作者所有:来自51CTO博客作者心神cgr的原创作品,请联系作者获取转载授权,否则将追究法律责任
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
RMAN 系列(七) ---- RMAN 维护
<br />这篇资料主要讲到了如下内容:<br />1. Rman 的维护<br />2. 恢复目录的维护
数据库 脚本 delete disk 存储