监控DG视图v$managed_standby字段注解 2
来源:互联网 发布:淘宝没有分期购选项 编辑:程序博客网 时间:2024/05/20 05:54
比如下面在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
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归档数据到备库
- 监控DG视图v$managed_standby字段注解 2
- ORACLE v$managed_standby字段及值解释
- v$sql视图字段解释
- 视图 v$session & v$process 字段说明
- v$sysstat视图监控oracle性能
- V$session 视图相关字段说明
- 对视图V$PARAMETER字段的说明
- v$session 视图中的 FAILOVER_TYPE 字段
- 通过两个视图监控快速回复区:V$RECOVERY_FILE_DEST and V$RECOVERY_AREA_USAGE.
- V$视图
- 对视图V$SESSION_WAIT和V$PX_SESSION的部分字段解释
- DG下手工处理v$archive_gap方法
- V$SESSION视图和V$PROCESS视图
- V$SQL视图中SQL_TEXT的SQL语句是绑定变量,常量在v$sql_bind_capture视图的VLUE_STRING字段中可以查到
- 改变DG长字段内容为...
- 求教V$视图
- v$session_event视图
- v$archived_log视图
- ASP.NET会员管理系统源码
- Git相关知识(分支管理、主要命令和冲突解决)
- Android Studio如何发布APK
- C++动态链接库(二)
- PHP将ppt转成图片查看
- 监控DG视图v$managed_standby字段注解 2
- CoordinatorLayout实现工具栏及页面头部的伸缩与折叠
- I2C操作笔记,以AT24C04为例
- Git使用
- SVN删除和恢复
- CC150小结概念与算法
- 欢迎使用CSDN-markdown编辑器
- Android中Spinner的使用及其详细总结(可实现下拉列表)
- Java语言实现Luhn算法检验银行卡号