如果没有备份机制,想要实现备库归档自动删除,就需要使用快速恢复区(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;