dataguard configuration role

[patriziobassi]

Any plan to add a dataguard configuration between 2 instances?

[oravirt]

Yes, if time permits ;-)

[Rendanic]

I need such a role in the next months for a project. The implementation is not as easy for a whole automatic setup of dataguard.
I have to finish oradb-opatch and oradb-rman before I can start with oradb-dataguard...

[ArunkumarPanneerselvam]

Have you guys done some development in daraguard.

[ArunkumarPanneerselvam]

I m interested in doing it please let me know if done already

[Rendanic]

Hopefully I find time for it in october or november.
The following needs to be completed before:

• listener.ora for new home-structure
  This is mandatory for the static configuration of the instances for datagurad. Hopefully we find someone who is interested in doing the tests for Grid-Infrastructure, because the confiugration is done with a template file due to the restrictions in the responsefile of netca...
• tnsnames.ora
  We need a configuration for the new home structure to create dedicated entries. Some of them are needed for dataguard and sometimes we need them for database links. This opens the ability to synchronize tnsnames.ora definitions in dataguard and normal environments as well.
• rmanbackup.sh
  That script needs some tweaks for duplicate database to connect to the auxiliary. Maybe we can skipt this point at the beginning, because the autmatic duplication of a standby database is not a high priority for me.
• dataguard
  yeah, we can start with the dataguard role. :-)

[oravirt]

I have started looking into the tnsnames/listener.ora things.
Don’t have enough time at the moment though, hopefully it will ease up in a couple of weeks

[Rendanic]

I am testing listener.ora and tnsnames.ora on my side.
There is a good chance for the pull request for these parts at this weekend.

2 major parts for data-guard are done-

[Rendanic]

The configuration for tnsnames.ora and listener.ora in non Oracle Restart & Grid-Infrastructure is in PR #101

[Rendanic]

I have some issues with DBCA when dg_broker_start and log_archive_config is set inside the init_parameters of oracle_databases.
This problem has been solved with #115

[Rendanic]

Autostart of databases in filesystem has been enhanced for Data-Guard.
PR #137

[g10chy]

Any more progress with this issue?

[tanshaolong]

Have we had the data-guard role? Thanks

[tanshaolong]

@Rendanic @oravirt,
See the above your comunication, I want that you had finished more important works for data-guard.
Currently, I have requirement to install an oracle data-guard env. Could you give some cue what I need to do for the rest works? Thanks you very much.

[Rendanic]

Hi @tanshaolong ,
just do the following:

• configure inventory for Primary- and Standby-Server
• don't forget the tns-alias for SID-Connection
• don't forget to configure a dedicated listener
  You can only configure 1 Listener for a database. That Listener could be run on port 1521, but you hacve to configure the Listener to get the static entries in listener.ora.
  An example for listener and tnsnames is here:
  https://github.com/Rendanic/ansible-oracle-config/blob/master/inventory/dbfs122/group_vars/dg1/db-homes.yml
  I use that configuration for my Vagrant playground.
• create databases on both sides
  Don't forget to use different values for db_unique_name.
• Test the tnsname.ora aliases for rman duplicate
  Don't forget to use an alias that points to the static listener definiton.
• Remove Control-, Redo- and Datafiles on Standby
• RMAN Duplicate for standby from active database
• Configure Broker
  The Broker configuration is simple with a successful duplicaten from active database

That's it for a Data-Guard environment. It looks more work then it is, because most of the failures are done in listenerora and tnsnames.ora and that's easy to deploy with ansible-oracle.

[tanshaolong]

Thanks Rendanic for your detail reply :). I will try as quickly as possible.

[tanshaolong]

Hi @Rendanic

I have tried to install the oracle DG by your suggestion. Unfortunate, I get the both Oracle SI databases instead of a DG env. I think I should misunderstand your mean. Could you give me more details?

Some questions are in below:
1.How to configure inventory for primary- and standby-Server? I reference your sample. There have both host groups “db” and “dg1”. I think that the “db” is for primary db and “dg1” is for standby db. Is right? If so, why are the both group varlues same at your sample? If not, I should be how to configure.
2.“Remove Control-, Redo- and Datafiles on Standby”, what does it mean? Are they some initParameters for databases?
3.How to configure the broker?

Could you please give me an sample for Oracle DG installation? I don’t have too much exprerience for the installation manual. The sample will help me understand the reference that you mention at above. Thanks you.

[tanshaolong]

Check oracle_services.create_service library code. I guess we can set primary and standby server by below configuration for host_vars.

# primary
services:
- { name: service2,  state: started, role: primary }

# standby
services:
    - { name: service2,  state: started, role: physical_standby }

Is it right? Thanks you.