rman 恢复数据库一个小时多了也没有动静 implicit crosscheck

The Problem

After restoring a controlfile, the restore database can take a long time to restore due to implicit croscchecking and cataloging.

RMAN> restore database;

RMAN-03090: Starting implicit crosscheck backup at 2012/10/05 01:56:55
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=63 device type=DISK
RMAN-06206: Crosschecked XXXX  objects                               ------> Time taken <------
RMAN-03091: Finished implicit crosscheck backup at 2012/10/05 02:57:02

RMAN-03090: Starting implicit crosscheck copy at 2012/10/05 02:57:02
RMAN-12016: using channel ORA_DISK_1                                 ------> Time taken <-------
RMAN-03091: Finished implicit crosscheck copy at 2012/10/05 03:57:02

RMAN-07501: searching for all files in the recovery area
RMAN-07507: cataloging files...
RMAN-07508: cataloging done

The Solution

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.

It is not uncommon to have 1000’s of records stored within the controlfile that will require crosschecking. Once the crosschecking is complete RMAN continues with cataloging the fast recovery area. This task can potentially take hours to complete. Further, if a new incarnation is introduced you may have issues with recovery due to the orphaned incarnation.

The workarounds:

  1. disable the fast recovery area (FRA).

SQL> alter system set db_recovery_file_dest=’’ scope=both;

Remember to re-enable the FRA at a later point once the restore (or recovery) is completed.

OR

  1. Remove the old files/unnecessary files from the FRA. Please note in 11gr2 you have the option to specify incarnation.
姚远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
已标记关键词 清除标记
相关推荐
©️2020 CSDN 皮肤主题: Age of Ai 设计师:meimeiellie 返回首页