oracle rac 11.2.0.4 镜像copy迁移数据到新存储

最劲朋友关于将一个25T的数据迁移到新的存储，做了如下实验


把数据库迁移到新的存储
从 data磁盘组 迁移到 FRA 磁盘组
//创建业务表空间
SQL> create tablespace majoy datafile size 100M;
Tablespace created.
SQL> grant dba to majoy identified by majoy;
Grant succeeded.
SQL> conn majoy/majoy
Connected.
SQL> create table m1 as select * from dba_objects;
Table created.
SQL> select count(*) from m1;


  COUNT(*)
----------
     14016


select file_name from dba_data_files;
--------------------------------------------------------------------------------
+DATA/orcl/datafile/system.259.962291233
+DATA/orcl/datafile/sysaux.260.962291239
+DATA/orcl/datafile/undotbs1.261.962291243
+DATA/orcl/datafile/undotbs2.263.962291249
+DATA/orcl/datafile/undotbs3.264.962291251
+DATA/orcl/datafile/undotbs4.265.962291253
+DATA/orcl/datafile/users.266.962291255
+DATA/orcl/datafile/majoy.274.962309469


//在线进行整个数据库的镜像copy
connected to target database: ORCL (DBID=1490071961)     
RMAN>run {
allocate channel c1 type disk;
allocate channel c2 type disk;
backup as copy database format '+fra';
}


//做完镜像后更新表中的记录
conn majoy/majoy
insert into m1 select * from m1;
commit;
select count(*) from m1;


  COUNT(*)
----------
     28032
          
//查看          
list copy;
Key     File S Completion Time     Ckp SCN    Ckp Time           
------- ---- - ------------------- ---------- -------------------
18      1    A 2017/12/09 20:20:09 248515     2017/12/09 20:19:27
        Name: +DATA/orcl/datafile/system.259.962291233


19      2    A 2017/12/09 20:20:09 248515     2017/12/09 20:19:27
        Name: +DATA/orcl/datafile/sysaux.260.962291239


20      3    A 2017/12/09 20:20:09 248515     2017/12/09 20:19:27
        Name: +DATA/orcl/datafile/undotbs1.261.962291243


21      4    A 2017/12/09 20:20:09 248515     2017/12/09 20:19:27
        Name: +DATA/orcl/datafile/undotbs2.263.962291249


22      5    A 2017/12/09 20:20:09 248515     2017/12/09 20:19:27
        Name: +DATA/orcl/datafile/undotbs3.264.962291251


23      6    A 2017/12/09 20:20:09 248515     2017/12/09 20:19:27
        Name: +DATA/orcl/datafile/undotbs4.265.962291253


24      7    A 2017/12/09 20:20:09 248515     2017/12/09 20:19:27
        Name: +DATA/orcl/datafile/users.266.962291255


25      8    A 2017/12/09 20:20:09 248515     2017/12/09 20:19:27
        Name: +DATA/orcl/datafile/majoy.274.962309469
        
        
此时是open
RMAN> switch database to copy;


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch to copy command at 12/09/2017 20:13:30
RMAN-06572: database is open and datafile 1 is not offline


启动到mount下
shutdown immediate;
startup mount;
switch database to copy; --输出如下信息
using target database control file instead of recovery catalog
datafile 1 switched to datafile copy "+FRA/orcl/datafile/system.262.962309915"
datafile 2 switched to datafile copy "+FRA/orcl/datafile/sysaux.261.962309915"
datafile 3 switched to datafile copy "+FRA/orcl/datafile/undotbs1.260.962309919"
datafile 4 switched to datafile copy "+FRA/orcl/datafile/undotbs2.259.962309919"
datafile 5 switched to datafile copy "+FRA/orcl/datafile/undotbs3.258.962309919"
datafile 6 switched to datafile copy "+FRA/orcl/datafile/undotbs4.256.962309919"
datafile 7 switched to datafile copy "+FRA/orcl/datafile/users.266.962309921"
datafile 8 switched to datafile copy "+FRA/orcl/datafile/majoy.257.962309921"


//应用日志
recover database;


//alert 日志信息
Switch of datafile 1 complete to datafile copy 
  checkpoint is 248886
Switch of datafile 2 complete to datafile copy 
  checkpoint is 248887
Switch of datafile 3 complete to datafile copy 
  checkpoint is 248890
Switch of datafile 4 complete to datafile copy 
  checkpoint is 248891
Switch of datafile 5 complete to datafile copy 
  checkpoint is 248893
Switch of datafile 6 complete to datafile copy 
  checkpoint is 248894
Switch of datafile 7 complete to datafile copy 
  checkpoint is 248898
Switch of datafile 8 complete to datafile copy 
  checkpoint is 248896
Sat Dec 09 20:34:50 2017
Decreasing number of real time LMS from 3 to 0
---以上是切换的日志信息
---以下是recover  database的信息，应用在copy到最后关库中间产生的归档
Sat Dec 09 20:36:43 2017
alter database recover datafile list clear
Completed: alter database recover datafile list clear
alter database recover datafile list
 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8
Completed: alter database recover datafile list
 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8
alter database recover if needed
 start
Media Recovery Start
 started logmerger process
Parallel Media Recovery started with 56 slaves
Sat Dec 09 20:36:44 2017
Recovery of Online Redo Log: Thread 2 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/orcl/onlinelog/group_4.272.962291631
Media Recovery Complete (orcl2)
Completed: alter database recover if needed
 start
 


SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+FRA/orcl/datafile/system.262.962309915
+FRA/orcl/datafile/sysaux.261.962309915
+FRA/orcl/datafile/undotbs1.260.962309919
+FRA/orcl/datafile/undotbs2.259.962309919
+FRA/orcl/datafile/undotbs3.258.962309919
+FRA/orcl/datafile/undotbs4.256.962309919
+FRA/orcl/datafile/users.266.962309921
+FRA/orcl/datafile/majoy.257.962309921


SQL> alter database open;


//验证数据
SQL> conn majoy/majoy
Connected.
SQL> 
SQL> select count(*) from m1;


  COUNT(*)
----------
     28032