oracle+dg常用命令,DG 日常管理命令汇总

主库(确认ARCH进程正常)

SQL> SELECT PROCESS, CLIENT_PROCESS, SEQUENCE#, STATUS FROM V$MANAGED_STANDBY;

PROCESS CLIENT_PROCESS SEQUENCE# STATUS

------------------ ---------------- ---------- ------------------------

ARCH ARCH 731 CLOSING

DGRD N/A 0 ALLOCATED

DGRD N/A 0 ALLOCATED

ARCH ARCH 732 CLOSING

ARCH ARCH 733 CLOSING

ARCH ARCH 734 CLOSING

LNS LNS 735 WRITING

DGRD N/A 0 ALLOCATED

DGRD N/A 0 ALLOCATED

备库(要确认存在MRP、ARCH、RFS进程)

SQL> SELECT PROCESS, CLIENT_PROCESS, SEQUENCE#, STATUS FROM V$MANAGED_STANDBY;

PROCESS CLIENT_PROCESS SEQUENCE# STATUS

------------------ ---------------- ---------- ------------------------

ARCH ARCH 735 CLOSING

DGRD N/A 0 ALLOCATED

DGRD N/A 0 ALLOCATED

ARCH ARCH 731 CLOSING

ARCH ARCH 693 CLOSING

ARCH ARCH 692 CLOSING

RFS LGWR 736 IDLE

RFS UNKNOWN 0 IDLE

RFS UNKNOWN 0 IDLE

RFS Archival 0 IDLE

RFS LGWR 694 IDLE

PROCESS CLIENT_PROCESS SEQUENCE# STATUS

------------------ ---------------- ---------- ------------------------

MRP0 N/A 736 APPLYING_LOG

RFS UNKNOWN 0 IDLE

RFS Archival 0 IDLE