RAC+ASM在单机上恢复的过程

　2008-12-18 13:07:14　来源：WEB开发网　闂備線娼уΛ鎾箯閿燂拷

濠电姭鎷冮崨顓濈捕闂侀潧娲ゅú銊╁焵椤掍胶鈯曢柕鍥╁仧缁辩偤鏁撻敓锟�闂備線娼уΛ鎾箯閿燂拷　　闂備胶枪缁绘鈻嶉弴銏犳瀬闁绘劕鎼痪褔鏌曟繝蹇曠窗闁煎壊浜滈—鍐偓锝庡墮娴犙勭箾閸喎鐏ユい鏇樺劦椤㈡瑩鎮℃惔銇帮拷

核心提示： 6 由于在IBM4上记录的数据库，归档日志的备份集的存放路径与IBM1上的不一样，RAC+ASM在单机上恢复的过程(4)，故，需要说明在IBM1上这些备份集的路径，需要哪些数据文件备份集，归档日志文件的备份集，以便RMAN知晓，catalog backuppiece '/orada

6 由于在IBM4上记录的数据库，归档日志的备份集的存放路径与IBM1上的不一样，故，需要说明在IBM1上这些备份集的路径，以便RMAN知晓。

catalog backuppiece '/oradata/orabak/databackup/db_CCDB_900_1_20080620';

catalog backuppiece '/oradata/orabak/logbackup/log_CCDB_901_1_20080620';

7 检查备份集的存在状况，删除多余的备份集信息

crosscheck backup;

delete noprompt expired backup;

8 检查全库恢复时的，需要哪些数据文件备份集，归档日志文件的备份集。

restore database preview summary;

9 找出库的数据文件。

RMAN> report schema; RMAN-06139: WARNING: control file is not current for REPORT SCHEMA Report of database schema List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 0 SYSTEM *** +ASMDISK/ccdb/datafile/system.256.648572847 2 0 UNDOTBS1 *** +ASMDISK/ccdb/datafile/undotbs1.258.648572847 3 0 SYSAUX *** +ASMDISK/ccdb/datafile/sysaux.257.648572847 4 0 USERS *** +ASMDISK/ccdb/datafile/users.259.648572847 5 0 UNDOTBS2 *** +ASMDISK/ccdb/datafile/undotbs2.269.648572973 6 0 UNICALL2X *** +ASMDISK/ccdb/datafile/unicall2x.279.648578659 7 0 UNICALL2X_IDX *** +ASMDISK/ccdb/datafile/unicall2x_idx.280.648578725 List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1 0 TEMP 32767 +ASMDISK/ccdb/tempfile/temp.268.648572939