Oracle Dataguard Parameters for Physical Standby Creation in 12c and 11g

-
Oracle Dataguard we can configure different methods, but in this post we are posting only parameters list we are using in the real time to sync standby.

ORACLE DATAGUARD PARAMETERS


ORACLE SID in Primary - ORCLPR
ORACLE SID in Standby - ORCLDR

Set These Parameters for Primary:

log_archive_dest_1="LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ORCLPR"
log_archive_dest_2="service=ORCLDR LGWR ASYNC NOAFFIRM valid_for=(online_logfiles,primary_role) db_unique_name=ORCLDR"
log_archive_config='DG_CONFIG=(ORCLPR,ORCLDR)'
db_unique_name='ORCLPR'  (this parameter is static db bounce required to reflect this parameter)
log_archive_dest_state_1=ENABLE
log_archive_dest_state_2=ENABLE
standby_file_management=auto
fal_server=ORCLDR

Use these Parameters for Standby:

log_archive_dest_1="LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ORCLDR"
log_archive_dest_2="service=ORCLPR LGWR ASYNC NOAFFIRM valid_for=(online_logfiles,primary_role) db_unique_name=ORCLPR"
log_archive_config='DG_CONFIG=(ORCLPR,ORCLDR)'
db_unique_name='ORCLDR'  (this parameter is static db bounce required to reflect this parameter)
log_archive_dest_state_1=ENABLE
log_archive_dest_state_2=DEFER
standby_file_management=auto
fal_server=ORCLPR (this parameter is useful whenever gap is there fal server automatically send request to primary
oracle dataguard parameters for standby in 12c 11g


You can use " alter system set " command to set all these parameters, for static parameter db_unique_name use scope=spfile 

Popular posts from this blog

How to Move OCR and Voting files to Another ASM Diskgroup 11g 12c

-
Image
If you have requirement to change OCR and Voting files location to another ASM Diskgroup, it is possible to change but before changing OCR and Voting files to another ASM Diskgroup with High/Normal/External redundancy follow below Instructions in 11gR2 and 12cR1/12cR2. Moving OCR and Voting Files to Another ASM Diskgroup 11g/12c Steps: First Create New ASM Diskgroup with External/Normal/High Redundancy Take output of ocrcheck command output [root@ORACLE ACS bin]# ./ocrcheck Status of Oracle Cluster Registry is as follows :          Version                  :          3          Total space (kbytes)     :     262120          Used space (kbytes)      :       3308          Available space (kbytes) :     258812     ...
Read more

What is Compartment in Oracle Cloud Infrastructure (OCI)

-
Image
Compartment is one of the Resource in Oracle Cloud Infrastructure but Compartment are Logical not physical, once you created Compartment you cannot delete in your tenancy but you can rename the compartment. Every Compartment in Oracle Cloud have OCID this is very important while dealing with Oracle Cloud Support. compartments are very useful to organize cloud resources in a Tenancy. Main Points of Compartment in OCI: Compartments are Global By Default you will get root compartment when you signup Compartment is a Logical Resource You can delete Compartment once you created in your tenancy You can Rename Compartment You can create Child Compartment up to six now you can move resources from one compartment to another compartment Compartment is one of the Sub-topic of IAM. FAQ: What is Compartment in OCI? A) Compartments is one of the Oracle Cloud Unique Feature and Compartments are Logical Can I delete Compartment? A) Yes possible, you can delete and rena...
Read more