7.32 V$ARCHIVE_DEST_STATUS
V$ARCHIVE_DEST_STATUS
displays run time and configuration information for the archived redo log destinations.
The information in this view does not persist across an instance shutdown.
Column | Datatype | Description |
---|---|---|
|
|
Identifies the log archive destination parameter (1 to 31) |
|
|
Log archive destination parameter name |
|
|
Current status of the destination:
|
|
|
Type of archival destination database:
|
|
|
Current mode of the archival destination database:
|
|
|
Current apply mode at the archival destination:
|
|
|
Indicates whether the database is protected:
|
|
|
Specifies the location where the redo data is to be archived |
|
|
Indicates the total number of standby redo logs created on the standby database |
|
|
Indicates the total number of standby redo logs on the standby database that are active and contain primary database online redo log information |
|
|
Identifies the thread number of the most recent archived redo log received at the destination |
|
|
Identifies the log sequence number of the most recent archived redo log received at the destination |
|
|
Identifies the thread number of the most recent applied redo log received at the destination |
|
|
Identifies the log sequence number of the most recent applied redo log received at the destination |
|
|
Displays the error text |
|
|
Indicates whether standby redo logfiles are used on the standby database ( |
|
|
Specifies the unique database name of the current instance that was defined with the |
|
|
Possible values for this column are as follows:
See Also: Oracle Data Guard Concepts and Administration for more information about redo transport configuration |
|
|
Possible values are:
|
|
|
Redo gap status:
|
|
|
The ID of the container to which the data pertains. Possible values include:
|