第一.備份所有歸檔日志文件
RMAN> backup archivelog all delete input;
第二.restore archivelog 的各種選項
- restore archivelog all 恢復(fù)全部歸檔日志文件
RMAN> restore archivelog all; - 只恢復(fù) 5到8這四個歸檔日志文件
RMAN> restore archivelog from logseq 5 until logseq 8; - 恢復(fù)從第5個歸檔日志起
RMAN> restore archivelog from logseq 5; - 恢復(fù)7天內(nèi)的歸檔日志
RMAN> restore archivelog from time 'sysdate-7'; - sequence between 寫法
RMAN> restore archivelog sequence between 1 and 3; - 恢復(fù)到哪個日志文件為止
RMAN> restore archivelog until logseq 3; - 從第五個日志開始恢復(fù)
RMAN> restore archivelog low logseq 5; - 到第5個日志為止
RMAN> restore archivelog high logseq 5;
如果想改變恢復(fù)到另外路徑下 則可用下面語句
set archivelog destination to 'd:\backup';
RMAN> run
2> {allocate channel ci type disk;
3> set archivelog destination to 'd:\backup';
4> restore archivelog all;
5> release channel ci;
6> }
Oracle數(shù)據(jù)庫使用RMAN備份的時候，會把歸檔日志壓成備份集（backup set）幼苛，而有時候我們?yōu)榱嘶謴?fù)數(shù)據(jù)的需要可能需要從這些備份集中解析出歸檔日志（archive log）腔丧，這時可以用restore這個命令翠忠。
該命令的參數(shù)可以用SCN思杯、SEQUENCE太援、TIME等德玫，也可以附加preview參數(shù)先查看計劃展哭，該參數(shù)和list backup of archivelog是等效的湃窍。
1、根據(jù)時間查看需要的備份集：
ERPDB1@/orabak>rman target /
RMAN> list backup of archivelog time
between "to_date('2009-06-24 08:00:00','yyyy-mm-dd hh24:mi:ss')"
and "to_date('2009-06-24 13:00','yyyy-mm-dd hh24:mi:ss')";
以下是示例匪傍，并非原來的文件列表：
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
18021 104.97M DISK 00:00:25 02-APR-10
BP Key: 21243 Status: AVAILABLE Compressed: YES Tag: TAG20100402T213015
Piece Name: /orabak/arch/CNDERPDB_arch_20100402_715296294_18088_1
List of Archived Logs in backup set 18021
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 130930 12425302024 02-APR-10 12425464067 02-APR-10
1 130931 12425464067 02-APR-10 12425612482 02-APR-10
1 130932 12425612482 02-APR-10 12425741312 02-APR-10
1 130933 12425741312 02-APR-10 12425903002 02-APR-10
1 130934 12425903002 02-APR-10 12426033120 02-APR-10
1 130935 12426033120 02-APR-10 12426231614 02-APR-10
1 130936 12426231614 02-APR-10 12426258334 02-APR-10
或者用preview查看：
RMAN> restore archivelog time
between "to_date('2009-06-24 08:00:00','yyyy-mm-dd hh24:mi:ss')"
and "to_date('2009-06-24 13:00','yyyy-mm-dd hh24:mi:ss')" preview;
也可以先指定時間格式您市，然后就可以不用to_date函數(shù)了：
RMAN> SQL 'ALTER SESSION SET NLS_DATE_FORMAT="YYYY-MM-DD:HH24:MI:SS"';
RMAN> restore archivelog time
between '2009-06-24 09:00:00' and '2009-06-24 12:00:00' preview;
2、把備份集文件COPY到默認(rèn)的歸檔路徑中
我這里是/orabak/arch役衡，從第一步文件列表的Piece Name也可以看出來歸檔的路徑茵休。
否則在restore過程中會報以下錯誤：
channel ORA_DISK_1: reading from backup piece /orabak/arch/ERPDB_arch_20090624_690383375_14453_1
ORA-19870: error reading backup piece /orabak/arch/ERPDB_arch_20090624_690383375_14453_1
ORA-19505: failed to identify file "/orabak/arch/ERPDB_arch_20090624_690383375_14453_1"
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
3、執(zhí)行restore命令手蝎，一般如果是臨時需要這些文件榕莺，可以指定歸檔日志恢復(fù)到其他的目錄，這時必須用run命令：
RMAN> run {
2> set archivelog destination to '/orabak/testarch';
3> SQL 'ALTER SESSION SET NLS_DATE_FORMAT="YYYY-MM-DD:HH24:MI:SS"';
4> restore archivelog time between '2009-06-24 09:00:00' and '2009-06-24 12:10:00';
5> }
executing command: SET ARCHIVELOG DESTINATION
using target database control file instead of recovery catalog
sql statement: ALTER SESSION SET NLS_DATE_FORMAT="YYYY-MM-DD:HH24:MI:SS"
Starting restore at 29-JUN-09
allocated channel: ORA_DISK_1
......
Finished restore at 29-JUN-09
如果我們明確要恢復(fù)哪些歸檔日志棵介，可以用SEQUENCE BETWEEN integer1 AND integer2命令來操作钉鸯。
