千家信息网

rman-incarnation

发表于:2025-02-04 作者:千家信息网编辑
千家信息网最后更新 2025年02月04日,使用rman应用归档时的报错问题starting media recoverymedia recovery failedreleased channel: c0released channel: c1
千家信息网最后更新 2025年02月04日rman-incarnation
使用rman应用归档时的报错问题starting media recoverymedia recovery failedreleased channel: c0released channel: c1released channel: c2released channel: c3RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of recover command at 12/16/2018 16:21:59ORA-00283: recovery session canceled due to errorsRMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed start until cancel using backup controlfileORA-00283: recovery session canceled due to errorsORA-19909: datafile 1 belongs to an orphan incarnationORA-01110: data file 1: '+DATA/xxx/datafile/system.286.995036877'登陆到rman中RMAN> list incarnation of database;using target database control file instead of recovery catalogList of Database IncarnationsDB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time------- ------- -------- ---------------- --- ---------- ----------1       1       CFCDB    1187042598       PARENT  1          10-MAY-082       2       CFCDB    1187042598       PARENT  538113     06-JUL-103       3       CFCDB    1187042598       PARENT  6400217429 24-DEC-144       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重新进行归档日志恢复成功恢复


0