V$ARCHIVE_DEST

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

I have stopped updating the blog.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

===================================================================

V$ARCHIVE_DEST displays, for the current instance, all of the destinations in the Data Guard configuration, including each destination's current value, mode, and status.

Column	Datatype	Description
DEST_ID	NUMBER	Log archive destination parameter identifier (1 to 10)
DEST_NAME	VARCHAR2(256)	Log archive destination parameter name
STATUS	VARCHAR2(9)	Identifies the current status of the destination: VALID - Initialized and available INACTIVE - No destination information DEFERRED - Manually disabled by the user ERROR - Error during open or copy DISABLED - Disabled after error BAD PARAM - Parameter has errors ALTERNATE - Destination is in an alternate state FULL - Exceeded quota size for the destination
BINDING	VARCHAR2(9)	Specifies how failure will affect the archival operation: MANDATORY - Successful archival is required OPTIONAL - Successful archival is not required (depends on LOG_ARCHIVE_MIN_SUCCEED_DEST)
NAME_SPACE	VARCHAR2(7)	Identifies the scope of parameter setting: SYSTEM - System definition SESSION - Session definition
TARGET	VARCHAR2(7)	Specifies whether the archive destination is local or remote to the primary database: PRIMARY - local STANDBY - remote
ARCHIVER	VARCHAR2(10)	Identifies the archiver process relative to the database where the query is issued: ARCn FOREGROUND LGWR RFS
SCHEDULE	VARCHAR2(8)	Indicates whether the archival of this destination is INACTIVE, PENDING, ACTIVE, or LATENT
DESTINATION	VARCHAR2(256)	Specifies the location where the archived redo logs are to be archived
LOG_SEQUENCE	NUMBER	Identifies the sequence number of the last archived redo log to be archived
REOPEN_SECS	NUMBER	Identifies the retry time (in seconds) after error
DELAY_MINS	NUMBER	Identifies the delay interval (in minutes) before the archived redo log is automatically applied to a standby database
MAX_CONNECTIONS	NUMBER	Maximum number of connections
NET_TIMEOUT	NUMBER	Number of seconds the log writer process will wait for status from the network server of a network operation issued by the log writer process
PROCESS	VARCHAR2(10)	Identifies the archiver process relative to the primary database, even if the query is issued on the standby database: ARCn FOREGROUND LGWR
REGISTER	VARCHAR2(3)	Indicates whether the archived redo log is registered in the remote destination control file (YES) or not (NO). If the archived redo log is registered, it is available to log apply services.
FAIL_DATE	DATE	Date and time of last error
FAIL_SEQUENCE	NUMBER	Sequence number of the archived redo log being archived when the last error occurred
FAIL_BLOCK	NUMBER	Block number of the archived redo log being archived when the last error occurred
FAILURE_COUNT	NUMBER	Current number of contiguous archival operation failures that have occurred for the destination
MAX_FAILURE	NUMBER	Allows you to control the number of times log transport services will attempt to reestablish communication and resume archival operations with a failed destination
ERROR	VARCHAR2(256)	Displays the error text
ALTERNATE	VARCHAR2(256)	Alternate destination, if any
DEPENDENCY	VARCHAR2(256)	Reserved for future use
REMOTE_TEMPLATE	VARCHAR2(256)	Specifies the template to be used to derive the location to be recorded
QUOTA_SIZE	NUMBER	Destination quotas, expressed in bytes
QUOTA_USED	NUMBER	Size of all the archived redo logs currently residing on the specified destination
MOUNTID	NUMBER	Instance mount identifier
TRANSMIT_MODE	VARCHAR2(12)	Specifies network transmission mode: SYNCHRONOUS PARALLELSYNC ASYNCHRONOUS
ASYNC_BLOCKS	NUMBER	Number of blocks specified for the ASYNC attribute
AFFIRM	VARCHAR2(3)	Specifies disk I/O mode
TYPE	VARCHAR2(7)	Indicates whether the archived log destination definition is PUBLIC or PRIVATE. Only PUBLIC destinations can be modified at runtime using the ALTER SYSTEM SET or ALTER SESSION SET statements. By default, all archived log destinations are PUBLIC.
VALID_NOW	VARCHAR2(16)	Indicates whether the destination is valid right now for archival operations: YES - Redo log type and database role for this destination are valid for the current database WRONG VALID_TYPE - Redo log type specified for this destination is not valid for the current database role. For example, WRONG VALID_TYPE would be returned if a destination specified with the VALID_FOR=(STANDBY_LOGFILE,STANDBY_ROLE) attribute is running in the standby database role but does not have standby redo logs implemented. WRONG VALID_ROLE - Database role specified for this destination is not the role in which the database is currently running. For example, the WRONG VALID_ROLE would be returned when a destination defined with the VALID_FOR=(ONLINE_LOGFILE,STANDBY_ROLE) attribute is running in the primary database role. INACTIVE - Destination is inactive, probably due to an error
VALID_TYPE	VARCHAR2(15)	Redo log type or types that are valid for the destination: ONLINE_LOGFILE STANDBY_LOGFILE ALL_LOGFILES
VALID_ROLE	VARCHAR2(12)	Database role or roles that are valid for the destination: PRIMARY_ROLE STANDBY_ROLE ALL_ROLES
DB_UNIQUE_NAME	VARCHAR2(30)	Unique database name
VERIFY	VARCHAR2(3)	Indicates whether the value of the VERIFY attribute on the LOG_ARCHIVE_DEST_n parameter is verified (YES) or not verified (NO)
COMPRESSION	VARCHAR2(7)	Indicates whether network compression is ENABLED or DISABLED.

