INSTANCE_NUMBER |
NUMBER |
Instance number used for instance registration. Corresponds to INSTANCE_NUMBER initialization parameter
See "INSTANCE_NUMBER" |
INSTANCE_NAME |
VARCHAR2(16) |
Instance name |
HOST_NAME |
VARCHAR2(64) |
Name of the host machine |
VERSION |
VARCHAR2(17) |
RDBMS version |
STARTUP_TIME |
DATE |
Time when instance was started up |
STATUS |
VARCHAR2(7) |
STARTED/MOUNTED/OPEN
STARTED after startup nomount
MOUNTED after startup mount or alter database close
OPEN after startup or after database open |
PARALLEL |
VARCHAR2(3) |
YES/NO in parallel server mode |
THREAD# |
NUMBER |
Redo thread opened by the instance |
ARCHIVER |
VARCHAR2(7) |
STOPPED | STARTED | FAILED. FAILED means that the archiver failed to archive a log last time, but will try again within 5 minutes |
LOG_SWITCH_WAIT |
VARCHAR2(11) |
ARCHIVE LOG/CLEAR LOG/CHECKPOINT event log switching is waiting for. Note that if ALTER SYSTEM SWITCH LOGFILE is hung, but there is room in the current online redo log, then value is NULL |
LOGINS |
VARCHAR2(10) |
ALLOWED/RESTRICTED |
SHUTDOWN_PENDING |
VARCHAR2(3) |
YES/NO |
DATABASE_STATUS |
VARCHAR2(17) |
The status of the database |
INSTANCE_ROLE |
VARCHAR2(16) |
Describes whether the instance is an active instance (PRIMARY_INSTANCE) or a inactive secondary instance (SECONDARY_INSTANCE), or UNKNOWN if the instance has been started but not mounted. |
|
|
Note: SECONDARY_INSTANCE is displayed only if your cluster has just two instances and you have set the ACTIVE_INSTANCE_COUNT initialization parameter to 1. |