![\"\"](\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/image22.png?ssl=1\")
<\/a>After a few failed attempts, I was successful in creating a Data Guard DBaaS Instance. Since I was playing with a trial account, the resources were limited. I guess when I had another database running, there is not much storage left to create two instances in Data Guard configuration. Anyway, that is my guess.<\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n If you choose the software edition as Enterprise Edition, you will get the bottom portion to configure standby database. Click the check box to enable Data Guard configuration.<\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n Once you click on the Create Service in the summary screen, it takes about 50 minutes to create Data Guard instance, which includes<\/p>\n Click on the DBaaS instance to view details. The screenshot below shows the two nodes and their status.<\/p>\n Note, -dg01 is my primary database node and -dg02 is my standby database node.<\/p>\n The menu beside the node names as well as on the top includes three additional items related to Data Guard.<\/p>\n Use the public IP address to log into each Linux node. I see the two nodes pretty identical.<\/p>\n Connect to the primary database (the\u00a0result\u00a0is same from standby as well) and query V$DATAGUARD_CONFIG.<\/p>\n The tnsnames.ora is identical on both nodes, with pretty exhaustive configuration entries. The CDB, as well as PDB have FAILOVER configuration.<\/p>\n There are eight services running on both nodes. The naming is pretty self-explanatory.<\/p>\n And there are eight tnsnames.ora entries as well. I have only one PDB, if there are more PDBs, I guess more services and more TNSNAMES.ORA entries would be created.<\/p>\n The log transport configuration on primary database is:<\/p>\n The dbaascli <\/a>utility has options to manage the Data Guard database roles. Before I start using dbaascli<\/a>, applying the best practice I learned and updating the cloud toolset to the\u00a0latest version on both nodes.<\/p>\n $\u00a0dbaascli dbpatchm –run -toolsinst -rpmversion=16.4.5.1_161213.1526<\/p>\n $ dbaascli dataguard status<\/p>\n $\u00a0dbaascli dataguard status –details yes<\/p>\n Enough of exploring the configurations. Let’s do some real Data Guard operations. First, I am going to use the Cloud Database Service Console to do a switchover – the current primary (-dg01) will become standby, and the current standby (-dg02) will become primary.<\/p>\n Just for the sake of completeness, I am going to create a table under user Bill. After the switchover will validate the table on the new primary database for existence.<\/p>\n Click on the Cloud Service menu and choose “Switchover”.<\/p>\n Voila, the role is reversed. No intervention! Took about 5 minutes.<\/p>\n And the table still exist.<\/p>\n SQL also shows the database role is reversed.<\/p>\n I am assuming the Cloud Service is using the dbaascli tool for switchover, failver, reinstate operations. Let me use dbaascli to perform a manual failover.<\/p>\n $ dbaascli dataguard status<\/p>\n $\u00a0dbaascli dataguard failover<\/p>\n The current primary database is now shutdown (abort), and the standby database is made primary. No active standby database.<\/p>\n $\u00a0dbaascli dataguard status<\/p>\n The ORA-16661 message is a good indication that the physical standby database can be reinstated. Let’s try using dbaascli.<\/p>\n $ dbaascli dataguard reinstate<\/p>\n $ dbaascli dataguard status<\/p>\n Well, forgot to mention that the standby database we have is in fact “Active Data Guard (Real-time Query)”.<\/p>\n Check the OPEN_MODE in V$DATABASE as well as try to query the database.<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" 12 Days of #Cloud: Day 11 After a few failed attempts, I was successful in creating a Data Guard DBaaS Instance. Since I was playing with a trial account, the resources were limited. I guess when I had another database running, there is not much storage left to create two instances in Data Guard configuration. … Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[55],"class_list":["post-1992","post","type-post","status-publish","format-standard","hentry","category-cloud-autonomous","tag-oracle-cloud"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=1992"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1992\/revisions"}],"predecessor-version":[{"id":2985,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1992\/revisions\/2985"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Creating a Data Guard DBaaS service is pretty similar to creating a standard DBaaS instance<\/a>. Choose “Create Instance” from the Oracle Database Cloud Service. Notice that I chose “Enterprise Edition – Extreme Performance” as the software edition. You can create a Data Guard configuration using any Enterprise Edition option, but only Extreme Performance gives you the “Active Data Guard”. \u00a0Though an Oracle Data Guard configuration can contain one primary database and up to thirty standby destinations, the Oracle Data Guard configuration in Database Cloud Service includes one primary database and one standby database.\u00a0Oracle Active Data Guard (also known as real-time query) provides read-only access to the physical standby database while it is synchronized with the primary database.<\/p>\n<\/p>\n\n
<\/p>\n<\/p>\n<\/p>\n\n
<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n