Rman在run命令塊裡臨時設定歸檔目錄,歸檔日誌能否恢復主要看預設的歸檔路徑

lusklusklusk發表於2020-08-16

Rman在run命令塊裡設定的archivelog的路徑不同於預設的archivelog目錄,如果archivelog已存在預設目錄,則不會恢復archivelog到run命令塊裡設定的archivelog的路徑



run命令塊裡設定歸檔目錄為/home/oracle,然後恢復archivelog到這個目錄,但是預設的歸檔目錄/u01/app/oracle/archivelog裡面已經存在這個歸檔日誌,則這個歸檔日誌也不會恢復到設定的歸檔目錄 /home/oracle

RMAN> run{

2> set archivelog destination to '/home/oracle';

3> restore archivelog from sequence 33 until sequence 34;

4> }


executing command: SET ARCHIVELOG DESTINATION

Starting restore at 15-MAY-18

using channel ORA_DISK_1

using channel ORA_DISK_2

archived log for thread 1 with sequence 34 is already on disk as file /u01/app/oracle/archivelog/1_34_970255476.dbf

restore not done; all files read only, offline, or already restored

Finished restore at 15-MAY-18


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/30126024/viewspace-2712152/,如需轉載,請註明出處,否則將追究法律責任。

相關文章