有一套10g的DG发现不同步,备库显示MRP进程正在等待gap的归档日志,需要从387105-387676 SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY; PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS --------- ------------ ---------- ---------- ---------- ---------- ARCH CLOSING 1 387677 2033665 1047 ARCH CLOSING 1 387676 2033665 1048 MRP0 WAIT_FOR_GAP 1 387105 0 0 RFS IDLE 0 0 0 0 RFS IDLE 1 387678 638776 1 SQL> SELECT max(sequence#) from v$archived_log where applied='YES'; MAX(SEQUENCE#) -------------- 387104 而主库的归档日志已经被删除,则只能通过增量备份的方式 根据当前scn对主库进行增量备份 -- 查询备库当前scn SQL> select to_char(current_scn) from v$database; TO_CHAR(CURRENT_SCN) ---------------------------------------- 9164156262 run{ allocate channel t1 type……

阅读全文