RMAN - Backup/Recovery Tool

第一次使用 RMAN

常用 RMAN 指令

登入 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 ..... 

參考網站

• Creating an RMAN Recovery Catalog
• Registering a Database with a Recovery Catalog
• Remove a Database from a RMAN Recovery Catalog