从RAC恢复到单实例数据库操作步骤(五)
37
dbfull_31784_1_791697623是我们最新的全库备份，所以这里不需要注册全库备份集
B、查看归档日志备份集的备份信息是否完整
RMAN> list backup of archivelog all;
C、查看归档日志是否完整
D、如果恢复的控制文件中的备份信息不完整，则需要我们手工拷贝并注册到
控制文件中，如下：
控制文件中，如下：
注册备份集：
catalog backuppiece "/mnt/rmanbak/csora_rmanbackup/dbfull_31784_1_791697623";
注册归档日志：
单个归档文件注册：SQL > alter database register logfile '/var/arch/arch_1_101.arc';
注册整个归档目录：RMAN > catalog start with '/var/arch';
8、如果之前在RMAN中配置了默认通道，这里也要将这些配置清除，操作如下：
RMAN> configure channel 1 device type disk clear;
old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT ¨*¨;
old RMAN configuration parameters are successfully deleted
9、查看原来RAC库数据文件的位置，编辑脚本rename到新的位置
RMAN> report schema;
RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name CSORA
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 0 SYSTEM *** +DG1/csora/datafile/system.262.702839009
2 0 SYSAUX *** +DG1/csora/datafile/sysaux.263.702839013
3 0 UNDOTBS1 *** +DG1/csora/datafile/undotbs1.264.702839015
4 0 UNDOTBS2 *** +DG1/csora/datafile/undotbs2.266.702839025
5 0 USERS *** +DG1/csora/datafile/users.267.702839029
6 0 WCMTS *** +DG1/csora/datafile/wcm.dbf
9 0 WCM *** +DG1/csora/datafile/wcm.295.778461773
10 0 WCM_LOG *** +DG1/csora/datafile/wcm_log.1312.778462571
11 0 WCM_DOCUMENT *** +DG1/csora/datafile/wcm_document.488.778462999
12 0 WCM_PLUGIN *** +DG1/csora/datafile/wcm_plugin.486.778465097
14 0 WCMVIDEO *** +DG1/csora/datafile/wcmvideo.1197.778465867
15 0 TRSWCMV6_ADINTRS *** +DG1/csora/datafile/trswcmv6_adintrs.294.778466237
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 0 TEMP 32767 +DG1/csora/tempfile/temp.265.702839017
2 0 WCMTEMP 32767 +DG1/csora/datafile/wcmtemp.dbf
3 0 WCM_TMP 10240 +DG1/csora/tempfile/wcm_tmp.492.721280993
5 0 TRSWCMV6_ADINTRS_TEMP 0 +DG1/csora/tempfile/trswcmv6_adintrs
_temp.1304.749667811
_temp.1304.749667811
rman批处理脚本：
RUN {
SET NEWNAME FOR DATAFILE 1 to "/u01/app/oradata/csora/system01.dbf";
SET NEWNAME FOR DATAFILE 2 to "/u01/app/oradata/csora/sysaux01.dbf";
SET NEWNAME FOR DATAFILE 3 to "/u01/app/oradata/csora/undotbs1.dbf";
SET NEWNAME FOR DATAFILE 4 to "/u01/app/oradata/csora/undotbs2.dbf";
SET NEWNAME FOR DATAFILE 5 to "/u01/app/oradata/csora/users01.dbf";
SET NEWNAME FOR DATAFILE 6 to "/u01/app/oradata/csora/wcmts.dbf";
SET NEWNAME FOR DATAFILE 9 to "/u01/app/oradata/csora/wcm.dbf";
SET NEWNAME FOR DATAFILE 10 to "/u01/app/oradata/csora/wcm_log.dbf";
SET NEWNAME FOR DATAFILE 11 to "/u01/app/oradata/csora/wcm_document.dbf";
SET NEWNAME FOR DATAFILE 12 to "/u01/app/oradata/csora/wcm_plugin.dbf";
SET NEWNAME FOR DATAFILE 14 to "/u01/app/oradata/csora/wcmvideo.dbf";
SET NEWNAME FOR DATAFILE 15 to "/u01/app/oradata/csora/trswcmv6_adintrs.dbf";
SET NEWNAME FOR TEMPFILE 1 to "/u01/app/oradata/csora/temp01.dbf";
SET NEWNAME FOR TEMPFILE 2 to "/u01/app/oradata/csora/wcmtemp.dbf";
SET NEWNAME FOR TEMPFILE 3