rac进行image copy备份，以及异机单机switch to copy方式恢复

集群rac1节点进行rman备份

run {
ALLOCATE CHANNEL c1 TYPE DISK CONNECT 'sys/123456@rac1';
ALLOCATE CHANNEL c2 TYPE DISK CONNECT 'sys/123456@rac2';
backup as copy spfile format '/home/oracle/tmp_dir/%U.ora';
backup as copy current controlfile format '/home/oracle/tmp_dir/%U.ctl';
backup incremental level 0 as copy tag 'test1' database format '/home/oracle/tmp_dir/%U.dbf';
backup as copy archivelog all format '/home/oracle/tmp_dir/archivelog_dir/%U.arc';
}

集群rac1节点将spfile导出成可视化文件

create pfile='/home/oracle/tmp_dir/rac.ora' from spfile;

将备份数据拷贝至单机环境的/home/oracle/rac_dir目录下，并chown -R将所有文件的拥有者改为oracle:oinstall，修改rac.ora

修改前

rac1.__db_cache_size=289406976
rac2.__db_cache_size=289406976
rac1.__java_pool_size=4194304
rac2.__java_pool_size=4194304
rac1.__large_pool_size=8388608
rac2.__large_pool_size=8388608
rac1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
rac2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
rac1.__pga_aggregate_target=268435456
rac2.__pga_aggregate_target=268435456
rac1.__sga_target=503316480
rac2.__sga_target=503316480
rac1.__shared_io_pool_size=0
rac2.__shared_io_pool_size=0
rac1.__shared_pool_size=192937984
rac2.__shared_pool_size=192937984
rac1.__streams_pool_size=0
rac2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/rac/adump'
*.audit_trail='db'
*.cluster_database=TRUE
*.commit_write='batch,nowait'
*.compatible='11.2.0.4.0'
*.control_files='+DATA/rac/controlfile/current.260.1092592629'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='rac'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=racXDB)'
rac2.instance_number=2
rac1.instance_number=1
*.memory_target=769654784
*.open_cursors=300
*.processes=150
*.remote_listener='rac13-10-scan:1521'
*.remote_login_passwordfile='exclusive'
rac2.thread=2
rac1.thread=1
rac2.undo_tablespace='UNDOTBS2'
rac1.undo_tablespace='UNDOTBS1'

修改后

*.audit_file_dest='/home/oracle/app/oracle/admin/zhangchen/adump'
*.audit_trail='db'
*.commit_write='batch,nowait'
*.compatible='11.2.0.4.0'
*.control_files='/home/oracle/app/oracle/oradata/zhangchen/controlfile01.ctl'
*.db_block_size=8192
*.db_create_file_dest='/home/oracle/app/oracle/oradata'
*.db_domain=''
*.db_name='orcl11g'
*.diagnostic_dest='/home/oracle/app/oracle'
*.dispatchers=''
*.memory_target=769654784
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='exclusive'

以oracle用户身份创建对应目录，并复制控制文件到指定路径

mkdir -p /home/oracle/app/oracle/oradata/zhangchen
mkdir -p /home/oracle/app/oracle/fast_recovery_area
mkdir -p /home/oracle/app/oracle/admin/zhangchen/adump
cp -pf cf_D-RAC_id-2680574645_02116vvm.ctl /home/oracle/app/oracle/oradata/zhangchen/controlfile01.ctl

oracle用户身份执行orapwd file=$ORACLE_HOME/dbs/orapw-zhangchen password=123456 force=y

rman执行恢复

shutdown immediate;
startup nomount pfile='/home/oracle/rac_dir/rac.ora';
restore controlfile from '/home/oracle/app/oracle/oradata/zhangchen/controlfile01.ctl';
alter database mount;
catalog datafilecopy ...;
switch database to copy;
recovery database;
alter database open resetlogs;