DEFER indicate location is temporarily disabled - Oracle Redo Log

Q.  What does the status DEFER indicate in the LOG_ARCHIVE_DEST_STATE_n initialization parameter which lets you control the availability state of the specified destination (n)?
- Published on 12 Aug 15

a. Indicates that the database can use the destination
b. Indicates that the location is temporarily disabled
c. Indicates that the destination is an alternate
d. All mentioned above

ANSWER: Indicates that the location is temporarily disabled

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 24 Sep 15
    - The LOG_ARCHIVE_DEST_STATE_n (where n is an integer from 1 to 10) initialization parameter lets you control the availability state of the specified destination (n).

    - ENABLE - It indicates that the database can use the destination.

    - DEFER - It indicates that the location is temporarily disabled.

    - ALTERNATE - It indicates that the destination is an alternate.

    - The availability state of the destination is DEFER, unless there is a failure of its parent destination, in which case its state becomes ENABLE.

➨ 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.)
▲