Home / Oracle DBA / DATA GUARD CONFIGURATION MODES

DATA GUARD CONFIGURATION MODES

DATA GUARD CONFIGURATION MODES

  1. MAXIMUM PROTECTION MODE :
  • if you want Architect A no data loss solution ,recommended to configure data guard in maximum protection mode.
  • In this mode, it is  to create stand by redo logs which are of the same size of primary redo logs .In this mode, user gets commit complete  acknowledgement once the data has been written to the primary redo logs  as well as standby redo logs.
  • If primary unable to send the data to at least one stand by , primary goes down automatically, with out giving commit complete acknowledgement .

Note:  upto 10g, we can configure maximum of  “ 9” physical stand by , where as per  11g, we can configure maximum of upto “ 30” physical standby’s.

  1. MAXIMUM PERFORMANCE MODE:
  • In this mode , it is not necessary  to create  stand by redo logs.
  • User gets commit complete acknowledgement once the data has been written to the primary redo logs.
  • With this mode , we cant achive “ a no data loss solution”

 

  1. MAXIMUM AVAILABILTY MODE:
  • Initially configuration  works in protection mode . if primary enable to  ship the data to a least one stand by , primary will not  goes down and automatically configuration works in performance mode.

BENEFITS  OF DATAGUARD  ( or)  ADVANTAGES OF DATAGUARD:

  1. High availability
  2. Disastor Recovery solution ( dr-solution)
  3. Switch over during plan maintenance
  4. Failover during un plan
  5. Stand by can be used for reporting purpose.

 

PRE REPRESENTS CONFIGURE DATAGUARD :

  • Under laying hardware architecture should be same
  • Version of Operating system , version of oracle including patch set level should be same
  • Primary must and should run in Archive log mode .
  • In case of maximum protection mode, it is mandatory to create stand by redo logs which are of the same size of primary redo logs.

 

 

ARCHITECTURAL  COMPONENTS OF DATAGUARD:

  1. PRIMARY DATABASE: The production database that  is used to create  satndy by    The Archive logs  from the primary ndatabase are transferred and applied to standby databases.
  2. STAND BY DATABASE: The database  on which we dependent in the  event of primary collapse.
  3. ORACLE NETWORKING : Facilities moment of data  from  primary to standby
  4. LOG TRANSFORCE SERVICE: Services at primary which ships the data to the physical standby ( ARCH ,LGWR,LNS)
  5. LOG APPLYS SERVICE: Service at standby which applys  the data to the standby database(MRP).
  6. DATA GUARD BROKER: Its optional component generally configured for fasters switch over with minimal commands. If we configured data guard with data guard broker  DMON ( data guard monitor) process gets enabled .
  7. NETWORK TRANSMISSION MODE:
  8. Sync affirm
  9. A sync no affirm

In case of maximum protection mode , network  transmission made  should be “sync affirm”.

ARCHIVE LOG GAP RESOLUTION:  In order  resolve the archive log gap, oracle as introduced the parameters

FAL_CLINT

FAL_SERVER           ( FAL = FETCH ARCHIVE LOG)

DATA GUARD VIEWS:

V$ DATABASE

V$ ARCHIVE_LOG

V$ARCHIVE_GAP

V$MANAGED_STANDBY

V$DATA GUARD_  CONFIG

NOTE:

  1. If you want configure data guard , we required the license of ENTREPRISE EDITION
  2. Oracle golden gate is high performance  hetrogeniese  database replication technology , it requires separate license schema level.

>   data guard is database level replication.

>  in 10gr2 , oracle as introduced “  A SNOP SHOT STANDBY “ where we can open the standby  database in read /write mode.

SNAP SHOT STAND BY:

  • Can be opened  in  read /write mode.
  • Both will not be in “sync”
  • No extra license is required
  • Can not be used for real time reporting

ACTIVE DATA GUARD:

  • Can be opened in read only mode
  • Both will be in sync
  • Extra license is required
  • Can be used for real time reporting.
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

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

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe