This content has been marked as final. Show 7 replies
Did you try the Oracle documentation?
It is explained well.
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
Did you miss the "Usage Notes" sections where VALID_FOR and every combination of Attribute Values is covered including your question?
Table 14-2 VALID_FOR Attribute Values covers all of this.
if i set VALID_FOR=(standby_logfile,standby_role) for log_archive_dest_2 then the standby redo logfiles will be filled and archived instead of online redo log files on standby ?
am i right my understanding ?
If your standby database is physical , then you're right .
If your standby database is logical ,then you're wrong . why ? because the logical standby database has its own online redo log files.
Yes, i am talking about physical standby only. Thanks for confirmation...