yc数据迁移

备份脚本内容如下：

export RMAN_LOG_FILE=/logbackup/ycyth_ramn/fullrman20160817.log

export ORACLE_BASE=/u01/app/oracle

export RMAN=$ORACLE_HOME/bin/rman

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

export ORACLE_SID=ycythdb2

rman target / nocatalog msglog $RMAN_LOG_FILE append << EOF

run{

allocate channel t1 type disk;

allocate channel t2 type disk;

allocate channel t3 type disk;

allocate channel t4 type disk;

allocate channel t5 type disk;

allocate channel t6 type disk;

allocate channel t7 type disk;

allocate channel t8 type disk;

backup as compressed backupset full tag 'dbfull' format '/logbackup/ycyth_ramn/dbfull_%t_%s_%p' diskratio=0 database ;

sql 'alter system archive log current';

backup as compressed backupset format '/logbackup/ycyth_ramn/arch_%t_%s_%p' diskratio=0 archivelog all;

backup format '/logbackup/ycyth_ramn/ctl_%t_%s_%p'  current controlfile    ;

release channel t1;

release channel t2;

release channel t3;

release channel t4;

release channel t5;

release channel t6;

release channel t7;

release channel t8;

}

EOF

备份完了，要修改权限  chown oracle:oinstall -R  *

 

1）恢复参数文件:

源端生成pfile

sql> create pfile='/mnt/rmannfs/ycythrman/pfile.20160810' from spfile;

修改pfile

*.db_create_file_dest='+DATA'

改成

*.db_create_file_dest='+DATAC1/YCYTHDB/CONTROLFILE'

 

*.remote_listener='HB95598-scan:1521'

改成

*.remote_listener='mmsdb-scan:1521'

 

*.control_files='+DATA/ycythdb/controlfile/current.292.906236575'

改成

*.control_files='+DATAC1'

 

*.compatible='11.2.0.0.0'

改成

*.compatible='11.2.0.4.0'

 

*.cluster_database=true

改成

*.cluster_database=false

 

ycythdb1.log_archive_dest_1='location=/arch01'

ycythdb2.log_archive_dest_1='location=/arch02'

改成

ycythdb1.log_archive_dest_1='location=+DATAC1'

ycythdb2.log_archive_dest_1='location=+DATAC1'

 

#set archivelog destination to '/xtts_stage/arch';

2）通过修改后的参数文件将目标端库启动到nomout状态

sql> startup  nomount  pfile='/xtts_stage/ycythrman/pfile.20160810';

 

3)恢复控制文件：

export ORACLE_SID=ycythdb1

rman target /

rman>restore controlfile from '/xtts_stage/ycythrman/ctl_920076103_305_1';

4）修改数据文件的DG路径  （98个数据文件，6个redo,2个tmp文件）

SQL> col name format a60 ; 

select file#,name from v$datafile ; 

select count(*) from v$datafile ;

select count(*) from  v$logfile ;

select count(*) from v$tempfile ; 

 a.数据文件：

select 'set newname for datafile '|| file# ||'  to ''+DATAC1'' ;' from v$datafile order by file#;

 b.redo文件：

select 'alter database  rename  file  ''||group#||'' to ''+DATAC1'';' from  v$logfile;

 c.temp文件：

select 'set newname for tempfile '|| file# ||' to ''+DATAC1'' ;' from v$tempfile ; 

5）注册备份集:

rman target /

catalog start with '/xtts_stage/ycythrman/' ;

catalog start with '/xtts_stage/ycythrman/last_arch/'

6）开始恢复数据

    export ORACLE_SID=ycythdb1

rman target  /  msglog /home/oracle/restorzxk20160817.log  append 

