RMAN - Backup/Recovery Tool

登入 RMAN console

$ rman target /
or
$ rman target / nocatalog 

檢查 DB 備份所需的 archive log 檔是否有缺

RMAN> backup validate database archivelog all;

清除無效的 archive log 檔

NOTE: 備份DB時遭遇到錯誤 ORA-19625，或磁碟空間不足想手動清除 log 時

// validate all archvelogs in your disk. If some are missing, it will treat it as expired.
RMAN> crosscheck archivelog all;

// it ill delete expired archivelog and updates your controlfile.
RMAN> delete expired archivelog all;

backup/restore 驗證測試

backup validate ......
RMAN> backup validate database archivelog all;

restore validate ..... 

列出DB及Archive Log 備份紀錄

RMAN> list backup of archivelog all;