Dataguard设置备端日志延迟应用,需要在主端 log_archive_dest_n 参数上使用“DELAY=”,比如:DELAY=5(单位为分钟),表示延时5分钟。只写DELAY,没有指定具体值,默认为30分钟。
注意:如果备端开启了日志实时应用,设置延迟应用时,并不会生效。
WARNING: Managed Standby Recovery started with REAL TIME APPLY DELAY 5 minutes specified at primary ignored
因此需要先关闭实施应用,在开启延迟应用:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
主端设置 log_archive_dest_n 开启延迟应用:
alter system set log_archive_dest_2=‘SERVICE=RACDG LGWR ASYNC REOPEN NET_TIMEOUT=300 DELAY=5 VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=RACDG’ sid=‘*’;
检查日志延迟应用:
–sql查询:
select name,value from v$dataguard_stats;
NAME VALUE
----------------------- ----------------
transport lag +00 00:00:00
apply lag +00 00:04:43
apply finish time +00 00:00:00.031
estimated startup time 19
–日志查询:
Fri Dec 10 10:35:18 2021
Media Recovery Delayed for 5 minute(s) (thread 2 sequence 16) <<<<<<日志延迟应用5分钟生效
Fri Dec 10 10:40:18 2021
Media Recovery Log /arch/racdg/2_16_1090686008.dbf <<<<<<5分钟后开始应用
Media Recovery Log /arch/racdg/1_26_1090686008.dbf