ITPub博客

首页 > 数据库 > Oracle > 监控DG视图v$managed_standby字段注解

监控DG视图v$managed_standby字段注解

原创 Oracle 作者:lwitpub 时间:2014-10-16 14:57:54 0 删除 编辑
一般DG安装完之后,或者在运行中,我们都会通过一个重要的视图v$managed_standby监控各进程的状态,以及归档应用情况。
比如下面在standby 上查询如下,这里主库是RAC:
SQL> select process,status,thread#,sequence# from v$managed_standby order by 3,1;

PROCESS   STATUS          THREAD#  SEQUENCE#
--------- ------------ ---------- ----------
RFS       IDLE                  0          0
RFS       IDLE                  0          0
RFS       IDLE                  0          0
RFS       IDLE                  0          0
ARCH      CLOSING               1      13411
ARCH      CLOSING               1      13412
RFS       IDLE                  1      13413
ARCH      CLOSING               2       8849
ARCH      CLOSING               2       4101
MRP0      APPLYING_LOG          2       8850
RFS       IDLE                  2       8850
这里,process就是进程名,包括ARCH, RFS, MRP0等,对应英文解释如下:
Type of the process whose information is being reported:
  • RFS - Remote file server----接收进程

  • MRP0 - Detached recovery server process----恢复进程

  • MR(fg) - Foreground recovery session

  • ARCH - Archiver process

  • FGRD

  • LGWR

  • RFS(FAL)

  • RFS(NEXP)

  • LNS - Network server process

重要的是status字段,表示当前的进程状态,先看英文解释如下:
  • UNUSED - No active process

  • ALLOCATED - Process is active but not currently connected to a primary database

  • CONNECTED - Network connection established to a primary database

  • ATTACHED - Process is actively attached and communicating to a primary database

  • IDLE - Process is not performing any activities

  • ERROR - Process has failed

  • OPENING - Process is opening the archived redo log

  • CLOSING - Process has completed archival and is closing the archived redo log

  • WRITING - Process is actively writing redo data to the archived redo log

  • RECEIVING - Process is receiving network communication

  • ANNOUNCING - Process is announcing the existence of a potential dependent archived redo log

  • REGISTERING - Process is registering the existence of a completed dependent archived redo log

  • WAIT_FOR_LOG - Process is waiting for the archived redo log to be completed

  • WAIT_FOR_GAP - Process is waiting for the archive gap to be resolved

  • APPLYING_LOG - Process is actively applying the archived redo log to the standby database

中文解释如下:
ALLOCATED: 正在准备但还未连接主库
ATTACHED: 正在连接到主库
CONNECTED:已经连接到主库
IDLE:空闲
ERROR:失败的进程,需要关注
RECEIVING:归档日志接收中
OPENING:归档日志处理中
CLOSING:归档日志处理完,正在收尾中
WRITING: 进程在将REDO数据写向归档文件中
WAIT_FOR_LOG:等待新的REDO归档数据中
WAIT_FOR_GAP:归档有中断,正在等待中断的那部分REDO数据.
APPLYING_LOG:正在应用REDO归档数据到备库

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/628922/viewspace-1300713/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-05-08

  • 博文量
    107
  • 访问量
    395357