V$ARCHIVE_DEST_STATUS
displays runtime and configuration information for the archived redo log destinations. The information in this view does not persist across an instance shutdown.
Column | Datatype | Description |
---|---|---|
DEST_ID |
NUMBER |
Identifies the log archive destination parameter (1 to 10) |
DEST_NAME |
VARCHAR2(256) |
Log archive destination parameter name |
STATUS |
VARCHAR2(9) |
Current status of the destination:
|
TYPE |
VARCHAR2(14) |
Type of archival destination database:
|
DATABASE_MODE |
VARCHAR2(15) |
Current mode of the archival destination database:
|
RECOVERY_MODE |
VARCHAR2(23) |
Current mode of media recovery at the archival destination database:
|
PROTECTION_MODE |
VARCHAR2(20) |
Indicates whether the database is protected:
|
DESTINATION |
VARCHAR2(256) |
Specifies the location where the redo data is to be archived |
STANDBY_LOGFILE_COUNT |
NUMBER |
Indicates the total number of standby redo logs created on the standby database |
STANDBY_LOGFILE_ACTIVE |
NUMBER |
Indicates the total number of standby redo logs on the standby database that are active and contain primary database online redo log information |
ARCHIVED_THREAD# |
NUMBER |
Identifies the thread number of the most recent archived redo log received at the destination |
ARCHIVED_SEQ# |
NUMBER |
Identifies the log sequence number of the most recent archived redo log received at the destination |
APPLIED_THREAD# |
NUMBER |
Identifies the thread number of the most recent applied redo log received at the destination |
APPLIED_SEQ# |
NUMBER |
Identifies the log sequence number of the most recent applied redo log received at the destination |
ERROR |
VARCHAR2(256) |
Displays the error text |
SRL |
VARCHAR2(3) |
Indicates whether standby redo logfiles are used on the standby database (YES ) or not (NO ) |
DB_UNIQUE_NAME |
VARCHAR2(30) |
Specifies the unique database name of the current instance that was defined with the DB_UNIQUE_NAME attribute on the LOG_ARCHIVE_DEST_ n parameter |
SYNCHRONIZATION_STATUS |
VARCHAR2(22) |
Possible values for this column are as follows:
|
SYNCHRONIZED |
VARCHAR2(3) |
Possible values are:
|