1. 如果沒有備份機制,想要實作備庫歸檔自動删除,就需要使用快速恢複區(FRA)
檢查目前備庫歸檔的存放位置:
SQL> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
log_archive_dest_1 string location=/archdir valid_for=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standby
2. 更改FRA配置
ALTER SYSTEM SET db_recovery_file_dest_size=60g SCOPE=BOTH;
ALTER SYSTEM SET db_recovery_file_dest=/archdir SCOPE=BOTH;
ALTER SYSTEM SET log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST valid_for=(ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME=standby' SCOPE=BOTH;
3. 重新開機備庫
ALTER DATABASE RECOVER managed standby database cancel;
shutdown immediate
startup mount
ALTER DATABASE RECOVER managed standby database disconnect from session;
此時alert裡顯示新的archivelog存放到FRA裡
Media Recovery Log /archdir/STANDBY/archivelog/2017_07_13/o1_mf_2_265_dpgfvl3o_.arc
4. 配置rman的歸檔删除政策
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;