查看DATAGUARD相关命令

//启用

SQL> alter database recover managed standby database disconnect from session;


Database altered.

//关闭
SQL> alter database recover managed standby database cancel;


Database altered.


SQL> 

//查看standby保护模式和保护级别

SQL> select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;


DATABASE_ROLE    PROTECTION_MODE      PROTECTION_LEVEL
---------------- -------------------- --------------------
PHYSICAL STANDBY MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE

//查看standby日志应用情况

SQL> select sequence#,applied from v$archived_log where applied='YES';


 SEQUENCE# APPLIED
---------- ---------
      2550 YES
      2552 YES
      2551 YES
      2554 YES
      2553 YES
      2558 YES
      2555 YES
      2556 YES
      2557 YES
      2543 YES
      2542 YES


 SEQUENCE# APPLIED
---------- ---------
      2541 YES
      2546 YES
      2544 YES
      2545 YES
      2549 YES
      2548 YES
      2547 YES
      2559 YES
      2560 YES
      2561 YES
      2562 YES


 SEQUENCE# APPLIED
---------- ---------
      2563 YES
      2564 YES
      2565 YES

//查看standby归档路径的相关状态

SQL> SELECT DEST_NAME,STATUS,DESTINATION, ERROR FROM V$ARCHIVE_DEST;


DEST_NAME            STATUS    DESTINATION                    ERROR
-------------------- --------- ------------------------------ ----------
LOG_ARCHIVE_DEST_1   VALID     /archivelog
LOG_ARCHIVE_DEST_2   VALID     orcl
LOG_ARCHIVE_DEST_3   INACTIVE
LOG_ARCHIVE_DEST_4   INACTIVE
LOG_ARCHIVE_DEST_5   INACTIVE
LOG_ARCHIVE_DEST_6   INACTIVE
LOG_ARCHIVE_DEST_7   INACTIVE
LOG_ARCHIVE_DEST_8   INACTIVE
LOG_ARCHIVE_DEST_9   INACTIVE
LOG_ARCHIVE_DEST_10  INACTIVE
LOG_ARCHIVE_DEST_11  INACTIVE


DEST_NAME            STATUS    DESTINATION                    ERROR
-------------------- --------- ------------------------------ ----------
LOG_ARCHIVE_DEST_12  INACTIVE
LOG_ARCHIVE_DEST_13  INACTIVE
LOG_ARCHIVE_DEST_14  INACTIVE
LOG_ARCHIVE_DEST_15  INACTIVE
LOG_ARCHIVE_DEST_16  INACTIVE
LOG_ARCHIVE_DEST_17  INACTIVE
LOG_ARCHIVE_DEST_18  INACTIVE
LOG_ARCHIVE_DEST_19  INACTIVE
LOG_ARCHIVE_DEST_20  INACTIVE
LOG_ARCHIVE_DEST_21  INACTIVE
LOG_ARCHIVE_DEST_22  INACTIVE


DEST_NAME            STATUS    DESTINATION                    ERROR
-------------------- --------- ------------------------------ ----------
LOG_ARCHIVE_DEST_23  INACTIVE
LOG_ARCHIVE_DEST_24  INACTIVE
LOG_ARCHIVE_DEST_25  INACTIVE
LOG_ARCHIVE_DEST_26  INACTIVE
LOG_ARCHIVE_DEST_27  INACTIVE
LOG_ARCHIVE_DEST_28  INACTIVE
LOG_ARCHIVE_DEST_29  INACTIVE
LOG_ARCHIVE_DEST_30  INACTIVE
LOG_ARCHIVE_DEST_31  INACTIVE
STANDBY_ARCHIVE_DEST VALID     /archivelog

//查看standby相关进程情况

SQL> select process,status from v$managed_standby;


PROCESS   STATUS
--------- ------------
ARCH      CLOSING
ARCH      CONNECTED
ARCH      CONNECTED
ARCH      CLOSING
RFS         IDLE
RFS         IDLE
MRP0      WAIT_FOR_LOG

//查看standby后台恢复进程mrp

[oracle@localhost ~]$ ps -ef |grep mrp
oracle    8947     1  0 02:33 ?        00:00:00 ora_mrp0_orcl
oracle    8975  8428  0 02:34 pts/4    00:00:00 grep mrp