Oracle Dataguard下备库无备份情况下删除归档日志

如果没有备份机制，想要实现备库归档自动删除，就需要使用快速恢复区(FRA)

检查参数

sqlplus / as sysdba

show parameter db_recovery_file_dest_size;
show parameter db_recovery_file_dest;
# 主要修改参数
# 我这里修改log_archive_dest_1和log_archive_dest_3
show parameter log_archive_dest_1;
show parameter log_archive_dest;

设置参数

sqlplus / as sysdba

# 可根据自己硬盘大小配置
ALTER SYSTEM SET db_recovery_file_dest_size=4096G SCOPE=BOTH;

ALTER SYSTEM SET log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST LGWR SYNC valid_for=(all_logfiles,all_roles) db_unique_name=rmdctcc2' SCOPE=BOTH;

ALTER SYSTEM SET log_archive_dest_3='LOCATION=USE_DB_RECOVERY_FILE_DEST LGWR SYNC valid_for=(STANDBY_LOGFILE,STANDBY_ROLE) db_unique_name=rmdctcc2' SCOPE=BOTH;

配置rman归档策略

# 在备库执行

rman target /

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

重启备库

alter database recover managed standby database cancel;

shutdown immediate

startup mount

# alter database recover managed standby database cancel;

alter database open;

alter database recover managed standby database using current logfile disconnect;