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:
|
Note:
1. Scripts using V$ARCHIVE_DEST_STATUS
select dest_name, status, type, database_mode, recovery_mode, protection_mode, destination, applied_seq#, error from V$ARCHIVE_DEST_STATUS order by 2 desc; |
Oracle data dictionary views
Last updated: 2009-11-24 Tuesday |
No comments:
Post a Comment