DataGuard GAP 修复2-- 归档日志存在

配套视频：《Oracle11g DataGuard 管理》

1.主库把缺失的归档日志传输到备库
[oracle@dgdb1 ~]$ scp

2.在备库注册输过来的归档日志：
SQL> alter database register logfile '/home/oracle/1_87_1024761634.dbf';
SQL> select * from v$archive_gap;
SQL> alter database register logfile '/home/oracle/1_88_1024761634.dbf';
SQL> select * from v$archive_gap;
SQL> alter database register logfile '/home/oracle/1_89_1024761634.dbf';
SQL> select * from v$archive_gap;

3.主库切换日志验证GAP是否修复完成：
SQL> alter system switch logfile;

5.查看日志应用情况<主、备库上执行对比>
SQL> select unique thread#,max(sequence#) over(partition by thread#) last from v$archived_log;