Note:

1.       Scripts using V$ARCHIVE_DEST

--show archive destination select dest_name, status, binding, name_space, target, archiver,        schedule, destination, log_sequence, reopen_secs,        delay_mins, TYPE from   V$ARCHIVE_DEST order by 2 desc,1;

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

Oracle dynamic performance views

Last updated: 2009-11-24 Tuesday

V$ARCHIVE_DEST_STATUS

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: VALID - Initialized and available INACTIVE - No destination information DEFERRED - Manually disabled by the user ERROR - Error during open or copy DISABLED - Disabled after error BAD PARAM - Parameter has errors ALTERNATE - Destination is in an alternate state FULL - Exceeded quota size for the destination
TYPE	VARCHAR2(14)	Type of archival destination database: LOCAL - Local to primary database PHYSICAL - Physical standby CROSS-INSTANCE - An instance of the primary LOGICAL - Logical standby
DATABASE_MODE	VARCHAR2(15)	Current mode of the archival destination database: STARTED - Instance started, not mounted MOUNTED - Mounted MOUNTED-STANDBY - Mounted standby OPEN - Open read/write OPEN_READ-ONLY - Open read-only
RECOVERY_MODE	VARCHAR2(23)	Current mode of media recovery at the archival destination database: IDLE - Managed recovery is not active MANUAL - Manual media recovery active MANAGED - Managed recovery is active MANAGED REAL TIME APPLY - Log apply services recover redo data from standby redo logs at the same time the logs are being written to, as opposed to recovering redo from archived redo logs when a log switch occurs
PROTECTION_MODE	VARCHAR2(20)	Indicates whether the database is protected: MAXIMUM PROTECTION MAXIMUM AVAILABILITY RESYNCHRONIZATION MAXIMUM PERFORMANCE UNPROTECTED
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: CHECK CONFIGURATION - This database or destination does not support synchronization. CHECK STANDBY REDO LOG - The standby redo log at this destination is configured improperly. CHECK NETWORK - One or more instances of this database cannot send redo data to this destination. DESTINATION HAS A GAP - This destination is missing redo data needed for synchronization with this database. OK - This destination is synchronized with this database. NOT AVAILABLE - Synchronization status is not available.
SYNCHRONIZED	VARCHAR2(3)	Possible values are: YES - This destination is synchronized with the primary database. NO - The destination is not synchronized with the primary database. UNKNOWN - The synchronization status of this destination cannot be determined.

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

Oracle dynamic performance views

Last updated: 2009-11-24 Tuesday