RFS[10]: Assigned to RFS process 3995
RFS[10]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Primary database is in MAXIMUM PERFORMANCE mode
Mon Feb 17 00:48:30 2014
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[11]: Assigned to RFS process 3997
RFS[11]: Identified database type as 'physical standby'
RFS[11]: Archived Log: '/arch/ARC0000000090_0839199018.0001'
Mon Feb 17 00:49:00 2014
Media Recovery Log /arch/ARC0000000090_0839199018.0001
Media Recovery Waiting for thread 1 sequence 91 (in transit)
--在Primary和Standby上执行以下语句，如果一致说明GAP修复成功，我这里是一致的。
SQL> select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
99
SQL>
--Standby查看GAP信息，修复成功
SQL> select * from v$archive_gap;
no rows selected
SQL> select sequence#,applied from v$archived_log;
SEQUENCE# APP
---------- ---
80 YES
83 YES
86 YES
81 YES
84 YES
85 YES
79 YES
82 YES
78 YES
88 YES
87 YES
SEQUENCE# APP
---------- ---
90 YES
91 YES
92 YES
93 YES
94 YES
95 YES
96 YES
97 YES
98 YES
99 YES
22 rows selected.
SQL> select sequence#,applied from v$archived_log where applied='YES';
SEQUENCE# APP
---------- ---
80 YES
83 YES
86 YES
81 YES
84 YES
85 YES
79 YES
82 YES
78 YES
88 YES
87 YES
SEQUENCE# APP
---------- ---
89 YES
90 YES
91 YES
92 YES
93 YES
94 YES
95 YES
96 YES
97 YES
98 YES
99 YES
22 rows selected.