V$STANDBY_LOG
displays information about standby redo logs. Standby redo logs are similar to online redo logs, but standby redo logs are only used on a standby database that is receiving redo data from the primary database.
Column | Datatype | Description |
---|---|---|
GROUP# |
NUMBER |
Log group number |
DBID |
VARCHAR2(40) |
Database ID of the primary database to which the standby redo logfile is assigned. If the standby redo logfile is unassigned, the value UNASSIGNED will be displayed. |
THREAD# |
NUMBER |
Log thread number |
SEQUENCE# |
NUMBER |
Log sequence number |
BYTES |
NUMBER |
Size of the log (in bytes) |
USED |
NUMBER |
Number of bytes used in the log |
ARCHIVED |
VARCHAR2(3) |
Archive status (YES ) or (NO ) |
STATUS |
VARCHAR2(10) |
Log status:
|
FIRST_CHANGE# |
NUMBER |
Lowest SCN in the log |
FIRST_TIME |
DATE |
Time of first SCN in the log |
LAST_CHANGE# |
NUMBER |
Last change number made to this datafile. Set to NULL if the datafile is being changed. |
LAST_TIME |
DATE |
Time stamp of the last change |