RMAN 异机迁移实战操作-附加常用命令

操作操作场景 源服务器 OEL 6.3 11G R2 11.2.0.3目标服务器 OEL 6.3 11G R2 11.2.0.3源服务器和目标服务器存放数据路

操作操作场景

 源服务器      OEL 6.3 11G R2 11.2.0.3
目标服务器    OEL 6.3 11G R2 11.2.0.3
源服务器和目标服务器存放数据路径一样

 源服务器
[Oracle@mxq ~]$ rman target /

 Recovery Manager: Release 11.2.0.2.0 - Production on Sat May 16 08:51:05 2015

 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

 connected to target database: ORACLE11 (DBID=2573050700)

 RMAN> run
 {allocate channel orademo type disk MAXPIECESIZE 1024m;
 backup incremental level 0 as compressed backupset database include current controlfile tag='full' format '/home/oracle/db_%s_%p_%t' plus archivelog tag='arch_all' format  '/home/oracle/arch_%s_%p_%t' delete input;
 }2> 3> 4>

 released channel: ORA_DISK_1
 allocated channel: orademo
 channel orademo: SID=147 device type=DISK

 Starting backup at 16-MAY-15
 current log archived
 channel orademo: starting compressed archived log backup set
 channel orademo: specifying archived log(s) in backup set
 input archived log thread=1 sequence=96 RECID=69 STAMP=879840530
 channel orademo: starting piece 1 at 16-MAY-15
 channel orademo: finished piece 1 at 16-MAY-15
 piece handle=/home/oracle/arch_59_1_879840531 tag=ARCH_ALL comment=NONE
 channel orademo: backup set complete, elapsed time: 00:00:01
 channel orademo: deleting archived log(s)
 archived log file name=/orafile/arc/1_96_879804940.arc RECID=69 STAMP=879840530
 Finished backup at 16-MAY-15

 Starting backup at 16-MAY-15
 channel orademo: starting compressed incremental level 0 datafile backup set
 channel orademo: specifying datafile(s) in backup set
 including current SPFILE in backup set
 including current control file in backup set
 input datafile file number=00002 name=/orafile/oradata/sysaux01.dbf
 input datafile file number=00001 name=/orafile/oradata/system01.dbf
 input datafile file number=00003 name=/orafile/oradata/undotbs01.dbf
 input datafile file number=00004 name=/orafile/oradata/users01.dbf
 channel orademo: starting piece 1 at 16-MAY-15
 channel orademo: finished piece 1 at 16-MAY-15
 piece handle=/home/oracle/db_60_1_879840533 tag=FULL comment=NONE
 channel orademo: backup set complete, elapsed time: 00:02:55
 Finished backup at 16-MAY-15

 Starting backup at 16-MAY-15
 current log archived
 channel orademo: starting compressed archived log backup set
 channel orademo: specifying archived log(s) in backup set
 input archived log thread=1 sequence=97 RECID=72 STAMP=879840713
 channel orademo: starting piece 1 at 16-MAY-15
 channel orademo: finished piece 1 at 16-MAY-15
 piece handle=/home/oracle/arch_61_1_879840714 tag=ARCH_ALL comment=NONE
 channel orademo: backup set complete, elapsed time: 00:00:01
 channel orademo: deleting archived log(s)
 archived log file name=/orafile/arc/1_97_879804940.arc RECID=72 STAMP=879840713
 Finished backup at 16-MAY-15
 released channel: orademo

把新的备份集拷贝到目标服务器
[oracle@mxq ~]$ cd /home/oracle/
 [oracle@mxq ~]$ ls
 arch_59_1_879840531  arch_61_1_879840714  db_60_1_879840533
 [oracle@mxq ~]$ ll
 total 248900
 -rw-r----- 1 oracle oinstall    219648 May 16 08:08 arch_59_1_879840531
 -rw-r----- 1 oracle oinstall  1256448 May 16 08:11 arch_61_1_879840714
 -rw-r----- 1 oracle oinstall 253394944 May 16 08:11 db_60_1_879840533
 [oracle@mxq ~]$ scp * [email protected]:/home/oracle/
 [email protected]'s password:
 arch_59_1_879840531                          100%  215KB 214.5KB/s  00:00   
 arch_61_1_879840714                          100% 1227KB  1.2MB/s  00:00   
 db_60_1_879840533                            100%  242MB  13.4MB/s  00:18 

目标服务器

 提示：
 如果已经数据文件、控制文件、在线日志文件、参数文件那么新删除掉在进行做恢复不然后面报错

[oracle@mxq ~]$ rman target /

 Recovery Manager: Release 11.2.0.2.0 - Production on Sun May 17 12:10:05 2015

 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

 connected to target database (not started)

 RMAN> startup force nomount;

 Oracle instance started

 Total System Global Area    521936896 bytes

 Fixed Size                    2228072 bytes
 Variable Size                159383704 bytes
 Database Buffers            352321536 bytes
 Redo Buffers                  8003584 bytes

 RMAN> restore spfile from '/home/oracle/db_54_1_879855779';

 Starting restore at 17-MAY-15
 allocated channel: ORA_DISK_1
 channel ORA_DISK_1: SID=134 device type=DISK