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

2015-07-16 12:07:29 · 作者: · 浏览: 7
llocated 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、概念


?差异增量:是备份上级及同级备份以来所有变化的数据块,差异增量是默认增量备份方式
?累积增量:是备份上级备份以来所有变化的块


?因为累积增量是备份上级备份以来所有变化的数据块,所以累积增量需要更多的备份时间,同时需要较小的恢复时间;