RMAN 恢复的时候出错RMAN-06091

RMAN 恢复的时候出错RMAN-06091

RMAN-03023: executing command: SET DBID

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: SID=10 device type=SBT_TAPE
RMAN-08526: channel c1: DBackup3 Oracle MMS Library

RMAN-03023: executing command: SET COMMAND ID

RMAN-03090: Starting restore at 2020-07-23 16:12:28

RMAN-08021: channel c1: restoring control file
RMAN-08180: channel c1: restore complete, elapsed time: 00:00:01
RMAN-08505: output file name=/data/oradata/amlprod/control01.ctl
RMAN-08505: output file name=/data/fast_recovery_area/amlprod/control02.ctl
RMAN-03091: Finished restore at 2020-07-23 16:12:29
RMAN-08031: released channel: c1

RMAN> 
RMAN> 
RMAN-08066: database reset to incarnation 4

RMAN> 
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: SID=10 device type=SBT_TAPE
RMAN-08526: channel c1: DBackup3 Oracle MMS Library

RMAN-03023: executing command: SET COMMAND ID

RMAN-03023: executing command: SET until clause

RMAN-03090: Starting restore at 2020-07-23 16:12:39
RMAN-03090: Starting implicit crosscheck backup at 2020-07-23 16:12:39
RMAN-03091: Finished implicit crosscheck backup at 2020-07-23 16:12:40

RMAN-03090: Starting implicit crosscheck copy at 2020-07-23 16:12:40
RMAN-08031: released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/23/2020 16:12:40
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

从进度提示看implicit crosscheck backup成功,implicit crosscheck copy 失败。

The implicit crosscheck and cataloging are only seen when using the fast recovery area. When using a restored controlfile to restore the database, we need to ensure that the controlfile metadata is still correct. So RMAN automatically crosschecks all backups and catalogs the flash recovery area. This is a one-time operation. So the first time a restore of any datafile is initiated, we will crosscheck and catalog the backup pieces. Subsequent restores from the same controlfile will not kick off the crosscheck and catalog operation.

根据metalink的文档, Document 2428682.1 , 这个可能是个bug:

After applying July (DBPSU/BP/RU) patch on 11.2.0.4,12.1.0.2,12.2,or 18.2 RMAN script fails with
RMAN-06091: NO CHANNEL ALLOCATED FOR MAINTENANCE (OF AN APPROPRIATE TYPE)
This issue has been reported on 11.2.0.4,12.1.0.2,12.2, and 18.2.
RMAN-08031:
RMAN-00571:
RMAN-00569:
RMAN-00571:
RMAN-03002:
RMAN-06091:
released channel:t1
===========================================================
=============== ERROR MESSAGE STACK FOLLOWS ===============
===========================================================
failure of delete command at 07/24/2018 08:26:03
no channel allocated for maintenance (of an appropriate type)
CAUSE
Issue is reported in Bug 28391990, which has been superseded by the fix of unpublished Bug 28432129:
Bug 28432129: RMAN-06091: no channel allocated for maintenance (of an appropriate type) after installing July 2018 (DBPSU/BP/RU) (Note
28432129.8)
Fixed Version : 19.1

SOLUTION
Check for an available patch within the 'Patches and Updates' area. Search for 28432129 as your Patch Name/Number
and select your platform.
Download and apply the appropriate patch for your version.
If a patch does not exist, log an SR requesting one.
If you cannot apply the patch, you can work around this issue by explicitly allocating the channel needed by the
maintenance command.

打补丁比较麻烦,而且不确定100%的能解决问题,文档建议是显式地分配一个maintenance channel。但这个办法在我们这里不好用,取消recovery area,不让implicit crosscheck 可能是个解决方案:
alter system set db_recovery_file_dest=’’ scope=both;
试了一下,成功的开始了恢复,但又报log_archive_dest_1参数错,原来这个参数是被设置成基于db_recovery_file_dest参数,改成绝对路径即可。

姚远ACE CSDN认证博客专家 ACE 华为云 MVP
Oracle ACE,华为云 MVP,Oracle10g,12c OCM; MySQL 5.6,5.7,8.0 OCP;CCNA; EMC Certified; IBM P Certified; RHCE; SQLServer 764; DB2 Certified; TOEIC 890;获得过两次国家部级科技进步奖;发明过两项计算机专利。微信:yaoyuanace 邮箱:yaoyuanace(at)qq.com
已标记关键词 清除标记
相关推荐
<p> <b><span style="background-color:#FFE500;">【超实用课程内容】</span></b> </p> <p> <br /> </p> <p> <br /> </p> <p> 本课程内容包含讲解<span>解读Nginx的基础知识,</span><span>解读Nginx的核心知识、带领学员进行</span>高并发环境下的Nginx性能优化实战,让学生能够快速将所学融合到企业应用中。 </p> <p> <br /> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <b><br /> </b> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <b><span style="background-color:#FFE500;">【课程如何观看?】</span></b> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> PC端:<a href="https://edu.csdn.net/course/detail/26277"><span id="__kindeditor_bookmark_start_21__"></span></a><a href="https://edu.csdn.net/course/detail/27216">https://edu.csdn.net/course/detail/27216</a> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 移动端:CSDN 学院APP(注意不是CSDN APP哦) </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 本课程为录播课,课程永久有效观看时长,大家可以抓紧时间学习后一起讨论哦~ </p> <p style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <br /> </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <strong><span style="background-color:#FFE500;">【学员专享增值服务】</span></strong> </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <b>源码开放</b> </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 课件、课程案例代码完全开放给你,你可以根据所学知识,自行修改、优化 </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 下载方式:电脑登录<a href="https://edu.csdn.net/course/detail/26277"></a><a href="https://edu.csdn.net/course/detail/27216">https://edu.csdn.net/course/detail/27216</a>,播放页面右侧点击课件进行资料打包下载 </p> <p> <br /> </p> <p> <br /> </p> <p> <br /> </p>
©️2020 CSDN 皮肤主题: Age of Ai 设计师:meimeiellie 返回首页