Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 6 of 179


V$ARCHIVE_DEST

This view describes, for the current instance, all the archive log destinations, their current value, mode, and status.

Column  Datatype  Description 

DEST_ID 

NUMBER 

ID (1-5) 

STATUS 

VARCHAR2(9) 

Status:

  • 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

 

BINDING 

VARCHAR2(9) 

Requirement for success:

  • MANDATORY- must succeed

  • OPTIONAL - need not succeed (depends on LOG_ARCHIVE_MIS_SUCCEED_DEST)

 

NAME_SPACE 

VARCHAR2(7) 

Definition scope:

  • SYSTEM-System definition

  • SESSION-Session definition

 

TARGET 

VARCHAR2(7) 

Target:

  • PRIMARY-Copy to primary

  • STANDBY-Copy to standby

 

REOPEN_SECS 

NUMBER 

Retry time in seconds (after error) 

DESTINATION 

VARCHAR2(256) 

Destination text string (translated primary location or standby service name) 

FAIL_DATE 

DATE 

Date and time of any last error 

FAIL_SEQUENCE 

NUMBER 

Any log sequence number at last error 

FAIL_BLOCK 

NUMBER 

Any block number at last error 

ERROR 

VARCHAR2(256) 

Text of any last error 

m

See Also:

 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index