This content has been marked as final. Show 7 replies
Why is it recommended to have the value as (ONLINE_LOGS,PRIMARY) for LOG_ARCHIVE_DEST_2?It is not recommended, It has to be changed according to the destination type and role.
If you set above value the destination of the archives redo log types and database role. It means the destination database redo log files is type of Online redo logs and the
database_role will be Primary database. You cannot set even as (ONLINE_LOGS, STANDBY) because in standby database environment only the standby redo log files applicable.
From primary database you usually have to set (STANDBY_LOGFILE, STANDBY_ROLE), Because the redo will send and they will be written in standby redo logfiles. recently on the same topic i have written short note in my blog, please check http://www.oracle-ckpt.com/ora-16014-no-available-destinations-on-standby/
What will happen if the value is set as (ALL_LOGIFLES,ALL_ROLES)for LOG_ARCHIVE_DEST_2?If you choose above attributes, then it can applicable for any logfile type either online or standby (and) and any database role Either physical or logical.
I have gone through Oracle 11gR2 data guard concept and administration docs.
As per the Oracle documentation, init file of the primary database is as follows:
Example 3-1 Primary Database: Primary Role Initialization Parameters
LOG_ARCHIVE_DEST_2: Directs transmission of the redo data to the remote physical standby database boston.
My question is why the value is set as (ONLINE_LOGS,PRIMARY) for LOG_ARCHIVE_DEST_2? Why not (STANDBY_LOGFILE, STANDBY_ROLE) as CKPT mentioned