Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

log_archive_dest_state_2=defer or enable ?

JhilOct 27 2015 — edited Oct 27 2015

Hello Everyone,

I am setting following parameters on primary database

I am getting little bit confused for LOG_ARCHIVE_DEST_1 & LOG_ARCHIVE_DEST_2 parameters.

SYS> alter system set log_archive_dest_state_2=defer scope=both;

I have seen some links are recommended to set log_archive_dest_state_2=defer.

Any big difference between defer & enable for LOG_ARCHIVE_DEST_2

Version : 11.2.0.1 on linux

This post has been answered by mseberg on Oct 27 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 24 2015

Added on Oct 27 2015

#data-guard, #performance-availability

9 comments

22,344 views