run{

set newname for datafile 1  to '+DATAC1' ;

set newname for datafile 2  to '+DATAC1' ;

set newname for datafile 3  to '+DATAC1' ;

set newname for datafile 4  to '+DATAC1' ;

set newname for datafile 5  to '+DATAC1' ;

set newname for datafile 6  to '+DATAC1' ;

set newname for datafile 7  to '+DATAC1' ;

set newname for datafile 8  to '+DATAC1' ;

set newname for datafile 9  to '+DATAC1' ;

set newname for datafile 10  to '+DATAC1' ;

set newname for datafile 11  to '+DATAC1' ;

set newname for datafile 12  to '+DATAC1' ;

set newname for datafile 13  to '+DATAC1' ;

set newname for datafile 14  to '+DATAC1' ;

set newname for datafile 15  to '+DATAC1' ;

set newname for datafile 16  to '+DATAC1' ;

set newname for datafile 17  to '+DATAC1' ;

set newname for datafile 18  to '+DATAC1' ;

set newname for datafile 19  to '+DATAC1' ;

set newname for datafile 20  to '+DATAC1' ;

set newname for datafile 21  to '+DATAC1' ;

set newname for datafile 22  to '+DATAC1' ;

set newname for datafile 23  to '+DATAC1' ;

set newname for datafile 24  to '+DATAC1' ;

set newname for datafile 25  to '+DATAC1' ;

set newname for datafile 26  to '+DATAC1' ;

set newname for datafile 27  to '+DATAC1' ;

set newname for datafile 28  to '+DATAC1' ;

set newname for datafile 29  to '+DATAC1' ;

set newname for datafile 30  to '+DATAC1' ;

set newname for datafile 31  to '+DATAC1' ;

set newname for datafile 32  to '+DATAC1' ;

set newname for datafile 33  to '+DATAC1' ;

set newname for datafile 34  to '+DATAC1' ;

set newname for datafile 35  to '+DATAC1' ;

set newname for datafile 36  to '+DATAC1' ;

set newname for datafile 37  to '+DATAC1' ;

set newname for datafile 38  to '+DATAC1' ;

set newname for datafile 39  to '+DATAC1' ;

set newname for datafile 40  to '+DATAC1' ;

set newname for datafile 41  to '+DATAC1' ;

set newname for datafile 42  to '+DATAC1' ;

set newname for datafile 43  to '+DATAC1' ;

set newname for datafile 44  to '+DATAC1' ;

set newname for datafile 45  to '+DATAC1' ;

set newname for datafile 46  to '+DATAC1' ;

set newname for datafile 47  to '+DATAC1' ;

set newname for datafile 48  to '+DATAC1' ;

set newname for datafile 49  to '+DATAC1' ;

set newname for datafile 50  to '+DATAC1' ;

set newname for datafile 51  to '+DATAC1' ;

set newname for datafile 52  to '+DATAC1' ;

set newname for datafile 53  to '+DATAC1' ;

set newname for datafile 54  to '+DATAC1' ;

set newname for datafile 55  to '+DATAC1' ;

set newname for datafile 56  to '+DATAC1' ;

set newname for datafile 57  to '+DATAC1' ;

set newname for datafile 58  to '+DATAC1' ;

set newname for datafile 59  to '+DATAC1' ;

set newname for datafile 60  to '+DATAC1' ;

set newname for datafile 61  to '+DATAC1' ;

set newname for datafile 62  to '+DATAC1' ;

set newname for datafile 63  to '+DATAC1' ;

set newname for datafile 64  to '+DATAC1' ;

set newname for datafile 65  to '+DATAC1' ;

set newname for datafile 66  to '+DATAC1' ;

set newname for datafile 67  to '+DATAC1' ;

set newname for datafile 68  to '+DATAC1' ;

set newname for datafile 69  to '+DATAC1' ;

set newname for datafile 70  to '+DATAC1' ;

set newname for datafile 71  to '+DATAC1' ;

set newname for datafile 72  to '+DATAC1' ;

set newname for datafile 73  to '+DATAC1' ;

set newname for datafile 74  to '+DATAC1' ;

set newname for datafile 75  to '+DATAC1' ;

set newname for datafile 76  to '+DATAC1' ;

set newname for datafile 77  to '+DATAC1' ;

set newname for datafile 78  to '+DATAC1' ;

set newname for datafile 79  to '+DATAC1' ;

set newname for datafile 80  to '+DATAC1' ;

set newname for datafile 81  to '+DATAC1' ;

set newname for datafile 82  to '+DATAC1' ;

set newname for datafile 83  to '+DATAC1' ;

set newname for datafile 84  to '+DATAC1' ;

set newname for datafile 85  to '+DATAC1' ;

set newname for datafile 86  to '+DATAC1' ;

set newname for datafile 87  to '+DATAC1' ;

set newname for datafile 88  to '+DATAC1' ;

set newname for datafile 89  to '+DATAC1' ;

set newname for datafile 90  to '+DATAC1' ;

set newname for datafile 91  to '+DATAC1' ;

set newname for datafile 92  to '+DATAC1' ;

set newname for datafile 93  to '+DATAC1' ;

set newname for datafile 94  to '+DATAC1' ;

set newname for datafile 95  to '+DATAC1' ;

set newname for datafile 96  to '+DATAC1' ;

set newname for datafile 97  to '+DATAC1' ;

set newname for datafile 98  to '+DATAC1' ;

sql "alter databaserenamefile  ''+DATA/ycythdb/onlinelog/redo05.log'' to ''+DATAC1'' " ;

sql "alter databaserenamefile  ''+DATA/ycythdb/onlinelog/redo06.log'' to ''+DATAC1'' " ;

sql "alter databaserenamefile  ''+DATA/ycythdb/onlinelog/redo07.log'' to ''+DATAC1'' " ;

sql "alter databaserenamefile  ''+DATA/ycythdb/onlinelog/redo08.log'' to ''+DATAC1'' " ;

sql "alter databaserenamefile  ''+DATA/ycythdb/onlinelog/redo09.log'' to ''+DATAC1'' " ;

sql "alter databaserenamefile  ''+DATA/ycythdb/onlinelog/redo10.log'' to ''+DATAC1'' " ;

set newname for tempfile 1 to '+DATAC1' ;

set newname for tempfile 2 to '+DATAC1' ;

allocate channel t1 type disk ;

allocate channel t2 type disk ;

allocate channel t3 type disk ;

allocate channel t4 type disk ;

allocate channel t5 type disk ;

allocate channel t6 type disk ;

allocate channel t7 type disk ;

allocate channel t8 type disk ;

allocate channel t9 type disk ;

allocate channel t10 type disk ;

allocate channel t11 type disk ;

allocate channel t12 type disk ;

allocate channel t13 type disk ;

allocate channel t14 type disk ;

allocate channel t15 type disk ;

allocate channel t16 type disk ;

restore database ;

switch datafile all ;  

switch tempfile all ;

release channel t1  ;

release channel t2  ;

release channel t3  ;

release channel t4  ;

release channel t5  ;

release channel t6  ;

release channel t7  ;

release channel t8  ;

release channel t9  ;

release channel t10 ;

release channel t11 ;

release channel t12 ;

release channel t13 ;

release channel t14 ;

release channel t15 ;

release channel t16 ;

}

