ASM磁盘挂载迁移_RAC-单机灾备

1、安装目的端的grid（单机要安装standalone server选项，先映射一个新lun安装asm服务，后面这个lun不需要用到）和oracle软件

2、源端生成ASM和oracle的pfile拷贝到目的端，复制tnsnames.ora文件到目的端

3、源端关集群（或取消磁盘挂载）

4、映射asm磁盘（数据盘）到目的端，确认UUID

5、目的端配置multipath和udev（拷贝源端multipath.conf，保留IBM相关配置）

6、修改ASM的pfile

源端：

+ASM1.__oracle_base='/u01/app/grid'#ORACLE_BASE set from in memory value
+ASM2.__oracle_base='/u01/app/grid'#ORACLE_BASE set from in memory value
+ASM1.asm_diskgroups='DATA'#Manual Mount
+ASM2.asm_diskgroups='DATA'#Manual Mount
*.asm_diskstring='/dev/asm*'
*.asm_power_limit=1
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'

目的端（单机）

+ASM.__oracle_base='/u01/app/grid'#ORACLE_BASE set from in memory value
+ASM.asm_diskgroups='DATA'#Manual Mount
*.asm_diskstring='/dev/asm*'
*.asm_power_limit=1
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'

7、若ora.cssd的服务没启动则先启动

/u01/app/12.1.0/grid/bin/crsctl start resource ora.cssd -unsupported

8、关闭asm实例，并用修改好的pfile启动asm实例

sqlplus / as sysasm
shutdown immediate
startup nomount pfile='/u01/app/12.1.0/grid/dbs/init+ASM.ora';
create spfile='/u01/app/12.1.0/grid/dbs/spfile+ASM.ora' from pfile='/u01/app/12.1.0/grid/dbs/init+ASM.ora';
shutdown immediate;
startup;

查看DATA是否挂载成功

select name,path from v$asm_disk where group_number=(select group_number from v$asm_diskgroup where name='DATA');

9、修改oracle参数文件

源端：

gpp1.__data_transfer_cache_size=0
gpp2.__data_transfer_cache_size=0
gpp1.__db_cache_size=40802189312
gpp2.__db_cache_size=40802189312
gpp1.__java_pool_size=1073741824
gpp2.__java_pool_size=1073741824
gpp1.__large_pool_size=1073741824
gpp2.__large_pool_size=1073741824
gpp1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
gpp2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
gpp1.__pga_aggregate_target=32749125632
gpp2.__pga_aggregate_target=32749125632
gpp1.__sga_target=48586817536
gpp2.__sga_target=48586817536
gpp1.__shared_io_pool_size=268435456
gpp2.__shared_io_pool_size=268435456
gpp1.__shared_pool_size=5100273664
gpp2.__shared_pool_size=5100273664
gpp1.__streams_pool_size=0
gpp2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/gpp/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='12.1.0.2.0'
*.control_files='+DATA/GPP/CONTROLFILE/current.262.1120479093','+DATA/GPP/CONTROLFILE/current.261.1120479093'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='gpp'
*.db_recovery_file_dest='+DATA'
*.db_recovery_file_dest_size=100g
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=gppXDB)'
gpp1.instance_number=1
gpp2.instance_number=2
*.log_archive_format='%t_%s_%r.dbf'
*.memory_target=77466m
*.open_cursors=300
*.processes=1500
*.remote_login_passwordfile='exclusive'
gpp2.thread=2
gpp1.thread=1
gpp2.undo_tablespace='UNDOTBS2'
gpp1.undo_tablespace='UNDOTBS1'

目的端：

*.audit_file_dest='/u01/app/oracle/admin/gpp/adump' 
*.audit_trail='db'
#*.cluster_database=true
*.compatible='12.1.0.2.0'
*.control_files='+DATA/GPP/CONTROLFILE/current.262.1120479093','+DATA/GPP/CONTROLFILE/current.261.1120479093'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='gpp'
#*.db_recovery_file_dest='+DATA'
#*.db_recovery_file_dest_size=100g
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=gppXDB)'
#gpp1.instance_number=1
#gpp2.instance_number=2
*.log_archive_format='%t_%s_%r.dbf'
*.memory_target=26214m
*.open_cursors=300
*.processes=1500
*.remote_login_passwordfile='exclusive'
#gpp2.thread=2
#gpp1.thread=1
#gpp2.undo_tablespace='UNDOTBS2'
#gpp1.undo_tablespace='UNDOTBS1'

10、更改/u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle权限

chown oracle:asmadmin /u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle
chmod 6751 /u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle

11、启动数据库并生成spfile

startup nomount pfile='/u01/app/oracle/product/12.1.0/dbhome_1/dbs/initgpp.ora';
create spfile='/u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfilegpp.ora' from pfile='/u01/app/oracle/product/12.1.0/dbhome_1/dbs/initgpp.ora';
shutdown immediate;
startup;

12、生成密码文件

orapwd file=orapwgpp password=oracle
orapwd file=orapwnabnk password=oracle

13、关闭asm和oracle实例，修改ip，listener.ora，tnsnames.ora等文件

14、启动，测试数据，尝试远程连接