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 |
---|---|---|
|
|
Log group number |
|
|
Database ID of the primary database to which the standby redo logfile is assigned. If the standby redo logfile is unassigned, the value |
|
|
Log thread number |
|
|
Log sequence number |
|
|
Size of the log (in bytes) |
|
|
Block size of the logfile (512 or 4096) |
|
|
Number of bytes used in the log |
|
|
Archive status ( |
|
|
Log status:
|
|
|
Lowest SCN in the log |
|
|
Time of the first SCN in the log |
|
|
All redo records contained within this log will have an SCN lower than |
|
|
All redo records contained within this log will have a timestamp lower than |
|
|
All redo records contained within this log will have an SCN lower than L |
|
|
All redo records contained within this log will have a timestamp lower than
|
|
|
The ID of the container to which the data pertains. Possible values include:
|