单实例迁移到RAC(普通文件系统到ASM)

一.大致操作步骤如下：1.安装Clusterware和ASM实例2.备份源库，并将备份集copy到rac节点上3.在RAC上还原并修改初始化参数文件，还原控制文件和数据文件4.增加undo表空间和redolog线程组，创建密钥文件5.配置RAC监听6.将数据库等资源添加到CRS--------------------------------------------------------1、单库全备份2、FTP到RAC节点3、准备修改的参数文件（可以来源于全库备份自带的）注：control_file=放到ASM里4、启到nomount，还原控制数文件，到mount状态5、不原数据库（文件路径的转换）6、恢复数据库，打开强制数据库7、单库参数变成RAC参数文件8、参加UNDO表空间9、参加日志组10、允许线程生效11、其它节点startup（本地文件参数，指定到ASM参数中）12、用srvctladddatabase和instante-----------------------------------------------------------一.具体操作步骤：第一步骤，安装Clusterware和ASM实例（略过）第二步骤，备份源库，并将备份集copy到rac节点上（略过）第三步骤，在RAC上还原并修改初始化参数文件viinitsytong.ora-----------------------------------------------------------------------*.audit_file_dest='/data/oracle/admin/sytong/adump'*.background_dump_dest='/data/oracle/admin/sytong/bdump'#*.cluster_database_instances=3#*.cluster_database=true*.compatible='10.2.0.5.0'*.control_files='+DATA/sytong/controlfile/current.260.852633697'*.core_dump_dest='/data/oracle/admin/sytong/cdump'*.db_block_size=8192*.db_create_file_dest='+DATA'*.db_domain=''*.db_file_multiblock_read_count=16*.db_name='sytong'*.dispatchers='(PROTOCOL=TCP)(SERVICE=sytongXDB)'#sytong2.instance_number=3#sytong2.instance_number=2#sytong1.instance_number=1*.job_queue_processes=10#sytong1.local_listener='LISTENERS_sytong1'#sytong2.local_listener='LISTENERS_sytong2'#sytong2.local_listener='LISTENERS_sytong3'#sytong1.log_archive_dest_1='location=/arch/arch1'#sytong2.log_archive_dest_1='location=/arch/arch2'#sytong2.log_archive_dest_1='location=/arch/arch3'*.open_cursors=300*.pga_aggregate_target=199229440*.processes=150#*.remote_listener='LISTENERS_sytong'*.remote_login_passwordfile='exclusive'*.sga_target=599785472#sytong2.thread=3#sytong2.thread=2#sytong1.thread=1*.undo_management='AUTO'#sytong2.undo_tablespace='UNDOTBS3'#sytong2.undo_tablespace='UNDOTBS2'#sytong1.undo_tablespace='UNDOTBS1'*.user_dump_dest='/data/oracle/admin/sytong/udump'-------------------------------------------------------createpfile='/home/oracle/initsytong.ora'fromspfile='+data/spfilesytong.ora';注意：设置各节tns点的initSID.ora和names.oralocal_listener和remote_listener第四步骤：在RMAN中还原控制文件restorecontrolfilefrom'/home/oracle/oracle/ptdb-20140712-852739643-3_1.dbf'第五步骤：在ASM中创建文件exportORACLE=+ASM1asmcmdASMCMDpwd+DATA/SYTONG/DATAFILE创建datafile目录ASMCMDpwd+DATA/SYTONG/SPFILE创建spfile目录第六步骤：在RMAN中还原数据库catalogstartwith'/data/arch1';(拷贝的备份片所放的目录）-------------------------------------------------------run{setnewnamefordatafile1to'+DATA/sytong/DATAFILE/system01.dbf';setnewnamefordatafile2to'+DATA/sytong/DATAFILE/undotbs01.dbf';setnewnamefordatafile3to'+DATA/sytong/DATAFILE/sysaux01.dbf';setnewnamefordatafile4to'+DATA/sytong/DATAFILE/user01.dbf';restoredatabase;switchdatafileall;switchtempfileall;}--------------------------------------------------------recoverdatabase;第七步骤：修改控制文件中日志文件的指针alterdatabaserenamefile'/data/oracle/oradata/sytong/redo01.log'to'+DATA';alterdatabaserenamefile'/data/oracle/oradata/sytong/redo02.log'to'+DATA';alterdatabaserenamefile'/data/oracle/oradata/sytong/redo03.log'to'+DATA';第八步骤：打开数据库alterdatabaseopenresetlogs;第九步骤：配置spfile.ora[oracle@dba~]$cat/home/oracle/back1/pfilesytong.ora*.audit_file_dest='/data/oracle/admin/sytong/adump'*.background_dump_dest='/data/oracle/admin/sytong/bdump'*.cluster_database_instances=3*.cluster_database=true*.compatible='10.2.0.5.0'*.control_files='+DATA/sytong/controlfile/current.260.852633697'*.core_dump_dest='/data/oracle/admin/sytong/cdump'*.db_block_size=8192*.db_create_file_dest='+DATA'*.db_domain=''*.db_file_multiblock_read_count=16*.db_name='sytong'*.dispatchers='(PROTOCOL=TCP)(SERVICE=sytongXDB)'sytong2.instance_number=3sytong2.instance_number=2sytong1.instance_number=1*.job_queue_processes=10#sytong1.local_listener='LISTENERS_SYTONG1'#sytong2.local_listener='LISTENERS_SYTONG2'#sytong3.local_listener='LISTENERS_SYTONG3'sytong1.log_archive_dest_1='location=/arch/arch1'sytong2.log_archive_dest_1='location=/arch/arch2'sytong3.log_archive_dest_1='location=/arch/arch3'*.open_cursors=300*.pga_aggregate_target=199229440*.processes=150#*.remote_listener='LISTENERS_SYTONG'*.remote_login_passwordfile='exclusive'*.sga_target=599785472sytong3.thread=3sytong2.thread=2sytong1.thread=1*.undo_management='AUTO'sytong2.undo_tablespace='UNDOTBS2'sytong1.undo_tablespace='UNDOTBS1'sytong3.undo_tablespace='UNDOTBS3'*.user_dump_dest='/data/oracle/admin/sytong/udump'第十步骤：将spfile.ora放到ASM中[oracle@dba~]$sqlplus/assysdbaidlecreatespfile='+DATA/SYTONG/SPFILE/spfilesytong.ora'frompfile='/home/oracle/back1/pfilesytong.ora';第十一步骤：将定各节点initsytong[1-3].ora的spfile路径[oracle@dba~]$cat/data/oracle/product/10.2.0/db_1/dbs/initsytong1.oraspfile='+DATA/SYTONG/SPFILE/spfilesytong.ora'------------------------------------------------------------------------[oracle@dbb~]$cat/data/oracle/product/10.2.0/db_1/dbs/initsytong2.oraspfile='+DATA/SYTONG/SPFILE/spfilesytong.ora'------------------------------------------------------------------------[oracle@dbc~]$cat/data/oracle/product/10.2.0/db_1/dbs/initsytong3.oraspfile=