?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、概念
?差异增量:是备份上级及同级备份以来所有变化的数据块,差异增量是默认增量备份方式
?累积增量:是备份上级备份以来所有变化的块
?因为累积增量是备份上级备份以来所有变化的数据块,所以累积增量需要更多的备份时间,同时需要较小的恢复时间;