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
channel ORA_DISK_1: restoring spfile from AUTOBACKUP /home/oracle/db_54_1_879855779
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 17-MAY-15
RMAN> shutdown immediate;
Oracle instance shut down
RMAN> set DBID=2573050700
executing command: SET DBID
RMAN> startup nomount;
connected to target database (not started)
Oracle instance started
Total System Global Area 521936896 bytes
Fixed Size 2228072 bytes
Variable Size 176160920 bytes
Database Buffers 335544320 bytes
Redo Buffers 8003584 bytes
RMAN> restore controlfile 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
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=/orafile/oradata/control01.ctl
output file name=/orafile/oradata/control02.ctl
Finished restore at 17-MAY-15
RMAN> alter database mount;
database mounted
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
10 B A A DISK 16-MAY-15 1 1 YES ARCH_ALL
11 B A A DISK 16-MAY-15 1 1 YES ARCH_ALL
12 B 0 A DISK 16-MAY-15 1 1 YES FULL
RMAN> restore database from tag='FULL';
Starting restore at 17-MAY-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /orafile/oradata/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /orafile/oradata/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /orafile/oradata/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /orafile/oradata/users01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/db_60_1_879840533
channel ORA_DISK_1: piece handle=/home/oracle/db_60_1_879840533 tag=FULL
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:45
Finished restore at 17-MAY-15
RMAN> recover database from tag='ARCH_ALL';
Starting recover at 17-MAY-15
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 97 is already on disk as file /orafile/arc/1_97_879804940.arc
archived log for thread 1 with sequence 1 is already on disk as file /orafile/arc/1_1_879955249.arc
archived log for thread 1 with sequence 2 is already on disk as file /orafile/arc/1_2_879955249.arc
archived log for thread 1 with sequence 3 is already on disk as file /orafile/arc/1_3_879955249.arc
archived log file name=/orafile/arc/1_97_879804940.arc thread=1 sequence=97
archived log file name=/orafile/arc/1_2_879955249.arc thread=1 sequence=2
media recovery complete, elapsed time: 00:00:17
Finished recover at 17-MAY-15
RMAN> alter database open;
database opened
-----------------------
The migration completed
附加常用命令：
1、概念
差异增量：是备份上级及同级备份以来所有变化的数据块，差异增量是默认增量备份方式
累积增量：是备份上级备份以来所有变化的块