操作操作场景
?源服务器? ? ? OEL 6.3 11G R2 11.2.0.3
目标服务器? ? OEL 6.3 11G R2 11.2.0.3
源服务器和目标服务器存放数据路径一样
?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 ~]$ 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
?a