RAC 通过rman、duplicate迁移至单实例

RAC 通过rman、duplicate迁移至单实例
rac 11g/10g 通过rman 迁移至另一独立的单实例，除了通过rman与duplicate 外，还可使用expdp, 以下主要讨论 rman+duplicate。

1，环境

RAC环境： db_name= dominic sid=dominic1/dominic2

单实例： db_name=dominic sid=dominic

# that require network functionality will fail.
127.0.0.1localhost.localdomain localhost
::1localhost6.localdomain6 localhost6
#*******************public_ip
192.168.103.189lmocm189
192.168.103.190lmocm190
#**********clustestorage_disk
192.168.103.86gtadb_86
#*********************priv-ip
192.168.56.189priv189
192.168.56.190priv190
#**********************vip-ip
192.168.103.200 vip189
192.168.103.201 vip190
#**********************scan-ip
192.168.103.203 scan.com
192.168.103.204 scan.com
192.168.103.205 scan.com
#**********************other-ip
192.168.103.192lmocm192
—–红色为rac 相关IP , 蓝色为 单实例IP

2，创建监听
通过netmgr 或者在 $ORALCE_HOME/NETWORK/ADMIN/下配置 listener.ora和tnsname.ora文件：
同时rac 和 单实例下都需要配置，tnsping ok 就可。

rac ： 配置单实例的， node 下，配置rac的，10g,可以单独的, 11g 使用scan,或者vip 也可以（建议使用scan，或者vip )

[oracle@lmocm189 admin]$ cat tnsnames.ora

DOMINIC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = scan.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dominic)
)
)

DOMINIC_SING =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lmocm192)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dominic)
)
)

[oracle@lmocm192 admin]$ cat listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = dominic)
(ORACLE_HOME = /u01/app/oracle/product/11.2/dbhome_1)
(SID_NAME = dominic)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lmocm192)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

3, 修改参数文件
通过RAC 的spfile 修改后 scp 至 node 下。

RAC 原spfile 文件：

[oracle@lmocm189 ~]$ cat /u01/app/oracle/dd.pfile 
dominic1.__db_cache_size=234881024
dominic2.__db_cache_size=268435456
dominic1.__java_pool_size=16777216
dominic2.__java_pool_size=16777216
dominic1.__large_pool_size=16777216
dominic2.__large_pool_size=16777216
dominic1.__pga_aggregate_target=402653184
dominic2.__pga_aggregate_target=402653184
dominic1.__sga_target=754974720
dominic2.__sga_target=754974720
dominic1.__shared_io_pool_size=0
dominic2.__shared_io_pool_size=0
dominic1.__shared_pool_size=436207616
dominic2.__shared_pool_size=436207616
dominic1.__streams_pool_size=33554432
dominic2.__streams_pool_size=0                        --这要删除
*.audit_file_dest='/u01/app/oracle/admin/dominic/adump'
*.audit_trail='db'
*.cluster_database=true                               --这要删除       
*.compatible='11.2.0.0.0'
*.control_files='+DATAFILE/dominic/controlfile/current.260.825093345','+ARCHIVELOG/dominic/controlfile/current.256.825093345' --修改
*.db_block_size=8192
*.db_create_file_dest='+DATAFILE'                     --修改
*.db_domain=''
*.db_name='dominic'
*.db_recovery_file_dest='+ARCHIVELOG'                  --修改
*.db_recovery_file_dest_size=4558159872
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=dominicXDB)'
dominic2.instance_number=2
dominic1.instance_number=1                            --这要删除                      
*.log_archive_format='%t_%s_%r.dbf'
*.memory_target=1153433600
*.open_cursors=300
*.processes=150
*.remote_listener='scan.com:1521'                     --这要删除          
*.remote_login_passwordfile='exclusive'
*.sessions=170
dominic2.thread=2
dominic1.thread=1
dominic2.undo_tablespace='UNDOTBS2'                  --这要删除，保留一个。      
dominic1.undo_tablespace='UNDOTBS1'

NODE PFILE 文件来源于修改后的RAC 文件:

[oracle@lmocm192 ~]$ cat /u01/app/ppfile 
dominic.__db_cache_size=452984832
dominic.__java_pool_size=16777216
dominic.__large_pool_size=16777216
dominic.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
dominic.__pga_aggregate_target=469762048
dominic.__sga_target=687865856
dominic.__shared_io_pool_size=0
dominic.__shared_pool_size=184549376
dominic.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/dominic/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/dominic/controlfile/current.260.825093345','/u01/app/oracle/oradata/controlfile/current.256.825093345'#Restore Controlfile
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oracle/oradata/dominic'
*.db_domain=''
*.db_file_name_convert=('+DATAFILE/dominic/datafile','/u01/app/oracle/oradata/dominic')
*.db_file_name_convert=('+DATAFILE/dominic/tempfile','/u01/app/oracle/oradata/dominic/tempfile')
*.db_name='DOMINIC'#Reset to original value by RMAN
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4558159872
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=dominicXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='location=/u01/app/oracle/archive_log'
*.log_archive_format='%t_%s_%r.dbf'
*.log_file_name_convert=（'+DATAFILE/dominic/onlinelog','/u01/app/oracle/oradata/logfile'）
*.log_file_name_convert=（'+ARCHIVELOG/dominic/onlinelog','/u01/app/oracle/onlinelog/logfile'）
*.memory_target=1153433600
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='exclusive'
*.sessions=170
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'

– 注意红色两行，因为RAC的目录结构和我们的单实例不一样，所以我们这里进行转换一下。 这里面要根据自己的情况来决定。 比如我将redo 放到了FRA了。所以在这里也需要进行转换。有几个路基，就需要转几次。

4, 创建相关目录
3步之前，最好通过 v$logfile,v$datafile,v$tempfile 查看一下数据文件路径。 通过mkdir -pv 创建 NODE 下的路径。同时创建orapwdSID 密码文件。

a,通过rac 的密码文件 ORAC