用RMAN備份歸檔日誌時檢查歸檔日誌是否存在
RMAN> crosscheck archivelog all;
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=138 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=135 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=136 devtype=DISK
validation succeeded for archived log
archive log filename=/u02/archivelog/1_3_843971268.dbf recid=2 stamp=844124125
validation succeeded for archived log
archive log filename=/u02/archivelog/1_4_843971268.dbf recid=1 stamp=844124109
validation succeeded for archived log
archive log filename=/u02/archivelog/1_5_843971268.dbf recid=3 stamp=844124132
validation succeeded for archived log
archive log filename=/u02/archivelog/1_6_843971268.dbf recid=4 stamp=844124144
validation succeeded for archived log
archive log filename=/u02/archivelog/1_7_843971268.dbf recid=5 stamp=844124772
validation succeeded for archived log
archive log filename=/u02/archivelog/1_8_843971268.dbf recid=6 stamp=844124773
validation succeeded for archived log
archive log filename=/u02/archivelog/1_9_843971268.dbf recid=7 stamp=844124785
validation succeeded for archived log
archive log filename=/u02/archivelog/1_10_843971268.dbf recid=8 stamp=844124795
validation succeeded for archived log
archive log filename=/u02/archivelog/1_11_843971268.dbf recid=9 stamp=844197561
validation succeeded for archived log
archive log filename=/u02/archivelog/1_12_843971268.dbf recid=10 stamp=844206816
validation succeeded for archived log
archive log filename=/u02/archivelog/1_13_843971268.dbf recid=11 stamp=844219881
validation succeeded for archived log
archive log filename=/u02/archivelog/1_14_843971268.dbf recid=12 stamp=844259634
validation succeeded for archived log
archive log filename=/u02/archivelog/1_15_843971268.dbf recid=13 stamp=844363185
validation succeeded for archived log
archive log filename=/u02/archivelog/1_16_843971268.dbf recid=15 stamp=844396883
validation succeeded for archived log
archive log filename=/u02/archivelog/1_17_843971268.dbf recid=14 stamp=844396868
validation succeeded for archived log
archive log filename=/u02/archivelog/1_18_843971268.dbf recid=16 stamp=844396885
validation succeeded for archived log
archive log filename=/u02/archivelog/1_19_843971268.dbf recid=17 stamp=844396887
validation succeeded for archived log
archive log filename=/u02/archivelog/1_20_843971268.dbf recid=18 stamp=844396888
validation succeeded for archived log
archive log filename=/u02/archivelog/1_21_843971268.dbf recid=19 stamp=844396888
Crosschecked 19 objects
RMAN>
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29802484/viewspace-1418447/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RMAN備份歸檔日誌指令碼指令碼
- RMAN備份歸檔日誌多份 %c
- 備份歸檔日誌
- rman全庫備份備份歸檔日誌檔案
- 備份歸檔日誌檔案
- Oracle設定多個歸檔路徑生成多份歸檔日誌,Rman備份時也只備份其中的一份歸檔日誌Oracle
- oracle rman備份歸檔日誌需要先切換日誌嗎Oracle
- rman備份後為什麼要同時備份歸檔日誌
- 誤刪歸檔日誌除導致備份歸檔日誌失敗
- rman清理歸檔日誌
- RMAN備份資料檔案+控制檔案+歸檔日誌
- 備份之歸檔重做日誌備份
- 手工rm刪除歸檔日誌對備份歸檔日誌的影響
- 歸檔日誌大小 與使用rman 備份後的歸檔日誌產生的備份集大小的關係
- 聯機重做日誌、歸檔日誌、備用重做日誌
- RMAN備份整庫和歸檔日誌的方法
- Oracle RMAN 清除歸檔日誌Oracle
- Oracle RMAN清除歸檔日誌Oracle
- rman維護歸檔日誌
- RMAN備份及恢復歸檔日誌的語法
- 歸檔日誌
- 【Oracle】歸檔日誌管理-設定歸檔日誌路徑以及歸檔日誌冗餘Oracle
- RMAN delete archivelog命令刪除歸檔日誌及歸檔日誌拷貝deleteHive
- 冷備份+歸檔日誌的恢復
- ORACLE RMAN 還原歸檔日誌Oracle
- 作用RMAN 刪除歸檔日誌
- 沒備份,歸檔日誌存在,丟失資料檔案的恢復
- oracle歸檔日誌Oracle
- Oracle 歸檔日誌Oracle
- 歸檔日誌挖掘
- PostgreSQL 歸檔日誌SQL
- 檢視歸檔日誌空間
- oracle rman不能自動刪除歸檔日誌備份解決Oracle
- RMAN備份恢復之歸檔日誌對BLOCKRECOVER的影響BloC
- 使用RMAN備份RAC本地目錄中不是用NFS的歸檔日誌NFS
- 用rman 正確地刪除歸檔日誌
- Oracle使用備份檔案集恢復歸檔日誌Oracle
- rman 刪除指定時間點的歸檔日誌