ORACLE v$managed_standby字段及值解释

TESTDG>desc v$managed_standby
名称                                      是否为空? 类型
----------------------------------------- -------- ----------------------------
PROCESS                                            VARCHAR2(9)
PID                                                     NUMBER
STATUS                                               VARCHAR2(12)
CLIENT_PROCESS                               VARCHAR2(8)
CLIENT_PID                                        VARCHAR2(40)
CLIENT_D BI D                                      VARCHAR2(40)
GROUP#                                             VARCHAR2(40)
RESETLOG_ID                                     NUMBER
THREAD#                                            NUMBER
SEQUENCE#                                       NUMBER
BLOCK#                                              NUMBER
BLOCKS                                              NUMBER
DELAY_MINS                                       NUMBER
KNOWN_AGENTS                                NUMBER
ACTIVE_AGENTS                                 NUMBER

标记的字段的含义解释

Oracle® Database Reference
10g Release 1 (10.1)
Part Number B10755-01 
Contents 
Index 


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

Previous 
Next 
V$MANAGED_STANDBY
V$MANAGED_STANDBY displays current status information for some Oracle Database processes related to physical standby databases in the Data Guard environment. This view does not persist after an instance shutdown.

Column Datatype Description 
PROCESS VARCHAR2(9) Type of 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)

PID NUMBER Operating system process identifier of process 
STATUS VARCHAR2(12) Current 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

CLIENT_PROCESS VARCHAR2(8) Identifies the corresponding primary database process: 
Archival - Foreground (manual) archival process (SQL)

ARCH - Background ARCn process

LGWR - Background LGWR process

CLIENT_PID VARCHAR2(40) Operating system process identifier of the client process 
CLIENT_DBID VARCHAR2(40) Database identifier of the primary database 
GROUP# VARCHAR2(40) Standby redo log group 
RESETLOG_ID NUMBER Resetlogs identifier of the archived redo log 
THREAD# NUMBER Archived redo log thread number 
SEQUENCE# NUMBER Archived redo log sequence number 
BLOCK# NUMBER Last processed archived redo log block number 
BLOCKS NUMBER Size of the archived redo log in 512-byte blocks 
DELAY_MINS NUMBER Archived redo log delay interval in minutes 
KNOWN_AGENTS NUMBER Total number of standby database agents processing an archived redo log 
ACTIVE_AGENTS NUMBER Number of standby database agents actively processing an archived redo log