单实例数据库迁移到RAC环境

1单实例数据库迁移到RAC环境环境介绍：数据库的版本均为11.1.0.6.0，数据库字符集编码为AMERICAN_AMERICA.ZHS16GBK操作系统的版本单实例数据库(源库)为rhel5.864bit数据库名：db11g实例名：db11gRAC(目标数据库)为rhel5.864bit一．目标数据库准备工作，rman备份的异机恢复要求数据库名要一致，因而需要先删掉原有的db11g数据库和数据文件[oracle@rac1~]$srvctlstopdatabase-ddb11g-oimmediate[oracle@rac1~]$srvctlremovedatabase-ddb11gRemovethedatabasedb11g?(y/[n])y[oracle@rac1~]$crs_stat-t-vNameTypeR/RAF/FTTargetStateHost----------------------------------------------------------------------ora....SM1.asmapplication0/50/0ONLINEONLINErac1ora....C1.lsnrapplication0/50/0ONLINEONLINErac1ora.rac1.gsdapplication0/50/0ONLINEONLINErac1ora.rac1.onsapplication0/30/0ONLINEONLINErac1ora.rac1.vipapplication0/00/0ONLINEONLINErac1ora....SM2.asmapplication0/50/0ONLINEONLINErac2ora....C2.lsnrapplication0/50/0ONLINEONLINErac2ora.rac2.gsdapplication0/50/0ONLINEONLINErac2ora.rac2.onsapplication0/30/0ONLINEONLINErac2ora.rac2.vipapplication0/00/0ONLINEONLINErac2修改/etc/oratab文件(节点2上同样需要)[root@rac1~]#tail-n1/etc/oratab+ASM1:/u01/app/oracle/product/10.2.0/db_1:N[oracle@rac1~]$exportORACLE_SID=+ASM1[oracle@rac1~]$asmcmdASMCMDrm-rf+DATA/DB11GASMCMDrm-rf+FRA/DB11G2[oracle@rac1~]$sqlplus/nologSQLconn/assysdbaConnected.SQLcolstateformata10SQLcolnameformata15SQLcolfailgroupformata20SQLsetline200SQLselectstate,redundancy,total_mb,free_mb,name,failgroupfromv$asm_disk;STATEREDUNDANCYTOTAL_MBFREE_MBNAMEFAILGROUP--------------------------------------------------------------------------------------NORMALUNKNOWN2860NORMALUNKNOWN2860NORMALUNKNOWN2860NORMALUNKNOWN2860NORMALUNKNOWN2860NORMALUNKNOWN1020810114FRA_0000FRA_0000NORMALUNKNOWN95379443DATA_0001DATA_0001NORMALUNKNOWN95379443DATA_0000DATA_00008rowsselected.备注：前5个磁盘分别为表决盘和ocr，data磁盘组做了normal冗余SQLselectgroup_number,name,state,type,total_mb,free_mb,unbalancedfromv$asm_diskgroup;GROUP_NUMBERNAMESTATETYPETOTAL_MBFREE_MBUNB------------------------------------------------------------------------------1DATAMOUNTEDNORMAL1907418886N2FRAMOUNTEDEXTERN1020810114N二．源库上建一个测试表，由spfile生成pfileSQLshowparametername;NAMETYPEVALUE-----------------------------------------------------------------------------db_file_name_convertstringdb_namestringdb11gdb_unique_namestringdb11gglobal_namesbooleanFALSEinstance_namestringdb11glock_name_spacestring3log_file_name_convertstringservice_namesstringdb11gSQLcreatetabletest1.migrate(avarchar2(20));Tablecreated.SQLinsertintotest1.migrateavalues('successful');1rowcreated.SQLcommit;Commitcomplete.SQLcreatepfile='/backup_ora/rman_bak/initdb11g.ora'fromspfile;SQLselectfile_id,file_name,tablespace_namefromdba_data_filesorderby1;FILE_IDFILE_NAMETABLESPACE_NAME---------------------------------------------------------------------------1/u01/app/oracle/oradata/db11g/system01.dbfSYSTEM2/u01/app/oracle/oradata/db11g/undotbs01.dbfUNDOTBS13/u01/app/oracle/oradata/db11g/sysaux01.dbfSYSAUX4/u01/app/oracle/oradata/db11g/users01.dbfUSERS5/u01/app/oracle/oradata/db11g/example01.dbfEXAMPLE6/u01/app/oracle/oradata/db11g/exp_rac01.dbfEXP_RAC7/u01/app/oracle/oradata/db11g/exp_rac_index01.dbfEXP_RAC_INDEX8/u01/app/oracle/oradata/db11g/exp_rac1_01.dbfEXP_RAC19/u01/app/oracle/oradata/db11g/exp_rac1_index_01.dbfEXP_RAC1_INDEX9rowsselected.SQLselectfile_id,file_name,tablespace_namefromdba_temp_filesorderby1;FILE_IDFILE_NAMETABLESPACE_NAME---------------------------------------------------------------------------1/u01/app/oracle/oradata/db11g/temp01.dbfTEMPSQLselectfile_name,tablespace_namefromdba_temp_files;FILE_NAMETABLESPACE_NAME----------------------------------------------------------------------/u01/app/oracle/oradata/db11g/temp01.dbfTEMP4三．在源库上使用rman进行全库备份，并将备份复制到目标数据库上[oracle@server49~]$rmantarget/RecoveryManager:Release11.1.0.6.0-ProductiononTueJan312:10:062012Copyright(c)1982,2007,Oracle.Allrightsreserved.connectedtotargetdatabase:DB11G(DBID=1299224612)RMANbackupincrementallevel02format'/home/oracle/rman_bak/db11g_%U'3databaseplusarchivelog4deleteallinput;RMANbackupcurrentcontrolfileformat'/home/oracle/rman_bak/migrate.ctl';RMANlistbackupofdatabasesummary;ListofBackups===============KeyTYLVSDeviceTypeCompletionTime#Pieces#CopiesCompressedTag-----------------------------------------------------------------2B0ADISK03-JAN-1211NOTAG20120103T121503[oracle@server49~]$scp-rp/home/oracle/rman_bak/rac1:/home/oracle/四．在目标数据库上执行恢复4.1修改初始化参数文件如下*.__db_cache_size=79691776*.__java_pool_size=4194304*.__large_pool_size=4194304*.__shared_pool_size=109051904*.__streams_pool_size=8388608db11g1.instance_name='db11g1'db11g2.instance_name='db11g2'db11g1.instance_number=1db11g2.instance_number=2*.cluster_database=true*.cluster_database_instances=2db11g1.thread=1*.compatible='11.1.0.6.0'*.control_files='+DATA/db11g/controlfile/control01.ctl','+FRA/db11g/controlfile/control02.ctl'*.audit_file_dest='/u01/app/oracle/admin/db11g/adump'*.core_dump_dest='/u01/app/oracle/admin/db11g/cdump'*.db_block_size=81925*.db_file_multiblock_read_count=16*.db_name='db11g'*.db_recovery_file_dest='+FRA'*.db_recovery_file_dest_size=21474836480*.log_archive_de