Friday , August 18 2017
Home / Oracle DBA / How to Configure Oracle Dataguard in Oracle 11g

How to Configure Oracle Dataguard in Oracle 11g

Dataguard is known as replicating the data from one server to another server,here i am showing step by step implementation method.In real time we will called as disaster recover model.

PRIMARY :
IP Address: 192.168.142.128
The DB_NAME IS : CKPT
The primary DB_UNIQUE_NAME IS : CKPT

PHYSICAL STANDBY:
IP Address: 192.168.142.129
The DB_NAME IS : CKPT
The standby DB_UNIQUE_NAME IS: CKPT_STDBY

Required parameters to Implement Dataguard :-
DB_NAME – Must be same on primary and on all standby
DB_UNIQUE_NAME – Must be different on primary and all standby
LOG_ARCHIVE_CONFIG – This parameter includes db_unique_name which are the part of Dataguard configuration
LOG_ARCHIVE_DEST_n – Define local and remote archive log file location
LOG_ARCHIVE_DEST_STATE_n – Define state of archiving (ENABLE or DIFER)
REMOTE_LOGIN_PASSWORDFILE – Must be in EXCLUSIVE mode
FAL_SERVER – Use for archivelog gap resolution (required only in physical standby server)
DB_FILE_NAME_CONVERT – Required when directory structure is different datafile
LOG_FILE_NAME_CONVERT – Required when directory structure is different logfile
STANDBY_FILE_MANAGEMENT – Keep auto to create file automatically on standby

NOTE: YOU CAN DO DATA GUARD CONFIGURATION MUST AND SHOULD CHECK BOTH SERVERS ARE PING OR NOT.

PERFORM FOLLOWING STEPS ON PRIMARY SIDE :

< STEP 1> : PRIMARY DATABASE IS NO ARCHIVE LOG MODE THEN YOU SWITCH ARCHIVE MODE AND ENABLE FORCE LOGGING .

< STEP 2> : CREATE PFILE FROM SPFILE:

NOTE: shut down the database from primary database side

< STEP 3> : AFTER CREATING A PARAMETER FILE, OPEN AND EDIT IN THIS SAME SCENARIO:

< STEP 4> : IN THIS CASE YOU CAN CONFIGURE LISTENER.ORA FILE AND TNS NAMES.ORA FILE.

  • CONFIGURE LISTENER.ORA FILE

  • CONFIGURE TNSNAMES.ORA FILE

<STEP 5> : CREATE A PASSWORD FILE TO A PRIMARY DATABASE SIDE:

<STEP 6> BY USING “SCP ” MUST AND SHOULD COPY ON PFILE AT PRIMARY DATABASE TO STANDBY DATABASE FROM /home/oracle/ location .

Note : after copying pfile from primary database to standby processing you get a password option , thats pasword is your create a oracle password.

<STEP 7 > : START THE PRIMARY DATABASE

PERFORM FOLLOWING STEPS ON PHYSICAL STANDBY SIDE :

< STEP 1> : IF YOU COPYING A PFILE FROM PRIMARY DATABASE TO PHYSICAL STANDBY ,THEN LET’S CHECK IT PHYSICAL STANDBY AT ORACLE HOME . AFTER THAT LET’S COPY TO initckpt.ora to initckpt_stdby.ora ,then move to $HOME_ORACLE/dbs location .

<STEP 2> : OPEN A PARAMETER FILE THEN LET’S CHANGE IN THIS FORM .

<STEP 3> :CREATE A REQUIRED DIRECTORY

<STEP 4> : CREATE “adump ” directory

<STEP 5> CONFIGURE LISTENER.ORA FILE & TNSNAMES.ORA FILE AT PHYSICAL STANDBY SIDE

  • CONFIGURE LISTENER.ORA FILE

  • CONFIGURE TNSNAMES.ORA FILE

<STEP 6> CREATE ORA PASSWORD FILE AT PHYSICAL STANDBY SIDE

NOTE: you create a orapassword file in both sides must and should password is should be same

< STEP 7> START THE STANDBY DATABASE IN NOMOUNT STATE:

< STEP 7> START THE STANDBY DATABASE IN NOMOUNT STATE:

PERFORM FOLLOWING STEPS ON PRIMARY SIDE :
< STEP 8 > : export the “OARCLE_SID” then you should be observe this two things
connected to target database: CKPT (DBID=1925149927)
connected to auxiliary database: CKPT (not mounted)
After that we connect to the duplicate target database at prrimary database side.

 

 

 

Comments

comments

Check Also

How to switch on primary database to physical standby database

After configuration data guard then data is switching  into primary database  to standby database : …

Leave a Reply

Your email address will not be published. Required fields are marked *