This discussion is archived
11 Replies Latest reply: Mar 13, 2013 11:48 AM by Jimbo RSS

Setting up Data Guard

Jimbo Explorer
Currently Being Moderated
Hi,

I am a newbie to data guard and was wondering what do I need to do to deploy it. So far I have an 11gR2 database up and running.

Q1. How do I create a standby database ( I have decided on a physical standby ) ?

Q2. Do I have to deploy anything other than 11gR2 Oracle Home on my primary and standby servers ?

Q3. I see from some documentation that primary / standby databases can be managed using either sqlplus or dgmgrl - which would be the norm ?

Q4. Presently I only have my primary and proposed standby server - I have also read that it is better to deploy Data Guard Broker on a separate server from these 2. If I only have 2 servers, is it therefore better just to manage Data Guard using sqlplus on each server ?

Q5. What's the most appropriate document to follow when I am trying to deploy Data Guard for the first time

any advice greatly appreciated,
Jim
  • 1. Re: Setting up Data Guard
    mseberg Guru
    Currently Being Moderated
    Jim;

    You can start with

    http://www.visi.com/~mseberg/data_guard_on_oracle_11_step_by_step.html


    Q1. How do I create a standby database ( I have decided on a physical standby ) ?

    See first link.

    Q2. Do I have to deploy anything other than 11gR2 Oracle Home on my primary and standby servers ?

    Think of Data Guard a an exact copy of your primary database in Standby mode. No deploy.

    Q3. I see from some documentation that primary / standby databases can be managed using either sqlplus or dgmgrl - which would be the norm ?

    I would start with SQL Plus to get the feel of things and then move to Data Guard Broker once I have a handle on things.

    Q4. Presently I only have my primary and proposed standby server - I have also read that it is better to deploy Data Guard Broker on a separate server from these 2. If I only have 2 servers, is it therefore better just to manage Data Guard using sqlplus on each server ?

    Data Guard Broker - No there's a third piece for fast start failover called observer. That should be on a third server. This is an advance topic. I would setup a test server and work it awhile before thinking about this. SQL Plus is good then move to Data Guard broker. Warning, once you move to Broker you cannot mix SQL Plus command you hvae to just use Broker.

    Q5. What's the most appropriate document to follow when I am trying to deploy Data Guard for the first time.

    Data Guard Concepts and Administration 11g Release 2 (11.2) E10700-02 - See Chapter 3 "Creating a Physical Standby Database"

    Additional information :

    RMAN DUPLICATE FOR STANDBY

    http://www.visi.com/~mseberg/duprman.html

    http://www.visi.com/~mseberg/duprman2.html

    Data Guard Listener Example

    http://www.visi.com/~mseberg/data_guard/Data_Guard_Listener_Example.html


    Monitor Data Guard Transport


    http://www.visi.com/~mseberg/data_guard/monitor_data_guard_transport.html

    Create a Standby database from an active database using RMAN

    http://www.visi.com/~mseberg/standby_creation_from_active_database_using_rman.html


    Best Regards

    mseberg

    Edited by: mseberg on Mar 12, 2013 6:29 AM
  • 2. Re: Setting up Data Guard
    MahirM.Quluzade Guru
    Currently Being Moderated
    Hi

    First check msberg valuable links, please.
    I am a newbie to data guard and was wondering what do I need to do to deploy it. So far I have an 11gR2 database up and running.
    As you know, data guard configurations contains with databases running as a primary role and one or more (30) standby role and with services.
    Then you a database running as primary role. You can check it, connect SQL*Plus and execute following query.
    select database_role from v$database;
     
    Q1. How do I create a standby database ( I have decided on a physical standby ) ?
    Data Guard Concepts and Administration 11g Release 2 (11.2) E10700-02 - See Chapter 3 "Creating a Physical Standby Database"
    and you find many blog posts about it.
    Q2. Do I have to deploy anything other than 11gR2 Oracle Home on my primary and standby servers ?
    What is means deploy, really I don't know. but I can say, you can create other databases on this servers, too.
    Q3. I see from some documentation that primary / standby databases can be managed using either sqlplus or dgmgrl - which would be the norm ?
    Standby database or Data Guard configurations can manage with SQL*Plus and Broker-managed data guard configurations managing with Data Guard Mana*g*e*r* Command Line Interface (DGMGRL).
    DGMGRL is very easy way for manage data guard configuration. See for more : http://docs.oracle.com/cd/E11882_01/server.112/e17023/toc.htm

    > Q4. Presently I only have my primary and proposed standby server - I have also read that it is better to deploy Data Guard Broker on a separate server from these
    > 2. If I only have 2 servers, is it therefore better just to manage Data Guard using sqlplus on each server ?
    Yes, you can create data guard configuration with a primary and standby database on a server or seperate servers.
    For simplicity you can first create broker-managed data guard, and you can create standby database with RMAN DUPLICATE command with FROM ACTIVE database option.
    Q5. What's the most appropriate document to follow when I am trying to deploy Data Guard for the first time
    http://docs.oracle.com/cd/E11882_01/server.112/e25608/toc.htm
    http://docs.oracle.com/cd/E11882_01/server.112/e17023/toc.htm


    Regards
    Mahir M. Quluzade
    http://www.mahir-quluzade.com
  • 3. Re: Setting up Data Guard
    Jimbo Explorer
    Currently Being Moderated
    Thanks, really good stuff.

    Can I clarify the difference between managing Data Guard using
    - Sqlplus
    - dgmgrl
    - Data Guard Broker

    I presume sqlplus and dgmgrl can both be used to manage primary & standby and that they are interchangable ( i.e. you can use a mix and match approach in regards to using them )

    Is dgmgrl just an alternative command line interface but is separate from Data Guard Broker ?

    Is the Observer another component of Data Guard Broker or effectively the same thing ?

    thanks,
    Jim
  • 4. Re: Setting up Data Guard
    mseberg Guru
    Currently Being Moderated
    Thanks
    I presume sqlplus and dgmgrl can both be used to manage primary & standby and that they are interchangable ( i.e. you can use a mix and match approach in regards to using them )
    No. You cannot mix these. If you do the config for broker will not match the database config and you will have issues.

    Is dgmgrl just an alternative command line interface but is separate from Data Guard Broker ?
    Not separate. dgmgrl is the command line interface fro broker.

    Is the Observer another component of Data Guard Broker or effectively the same thing ?
    Another component for Fast start failover.


    Will add my broker setup notes link here as an edit in a moment. ( new page still doing some cleanup, readable )

    http://www.visi.com/~mseberg/data_guard/broker_setup_example.html


    Best Regards


    mseberg

    Edited by: mseberg on Mar 12, 2013 8:54 AM
  • 5. Re: Setting up Data Guard
    CKPT Guru
    Currently Being Moderated
    Jimbo wrote:
    Thanks, really good stuff.

    Can I clarify the difference between managing Data Guard using
    - Sqlplus
    - dgmgrl
    - Data Guard Broker

    I presume sqlplus and dgmgrl can both be used to manage primary & standby and that they are interchangable ( i.e. you can use a mix and match approach in regards to using them )
    No, When Data Guard enabled with Broker, then if any changes you must do only using DGMGRL.
    Is dgmgrl just an alternative command line interface but is separate from Data Guard Broker ?
    DGMGRL is an utility to manage Broker
    Is the Observer another component of Data Guard Broker or effectively the same thing ?
    Observer can be started in either primary or standby but strongly recommended to configure in system other than primary and standby, according to the fast start threshold value it can perform failover of standby if in case there is no access to primary database.
  • 6. Re: Setting up Data Guard
    Jimbo Explorer
    Currently Being Moderated
    So if you use dgmgrl does that mean you are automatically using / enabled Data Guard Broker ?

    Can you be using dgmgrl without being enabled for Data Broker ?

    How do you enable Data Guard Broker ?

    When mentioning Observer I was trying to establish if this is another name for Data Guard Broker or a specific component of it ?
  • 7. Re: Setting up Data Guard
    mseberg Guru
    Currently Being Moderated
    Hello;

    Broker setup :


    http://www.visi.com/~mseberg/data_guard/broker_setup_example.html


    Observer is a specific component. Observer generally sits on a third server or even a workstation at a third location and monitors the other two servers for issues.

    Would setup without Broker on test and do a switchover, check sync, test listener etc and then move to Broker. That way you get a good feel for the Environment and how it works without adding the Broker learning curve to everything.

    Best Regards

    mseberg

    Edited by: mseberg on Mar 12, 2013 11:20 AM
  • 8. Re: Setting up Data Guard
    CKPT Guru
    Currently Being Moderated
    So if you use dgmgrl does that mean you are automatically using / enabled Data Guard Broker ?
    Can you be using dgmgrl without being enabled for Data Broker ?
    DGMGRL is binary, it will be accessible even you configure the broker or not. But you cannot access configuration of broker if you haven't enabled.
    How do you enable Data Guard Broker ?
    MSeberg already provided link
    When mentioning Observer I was trying to establish if this is another name for Data Guard Broker or a specific component of it ?
    this is another process to monitor all the databases availability of data guard configuration and functions faliover based on the configuraiton.
    you can check http://docs.oracle.com/cd/B28359_01/server.111/b28295/sofo.htm#CHDDFFEC
  • 9. Re: Setting up Data Guard
    Jimbo Explorer
    Currently Being Moderated
    ok starting to make a bit of sense.

    Q1. So Data Guard is part of the Enterprise ORACLE_HOME stack and can be configured so that there is a primary and standby database. ?
    It is not a separate installable product ?

    Q2. Is it located in the $ORACLE_HOME of the primary or standby or both ?

    Q3. $ORACLE_HOME/bin/dgmgrl is one of the API's for Data Guard and also for Data Guard Broker ( if it is configured ) ?

    Q4. The other API's for Data Guard are sqlplus and Enterpise Manager / Grid Control ?

    Q5. If you have configured Data Guard Broker then you need to use dgmgrl instead of sqlplus to manage data guard ?

    Q6. Is Data Guard Broker a separate installable product or again is it simple an alternative management component for Data Guard if you configure it ?

    Q7. Where is Data Guard Broker normally located ( on separate server from the primary and standby ) ?

    Q8. Observer is a separate installable component for Data Guard Broker to use ?

    Q9. Observer should be installed on a separate server from primary and standby but where does it reside in relation to Data Guard Broker ?

    thanks,
    Jim
  • 10. Re: Setting up Data Guard
    mseberg Guru
    Currently Being Moderated
    Hello;
    Q1. So Data Guard is part of the Enterprise ORACLE_HOME stack and can be configured so that there is a primary and standby database. ?
    It is not a separate installable product ?
    Correct.
    Q2. Is it located in the $ORACLE_HOME of the primary or standby or both ?
    Data Guard is included as of a EE software ( oracle database ) install. So that needs to be on both servers.
    Q3. $ORACLE_HOME/bin/dgmgrl is one of the API's for Data Guard and also for Data Guard Broker ( if it is configured ) ?
    Kind of. Think of it as an executable that's part of an Oracle install. Like RMAN. or SQL Loader etc.

    Q4. The other API's for Data Guard are sqlplus and Enterpise Manager / Grid Control ?
    If I understand the question correctly then yes. Whenever I hear API I think in terms of programming.
    Q5. If you have configured Data Guard Broker then you need to use dgmgrl instead of sqlplus to manage data guard ?
    Yes! Otherwise the INIT file will conflict with the Broker parameters.

    Q6. Is Data Guard Broker a separate installable product or again is it simple an alternative management component for Data Guard if you configure it ?
    Its part of EE. Just configure it.
    Q7. Where is Data Guard Broker normally located ( on separate server from the primary and standby ) ?
    Broker is part of the software home so on both Primary and Standby servers.
    Q8. Observer is a separate installable component for Data Guard Broker to use ?
    Yes. And an Option. Completely Optional.
    Q9. Observer should be installed on a separate server from primary and standby but where does it reside in relation to Data Guard Broker ?
    Think of it as separate software.


    If this is a test I hope I did OK!

    By the way CKPT and I are good friends but we live almost exactly 12 hours apart. So I never know when he might reply or he know when I might. If I could pick anybody to work with in IT CKPT would be at the very top of my list.

    If it helps I have setup test Data Guard systems on VMware using Red Hat 5 AS and Oracle 11R2 ( 11.2.0.3.0 ) and as little as 1.2GB of RAM each. Its a great way to dive into the deep end of the pool.

    There's a ton of information here too:

    http://www.oracle-ckpt.com/
    http://uhesse.com/
    http://www.emrebaransel.blogspot.com/


    Best Regards

    mseberg
  • 11. Re: Setting up Data Guard
    Jimbo Explorer
    Currently Being Moderated
    Thanks for sharing your experiences

    Yes you definitely pass the test !

    It's nice to hear from those with real experience

    Both you and ckpt seem to be playing at the top of your game !

    thanks again,
    Jim

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points