Oracle DG 手动备库应用缺失日志

--1. 模拟primary 生成丢失logfile

--1. 1 primary --设置延迟传输

SQL> alter system set log_archive_dest_state_2=defer;

--1.2 切换日志

SQL> alter system archive log current;

SQL> insert into t values(300);
 
SQL> commit;
SQL> alter system archive log current;

--1.3 check primary log sequence

SQL> archive log list;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     17
Next log sequence to archive   19
Current log sequence           19
 

--1.4 check logfile

/u01/app/oracle/oradata/flash_recovery_area/ORCL/archivelog/2023_03_18
[oracle@rhel64 2023_03_18]$ ll
total 170608
-rw-r----- 1 oracle oinstall 172873216 Mar 18 22:20 o1_mf_1_12_l1cl5q6w_.arc
-rw-r----- 1