Active/Inactive indicates whether there was problem accessing destination - Oracle Redo Log

Q.  What indicates whether there was a problem accessing the destination in an Archive Destination Status?
- Published on 29 Jul 15

a. Enabled/Disabled
b. Active/Inactive
c. Valid/Invalid
d. All mentioned above

ANSWER: Active/Inactive
 

    Discussion

  • Nirja Shah   -Posted on 24 Sep 15
    - Each archive destination has the following variable characteristics that determine its status:
    1. Valid/Invalid - It indicates whether the disk location or service name information is specified and valid

    2. Enabled/Disabled - It indicates the availability state of the location and whether the database can use the destination

    3. Active/Inactive - It indicates whether there was a problem accessing the destination

    - Several combinations of these characteristics are possible.

    - To obtain the current status and other information about each destination for an instance, query the V$ARCHIVE_DEST view.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)