ORACLE DATAGUARD CONFIGURATION SETPS

ORACLE DATAGURAD CONFIGUATION WITH DUPLICATE COMMAND

1.check whether force_logging is enable if not enable force_logging

2. add the mandatory parameter listed below

alter system set log_archive_config='DG_CONFIG=(neft,neft_dr)' scope=both;

alter system set log_archive_dest_1='location=/u01/arch valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=neft' scope=both;
 

alter system set log_archive_dest_2='SERVICE=neft_dr LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=neft_dr' scope=both;
 

alter system set fal_client='neft' scope=both;
 

alter system set fal_server='neft_dr' scope=both;
 

alter system set standby_file_management=auto scope=both;
 

3.configure listener and tns

4.create password file and scp to auxiliary side Note:after scp orpwd file need to be changed according to standby instance name

  

 

 

 

 

 

 

 

                                              AT STANDBY DATABASE SIDE

1.Create the directories according to pfile

2.configure listener and tns at auxiliary side

Note: db_name should be same   and db_unique_name  should be different

3.export ORACLE_SID=neft_dr

4.startup nomount

5.connect to target database as well as auxiliary database

6.execute duplicate target database for standby from active database nofilenamecheck;

 cat initneft_dr.ora

 

 

 

 

Now physical standby database is in sync with primary database.