dataguard configuration role

patriziobassi commented 6 years ago

Any plan to add a dataguard configuration between 2 instances?

oravirt commented 6 years ago

Yes, if time permits ;-)

Rendanic commented 6 years ago

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 commented 6 years ago

Have you guys done some development in daraguard.

ArunkumarPanneerselvam commented 6 years ago

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

Rendanic commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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

Rendanic commented 6 years ago

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 commented 5 years ago

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

g10chy commented 5 years ago

Any more progress with this issue?

tanshaolong commented 5 years ago

Have we had the data-guard role? Thanks

tanshaolong commented 5 years ago

@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 commented 5 years ago

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 commented 5 years ago

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

tanshaolong commented 5 years ago

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 commented 5 years ago

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.

oravirt / ansible-oracle

dataguard configuration role #65