rman>recover database ;

检查scn

col CHECKPOINT_CHANGE# format a20 

SQL> SELECT  CHECKPOINT_CHANGE# FROM V$DATAFILE_HEADER;

SQL>SELECT distinct  CHECKPOINT_CHANGE#  FROM  V$DATAFILE;

select to_char( to_number( CHECKPOINT_CHANGE# )) from  V$DATABASE;

select to_char( to_number( CHECKPOINT_CHANGE# )) from  V$DATAFILE;

SELECT to_char( to_number( CHECKPOINT_CHANGE# )) FROM V$DATAFILE_HEADER;

 

SQL>alter database open resetlogs upgrade;

SQL> spool /tmp/upgrade.log

SQL> @?/rdbms/admin/catupgrd.sql

 

注册集群资源

srvctl add database -d ycythdb -n mmsdbadm03 -o /u01/app/oracle/product/11.2.0.4/dbhome_1   -p +DATAC1/ycythdb/parameterfile/spfile.1613.920302901   -a DATAC1,DBFS_DG,RECOC1

srvctl add instance -d ycythdb -i ycythdb1 -n  mmsdbadm03

srvctl add instance -d ycythdb -i ycythdb2 -n  mmsdbadm04

 

create spfile='+DATAC1' from memory;  

修改initSID.ora

[oracle@ycfkdb2 dbs]$ vim initycfkdb2.ora 

[oracle@ycfkdb2 dbs]$ more initycfkdb2.ora 

SPFILE='+dgdata/ycfkdb/parameterfile/spfile.513.920637845'