Hello,
About Oracle 9iR2(9.2.0.1.0) Data Guard physical standby gap problem,i found there has no archived logs on primary from GAP sequence 4257,check on standby as follows,
SQL> select process,status,thread#,sequence#,block#,blocks from v$managed_standby;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
------- ------------ ---------- ---------- ---------- ----------
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 1 5177 1 692
RFS RECEIVING 0 0 0 0
MRP0 WAIT_FOR_GAP 1 4257 0 0
RFS WRITING 1 5178 115786 204800
RFS RECEIVING 0 0 0 0
SQL> select min(sequence#),max(sequence#) from v$archived_log where applied='YES';
MIN(SEQUENCE#) MAX(SEQUENCE#)
-------------- --------------
4256 4256
SQL> select min(sequence#),max(sequence#) from v$archived_log where applied='NO';
MIN(SEQUENCE#) MAX(SEQUENCE#)
-------------- --------------
4257 5177
Have i using RMAN incremental backup to solve it too (such as 10g/11g) ? At the same time,i have no idea about how to query current_scn ON standby and use 'backup incremental from SCN xxxxxx database format 'xxxxxx';' on RMAN prompt and have error.
Please give me some suggestions,thanks!
Best Regards
Quanwen Zhao