Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

V$ARCHIVE_GAP

V$ARCHIVE_GAP displays information about archive gaps on a standby database. This view can be used to find out the current archive gap that is blocking recovery.

Column Datatype Description

DEST_ID

NUMBER

Identifies the log archive destination parameter (1 to 10)

DEST_NAME

VARCHAR2(256)

???

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

TYPE

VARCHAR2(14)

Identifies the type of archival destination database:

  • LOCAL - Local to primary database
  • PHYSICAL - Physical standby
  • CROSS-INSTANCE - An instance of the primary

DATABASE_MODE

VARCHAR2(15)

Identifies the 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(7)

Identifies the 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

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 archived redo logs are 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 the use of standby redo logfiles on the standby database (YES) or (NO)