4，单实例端修改pfile文件，将集群相关的信息全部注释掉
[oracle@single ~]$ cat racpfile.ora
##PROD1.__db_cache_size=146800640
##PROD2.__db_cache_size=176160768
##PROD1.__Java_pool_size=4194304
##PROD2.__java_pool_size=4194304
##PROD1.__large_pool_size=8388608
##PROD2.__large_pool_size=8388608
##PROD1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
##PROD1.__pga_aggregate_target=289406976
##PROD2.__pga_aggregate_target=293601280
##PROD1.__sga_target=385875968
##PROD2.__sga_target=381681664
##PROD1.__shared_io_pool_size=0
##PROD2.__shared_io_pool_size=0
##PROD1.__shared_pool_size=218103808
##PROD2.__shared_pool_size=184549376
##PROD1.__streams_pool_size=0
##PROD2.__streams_pool_size=0
##*.audit_file_dest='/u01/app/oracle/admin/PROD/adump'
*.audit_file_dest='/u01/admin/PROD/adump'
*.audit_trail='db'
##*.cluster_database=true << 集群
*.compatible='11.2.0.4.0'
##*.control_files='+DATA/prod/controlfile/current.260.859325519','+ARCH/prod/controlfile/current.256.859325519'
*.control_files='+DATA/PROD/controlfile/control01.ctl','+FRA/PROD/controlfile/control02.ctl'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='PROD'
##*.db_recovery_file_dest='+ARCH'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=4621074432
##*.diagnostic_dest='/u01/app/oracle'
*.diagnostic_dest='/u01/'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRODXDB)'
*.enable_goldengate_replication=TRUE
##PROD2.instance_number=2
##PROD1.instance_number=1
##*.memory_target=675282944
*.memory_target=583008256
*.open_cursors=300
*.processes=150
##*.remote_listener='cluster-scan:1521' << scan IP
*.remote_login_passwordfile='exclusive'
##PROD2.thread=2
##PROD1.thread=1
##PROD2.undo_tablespace='UNDOTBS2'
##PROD1.undo_tablespace='UNDOTBS1'
*.undo_tablespace='UNDOTBS1' << 此处只保留unodtbs1的参数，在后面的恢复中还是会将undotbs2给恢复出来。
5，单实例端SQLPLUS使用修改后的pfile文件启动实例到nomount状态
SYS@PROD >startup nomount pfile=/home/oracle/racpfile.ora;
6，单实例端创建spfile到ASM磁盘组中的+DATA/PROD
SYS@PROD >create spfile='+DATA/PROD/spfilePROD.ora' from memory;
7，单实例端创建pfile，指引spfile的文件位置
$ vi $ORACLE_HOME/dbs/initPROD.ora
spfile='+DATA/PROD/spfilePROD.ora'
8，单实例端使用RMAN启动到nomount状态
RMAN> startup force nomount;
RMAN> set DBID=271163854
9，单实例端使用RAMN从备份集中恢复控制文件
RMAN> restore controlfile from '/home/oracle/full_1dpjmdbs_1_1.bak’;
10，单实例端mount数据库
RMAN> mount database;
11，单实例端注册备份集的路径
RMAN> catalog start with '/home/oracle';
12，单实例端列出控制文件中记录的数据文件
RMAN> report schema;
RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name PROD
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 0 SYSTEM *** +DATA/prod/datafile/system.256.859325451
2 0 SYSAUX *** +DATA/prod/datafile/sysaux.257.859325451
3 0 UNDOTBS1 *** +DATA/prod/datafile/undotbs1.258.859325451
4 0 USERS *** +DATA/prod/datafile/users.259.859325451
5 0 EXAMPLE *** +DATA/prod/datafile/example.264.859325525
6 0 UNDOTBS2 *** +DATA/prod/datafile/undotbs2.265.859325695
7 0 GOLDENGATE *** +DATA/prod/datafile/goldengate.269.859338811