Friday , October 20 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

Moving a database from Normal File System to ASM storage

Default storage for oracle database is File System, where database files resides on local storage. …

Leave a Reply

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