{"id":395,"date":"2019-06-30T23:01:00","date_gmt":"2019-07-01T03:01:00","guid":{"rendered":""},"modified":"2024-07-05T18:41:54","modified_gmt":"2024-07-05T22:41:54","slug":"maa-setup-creating-single-instance","status":"publish","type":"post","link":"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance","title":{"rendered":"MAA setup\u2013 Creating Single instance Physical Standby for RAC Primary &#8211; 12c"},"content":{"rendered":"<h2><strong>Introduction<\/strong>:<\/h2>\n<p><span style=\"font-size: 14px; white-space: pre-wrap;\">Oracle provides many options for preventing downtime and data loss, all of which make up the Maximum Availability Architecture (MAA). The Oracle Maximum Availability Architecture offers a set of standard reference architectures&#8211;Bronze, Silver, Gold, and Platinum Solutions&#8211; that comply with Customer Business Objectives. With multiple instances, the RAC system gives a transparent HA and scalability environment, while Data guard delivers a real-time data protection with near zero to zero data loss. One of the (MAA) principles we are going to explore in this lab is the combination of both Oracle RAC and Active Data Guard.&nbsp; This guide will take you through the steps to configure a Data Guard &#8211;single instance&#8211; physical standby Database for a RAC Primary Database. Data Broker configuration and administration tasks (swicthover,validate..) will also be covered in this paper .<\/span><\/p>\n<h2>Premise :<\/h2>\n<p><span style=\"font-size: 14px; white-space: pre-wrap;\">This document assumes the following conditions :<\/span><\/p>\n<ul><span style=\"font-size: 14px; white-space: pre-wrap;\"><\/p>\n<li>Existing RAC Primary database with two instances (RACDB_1, RACDB_2) utilizing ASM for data file storage. <\/li>\n<li>Primary RAC cluster based on my previous <em>VirtualBox<\/em> RACattack lab on Redhat 7&nbsp; -&gt; see post <a href=\"https:\/\/koussilicious.blogspot.com\/2017\/07\/deploying-oracle-rac-database-12c-lab_27.html\">Deploying Oracle RAC Database 12c Lab on Red Enterprise Linux 7<\/a>.&nbsp; (Copies of the vms are available upon request).&nbsp; <\/li>\n<li> Grid and Oracle Restart won\u2019t be available on the standby site since it\u2019s a non ASM standby database setup <\/li>\n<li>Oracle software on the standby host have already been installed\/created.<\/li>\n<li>Throughout this document, the below naming conventions (database name, database unique name, Oracle net services, instances and the hostnames ) have been used .&nbsp; <\/li>\n<p><\/span><\/ul>\n<p><span style=\"font-size: 14px; white-space: pre-wrap;\"><\/p>\n<p><strong>What will be covered ?<\/strong><br \/>\n  In this post we will focus on the following content:<\/p>\n<p><\/span><span style=\"font-size: 14px; white-space: pre-wrap;\"><\/p>\n<ul>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html\"><strong>I. OVERVIEW<\/strong><\/a>\n<ul>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html#Topology\">a. Topology<\/a>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html#Environment\">b. Environment<\/a><\/li>\n<\/ul>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html#II\"><strong>II. PREPARATION<\/strong><\/a>\n<ul>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html#Primarysite\">a. Primary site<\/a>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html#Standbysite\">b. Standby site<\/a><\/li>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html#RMANduplicate\">c. RMAN duplicate<\/a><\/li>\n<\/ul>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html#III\"><strong>III. DATA GUARD BROKER CONFIGURATION<\/strong><\/a>\n<ul>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html#PrimaryHost\">a. Primary Host<\/a>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html#StandbyHost\">b. Standby Host<\/a><\/li>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html#CreateBrokerconfiguration\">c. Create Broker configuration<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html#IV\"><strong>IV. DATA GUARD ADMINISTRATION USING ORACLE BROKER<br \/>\n<\/strong><\/a><\/li>\n<ul>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html#SwitchovertoParis\">a. Switchover to Paris <\/a>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html#VerifyandChangetheApplyinstance\">b. Verify and Change the Apply instance<br \/>\n<\/a><\/li>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html#Switchback_to_former_primary\">c. Switch back to former primary RAC_DB<\/a><\/li>\n<li><a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html#Common_Mistakes\">d. Common Mistakes<\/a><\/li>\n<p><!--EndFragment--><\/ul>\n<h3>\n<\/h3>\n<\/ul>\n<h2><a href=\"https:\/\/www.blogger.com\/null\"><a href=\"https:\/\/www.blogger.com\/null\"><a href=\"https:\/\/www.blogger.com\/null\">I. OVERVIEW<\/a><\/h2>\n<ul>\n<h3 id=\"Topology\"><strong>a. Topology<\/p>\n<p><a style=\"margin-right: 1em; margin-left: 1em;\" href=\"https:\/\/cloudthrill.ca\/wp-content\/uploads\/2019\/07\/MAA_Reference_Architectures.png\" imageanchor=\"1\"><img loading=\"lazy\" decoding=\"async\" width=\"657\" height=\"357\" src=\"https:\/\/cloudthrill.ca\/wp-content\/uploads\/2019\/07\/MAA_Reference_Architectures.png\" class=\"wp-image-396\"><\/a><\/strong><\/h3>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fig 1- Gold MAA reference architecture <\/ul>\n<ul>The Gold MAA reference architure is ideal for service level requirement that can\u2019t tolerate site failures. It is based on the clustered architecture pattern for the silver reference architecture With Oracle RAC , and adds a remote synchronized copy of the production database using Oracle Data Guard. This provide a combination of the transparent high availability and scalability of Oracle RAC with real-time data protection and availability or Oracle Data Guard.<\/p>\n<h3 id=\"Environment\"><strong>b. Environment<\/strong><\/h3>\n<p>&nbsp;<br \/>\nYou need 2 RAC nodes (4G min memory) and a third virtual machine for the physical standby host.<\/p>\n<table width=\"658\" class=\"MsoNormalTable\" style=\"width: 592pt; margin-left: -1.15pt; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes;\">\n<td width=\"100\" valign=\"top\" style=\"padding: 0in 5.4pt; border: 1pt solid windowtext; border-image: none; width: 168.75pt; height: 15.75pt;\">&nbsp;&nbsp; <\/td>\n<td width=\"100\" valign=\"top\" style=\"background: rgb(198, 217, 241); border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext currentcolor; padding: 0in 5.4pt; border-image: none; width: 217.25pt; height: 15.75pt; mso-background-themecolor: text2; mso-background-themetint: 51;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <strong><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;;\">PRIMARY<br \/>\n<\/span><\/strong><\/td>\n<td width=\"100\" valign=\"top\" style=\"background: rgb(198, 217, 241); border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext currentcolor; padding: 0in 5.4pt; border-image: none; width: 263pt; height: 15.75pt; mso-background-themecolor: text2; mso-background-themetint: 51;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;;\"><strong>STANDBY<br \/>\n<\/strong><\/span><\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 1;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span class=\"SpellE\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><em><strong>Clusterware<\/strong><\/em><br \/>\n<\/span><\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">12c R1 Grid Infrastructure (12.1.0.2)&nbsp; <\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p align=\"center\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N\/A<br \/>\n<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 2;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em>Domain name<\/em><\/strong><br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p align=\"center\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">evilcorp.com<br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><\/p>\n<p align=\"center\">evilcorp.com\n<\/p>\n<p><\/span><\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 2;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><em><strong>Cluster Nodes\/Host<\/strong><\/em><br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p align=\"center\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">london1evilcorp.com<br \/>\nlondon2.evilcorp.com<br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p align=\"center\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">paris.evilcorp.com<br \/>\n<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 2;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em>IP adresses<\/em><\/strong><br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">london1 : 192.168.78.51 (DNS master)london2 : 192.168.78.52 (DNS slave)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p align=\"center\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; paris: 192.168.78.53&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\n<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 3;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><em><strong>SCAN<\/strong><\/em><br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">london-cluster-scan.evilcorp.com<br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p align=\"center\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">N\/A<br \/>\n<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 4;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><br \/>\n<strong><em>SCAN listener Host\/port<\/em><\/strong><o:p><\/o:p><\/span>\n  <\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">&nbsp;<br \/>\n<span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">SCAN VIPs : 192.168.78.251\/252\/253<br \/>\n (port 1525)<\/span><\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p align=\"center\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">N\/A<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 5;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em>VIPs<\/em><\/strong><br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p align=\"center\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">london1-vip: 192.168.78.61<br \/>\nlondon2-vip: 192.168.78.62<br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p align=\"center\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">N\/A<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 6;\">\n<td width=\"100\" valign=\"top\" style=\"background: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt; mso-background-themecolor: background1;\"><\/td>\n<td width=\"100\" valign=\"top\" style=\"background: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt; mso-background-themecolor: background1;\"><\/td>\n<td width=\"100\" valign=\"top\" style=\"background: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt; mso-background-themecolor: background1;\"><\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 7;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em>DB_UNIQUE_NAME<\/em><\/strong><o:p><\/o:p><\/span>\n  <\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">RAC_DB<\/span>\n  <\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">PARIS<\/span>\n  <\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 8;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em>DB_NAME<\/em><\/strong><br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RAC_DB<br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">RAC_DB<\/span>\n<\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 9;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em>DB Instances<\/em><\/strong><br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RACDB_1, RACDB_2<br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PARIS<br \/>\n<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 10;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em>DB LISTENER<\/em><\/strong><br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LISTENER<br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LISTENER<br \/>\n<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 11;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em>DB Listener Host\/port<\/em><\/strong><br \/>\n&nbsp; <\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp; london1-vip, london2-vip (port 1521)<br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">paris (port 1521)<br \/>\n<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 12;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><em><strong>DB STORAGE<\/strong><\/em><br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ASM<br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FileSystem<br \/>\n<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 13;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em>File Management<\/em><\/strong><o:p><\/o:p><\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OMF<br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hybrid (OMF\/Manual)&nbsp; <\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 14;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em><span class=\"SpellE\">Location<\/span> for DB files<\/em><\/strong><o:p><\/o:p><\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +DATA<br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \/u01\/oradata\/paris\/data<\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 15;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em> Fast Recovery Area<\/em><\/strong><br \/>\n<\/span><\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +<span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">FRA<br \/>\n<\/span><\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \/u01\/oradata\/paris\/FRA<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 16;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em>ORACLE_HOME<\/em><\/strong><br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">\/u01\/app\/oracle\/product\/12.1.0.2\/db_1<br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \/u01\/app\/oracle\/product\/12.1.0.2\/db_1<br \/>\n<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 17;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em>Oracle DB software version<\/em><\/strong><br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.1.0.2<br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.1.0.2<br \/>\n<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 18;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em>OS<\/em><\/strong><br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Red Hat Enterprise Linux 7.1 (64 bit)<br \/>\n<\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Red Hat Enterprise Linux 7.1 (64 bit)&nbsp; <\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 19; mso-yfti-lastrow: yes;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em>GRID_HOME<\/em><\/strong><\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p align=\"center\">&nbsp;&nbsp;&nbsp;&nbsp; \/u01\/app\/grid\/product\/12.1.0.2\/grid<\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><br \/>\n&nbsp; <\/span><\/td>\n<\/tr>\n<tr style=\"height: 15.75pt; mso-yfti-irow: 19; mso-yfti-lastrow: yes;\">\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor windowtext windowtext; padding: 0in 5.4pt; border-image: none; width: 168.75pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><strong><em>Pluggable database<\/em><\/strong><\/span><\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 217.25pt; height: 15.75pt;\">\n<p align=\"center\">&nbsp;&nbsp;&nbsp; PDB<\/p>\n<\/td>\n<td width=\"100\" valign=\"top\" style=\"border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor windowtext windowtext currentcolor; padding: 0in 5.4pt; width: 263pt; height: 15.75pt;\">\n<p><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\"><span style=\"color: rgb(0, 32, 96); font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-bidi-font-weight: bold;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PDB<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/ul>\n<ul>1) Standby Host preparation :<\/ul>\n<ul>I will keep this to the minimum and spare you the borring\/redundant Oracle installation print screens. For all OS\/Oracle related preparation (sysctl.conf\/shell limits\/swap\/rpms\/users..) please refere to my previous post <a href=\"https:\/\/koussilicious.blogspot.com\/2017\/07\/deploying-oracle-rac-database-12c-lab_27.html\">Deploying Oracle RAC Database 12c Lab on Red Enterprise Linux 7<\/a>. (vm copies are available upon request).&nbsp; <\/ul>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211; Network Interface <\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">[root@localhost ~]#<strong> nmcli<\/strong> dev show eth0\nGENERAL.DEVICE:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; eth0\n...\nIP4.ADDRESS[1]:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 192.168.78.53\/24\nIP4.DNS[1]:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 192.168.78.51     <font color=\"#0000ff\">---- Master DNS Zone<\/font>\nIP4.DNS[2]:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 192.168.78.52     <font color=\"#0000ff\">---- SLave  DNS Zone\n...<\/font>\n<\/pre>\n<\/blockquote>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211; Hostname :<\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">[root@localhost]# <strong>hostnamectl<\/strong> set-hostname paris.evilcorp.com \n\n[root@localhost ~]# <strong>hostnamectl<\/strong> status\n&nbsp;&nbsp; Static hostname: <font color=\"#0000ff\">paris.evilcorp.com<\/font>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Icon name: computer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Chassis: n\/a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \nVirtualization: kvm\nOperating System: Red Hat Enterprise Linux Server 7.1 (Maipo)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \nCPE OS Name: cpe:\/o:redhat:enterprise_linux:7.1:GA:server&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \nKernel: Linux 3.10.0-229.el7.x86_64&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Architecture: x86_64<\/pre>\n<\/blockquote>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;&nbsp; Standby DNS configuration&nbsp; : add the following line on the DNS server london1 as root:\n<\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">A- At the bottom of the Forward Zone file :\n \n[root@london1 ~]# <strong>vi<\/strong> \/var\/named\/evilcorp.com&nbsp;&nbsp; \n  <font color=\"#0000ff\">paris&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp; 192.168.78.53<\/font>&nbsp; \n\nB- At the bottom of the Backward Zone file:\n\n[root@london1 ~]# <strong>vi<\/strong>&nbsp; \/var\/named\/evilcorp.com.re&nbsp; \n<font color=\"#0000ff\">53.78.168.192&nbsp; PTR paris.evilcorp.com.<\/font>\n\n\n<\/pre>\n<p>Check the the resolution:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n<\/p>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">[root@paris ~]# <strong>nslookup<\/strong> london1 \n Name:&nbsp;&nbsp; london1.evilcorp.com\n Address: 192.168.78.<strong>51<\/strong>\n[root@paris ~]# <strong>nslookup<\/strong> london2 \n Name:&nbsp;&nbsp; london2.evilcorp.com\n Address: 192.168.78.<strong>52<\/strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \n[root@paris ~]# <strong>nslookup<\/strong> london-cluster-scan.evilcorp.com \n Name:&nbsp;&nbsp; london-cluster-scan.evilcorp.com\n Address: 192.168.78.<strong>253<\/strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \n Address: 192.168.78.<strong>252<\/strong> \n Address: 192.168.78.<strong>251<\/strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/pre>\n<\/blockquote>\n<h2 id=\"II\"><a href=\"https:\/\/www.blogger.com\/null\"><a href=\"https:\/\/www.blogger.com\/null\"><a href=\"https:\/\/www.blogger.com\/null\">II. PREPARATION<\/a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html\"><font size=\"4\">Go to Top<\/font><\/a><\/h2>\n<ul>\n<h3 id=\"Primarysite\">a. Primary site preparation<\/h3>\n<\/ul>\n<p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1. Enable Force Logging.&nbsp;&nbsp; <\/strong><\/p>\n<blockquote>\n<p>&nbsp; &#8211; Run the below on one of the RAC_DB instances to ensure all changes generate redo .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n<\/p>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">SYS@RACDB_1&gt; alter database force logging;&nbsp; <\/pre>\n<\/blockquote>\n<p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2. Enable Archivelog Mode<\/strong>.\n<\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">[root@london1]# <strong>srvctl<\/strong> stop instance&nbsp; -db RAC_DB \u2013i RACDB_2\n[root@london1]# <strong>srvctl<\/strong> stop instance&nbsp; -db RAC_DB -i RACDB_1\n[root@london1]# <strong>srvctl<\/strong> start instance -db RAC_DB -i RACDB_1 -node london1 <strong>-startoption<\/strong> mount&nbsp;&nbsp; \n[root@london1]#  sqlplus sys\/racattack@RAC_DB as sysdba\nsys@RACDB_1&gt; alter database archivelog;&nbsp;&nbsp; \nexit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \nsys@RACDB_1&gt; alter database open;\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/pre>\n<\/blockquote>\n<p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3. Create the SLRs (Standby Redo Logs).<\/strong>.<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211; Create the standby log files on the primary DB so the RMAN duplicate process&nbsp; will automatically create them on the<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; standby site. <u>nbr standby redo logs groups<\/u> =&nbsp; [<font style=\"background-color: rgb(255, 255, 0);\">nbr primary redo log files (2 ) + 1] x 2Nodes<\/font> =6\n<\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">sys@RACDB_1&gt; ALTER DATABASE ADD STANDBY LOGFILE <strong>THREAD 1<\/strong> size 50m ; -- x3 Times \nsys@RACDB_1&gt; ALTER DATABASE ADD STANDBY LOGFILE <strong>THREAD 2<\/strong> size 50m ; -- x3 Times\nsys@RACDB_1&gt; SELECT THREAD#,GROUP#, BYTES\/1024\/1024 MB,STATUS from V$STANDBY_LOG;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \nTHREAD#&nbsp; GROUP#&nbsp; MB   STATUS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \n--------- ------ ---- ----------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \n1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50  UNASSIGNED\n1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50  UNASSIGNED&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \n1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50  UNASSIGNED&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \n2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50  UNASSIGNED&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \n2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50  UNASSIGNED&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \n2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50  UNASSIGNED&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/pre>\n<\/blockquote>\n<p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4. Modify Data Guard related init Parameters.<br \/>\n<\/strong><\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">@RACDB_1&gt; ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(<font color=\"#0000ff\">rac_db,paris<\/font>)' scope=both;\n\n-- Destinations\nALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(<font color=\"#0000ff\">RAC_DB,PARIS<\/font>)' scope=both;\nALTER SYSTEM set LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=<font color=\"#0000ff\">RAC_DB<\/font>' scope=both; \n\nALTER SYSTEM set LOG_ARCHIVE_DEST_2='SERVICE=<font color=\"#0000ff\">paris<\/font> ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=<font color=\"#0000ff\">PARIS<\/font>' scope=both;\n\nALTER SYSTEM SET DB_FILE_NAME_CONVERT='+DATA\/RAC_DB\/DATAFILE',\n'\/u01\/oradata\/paris\/<font color=\"#0000ff\">data<\/font>' scope=spfile;\n\nALTER SYSTEM SET LOG_FILE_NAME_CONVERT='+FRA\/RAC_DB\/ONLINELOG',\n'\/u01\/oradata\/paris\/<font color=\"#0000ff\">FRA<\/font>', '+REDO\/RAC_DB\/ONLINELOG','\/u01\/oradata\/paris\/<font color=\"#0000ff\">redo<\/font>' scope=spfile;\n\nALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE scope=spfile;\nALTER SYSTEM SET FAL_SERVER=<font color=\"#0000ff\">paris<\/font>&nbsp; SCOPE=SPFILE;\nALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO SCOPE=SPFILE;<\/pre>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">-- Verify the new values \n@RACDB_1&gt; SELECT NAME, VALUE FROM <strong>V$SPPARAMETER<\/strong> WHERE UPPER(NAME) IN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ('REMOTE_LOGIN_PASSWORDFILE','STANDBY_FILE_MANAGEMENT','LOG_ARCHIVE_DEST_1','LOG_ARCHIVE_DEST_2','DB_FILE_NAME_CONVERT','LOG_FILE_NAME_CONVERT','FAL_SERVER');\n\nNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUE\n------------------------------ -------------------------------------------------\ndb_file_name_convert&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +DATA\/RAC_DB\/DATAFILE\ndb_file_name_convert&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \/u01\/oradata\/paris\/data\nlog_file_name_convert&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +FRA\/RAC_DB\/ONLINELOG\nlog_file_name_convert&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \/u01\/oradata\/paris\/FRA\nlog_file_name_convert&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +REDO\/RAC_DB\/ONLINELOG\nlog_file_name_convert&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \/u01\/oradata\/paris\/redo\n\nlog_archive_dest_1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR= \n                               (ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=RAC_DB\n\nlog_archive_dest_2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SERVICE=paris ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PARIS\nfal_server&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PARIS\nstandby_file_management&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AUTO\nremote_login_passwordfile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXCLUSIVE<\/pre>\n<\/blockquote>\n<p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5. Backup the Database for Standby<\/strong><\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">[oracle@london1]# rman target=\/ \n\nRMAN&gt;BACKUP DATABASE PLUS&nbsp; ARCHIVELOG;&nbsp;&nbsp; \n\n<\/pre>\n<ul>\n<li><u><font color=\"#d16349\" face=\"Tahoma\" style=\"background-color: rgb(255, 255, 255);\">POSSIBLE ERROR:<\/font><\/u><br \/>\n<font color=\"#c0504d\" style=\"background-color: rgb(255, 255, 255);\">ORA-19809: limit exceeded for recovery files<\/font><br \/>\n<font color=\"#c0504d\">The limit for recovery files specified by the DB_RECOVERY_FILE_DEST_SIZE was exceeded.<br \/>\n<u><font color=\"#d16349\" face=\"Tahoma\" style=\"background-color: rgb(255, 255, 255);\">Fix:<\/font><\/u><\/font>&nbsp;<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1)-&nbsp; Increase DB_RECOVERY_FILE_DEST_SIZE.<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQL&gt; ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=8G SCOPE=BOTH;<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2) &#8211; Delete files from recovery area using RMAN<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RMAN&gt; delete force noprompt archivelog all completed before &#8216;sysdate-1&#8217;;\n<\/li>\n<\/ul>\n<\/blockquote>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <strong>6. Update the tnsnames.ora.<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/strong> Add the tns alias PARIS and LONDON for each of the instances of the primary and standby database.\n<\/p>\n<p><strong><\/strong><\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">PARIS =\n&nbsp;&nbsp; (DESCRIPTION =\n&nbsp;&nbsp;&nbsp;&nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST = paris.evilcorp.com)(PORT = 1521))\n&nbsp;&nbsp;&nbsp;&nbsp; (CONNECT_DATA =\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SERVER = DEDICATED)\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SERVICE_NAME = <strong><font color=\"#0000ff\">PARIS.evilcorp.com<\/font><\/strong>)&nbsp; \n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (UR = A)\n&nbsp;&nbsp;&nbsp;&nbsp; )\n&nbsp;&nbsp; )\nLONDON =\n&nbsp;&nbsp; (DESCRIPTION =\n&nbsp;&nbsp;&nbsp; (ADDRESS_LIST =\n&nbsp;&nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST =london1-vip.evilcorp.com)(PORT = 1521))\n&nbsp;&nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST =london2-vip.evilcorp.com)(PORT = 1521)))&nbsp;&nbsp; \n    --two addresses need to be listed for rman duplicate and DG\n&nbsp;&nbsp;&nbsp;&nbsp; (CONNECT_DATA =\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SERVER = DEDICATED)\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SERVICE_NAME = <strong><font color=\"#0000ff\">RAC_DB.evilcorp.com<\/font><\/strong>)\n&nbsp;&nbsp;&nbsp;&nbsp; )\n&nbsp;&nbsp; )<\/pre>\n<\/blockquote>\n<h3 id=\"Standbysite\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b. Standby site preparation&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html\"><font size=\"4\">Go to Top<\/font><\/a><\/h3>\n<p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1. Copy\/Create the password file for standby database.&nbsp;&nbsp; <\/strong><\/p>\n<blockquote>\n<p>&nbsp;&nbsp; &#8211; On the standby server run the following command\n<\/p>\n<p><strong><\/strong><\/p>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">[oracle@paris]# orapwd file=\/u01\/app\/oracle\/product\/12.1.0.2\/db_1\/dbs\/orapwPARIS password=racattack&nbsp; ENTRIES=30 FORCE=Y&nbsp; IGNORECASE=Y\n<\/pre>\n<p>&nbsp; &#8211; Or&nbsp; copy it from one of the the primary nodes :<\/p>\n<p><strong><\/strong><\/p>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">ASMCMD&gt; pwcopy --dbuniquename rac_db&nbsp; +DATA\/RAC_DB\/PASSWORD\/pwdrac_db.284\n \/u01\/app\/oracle\/product\/12.1.0.2\/db_1\/dbs\/orapwPARIS\nASMCMD&gt; exit\n\n[oracle@london1]# <strong>scp<\/strong> \/u01\/app\/oracle\/product\/12.1.0.2\/db_1\/dbs\/orapwparis.ora paris.evilcorp.com:\/u01\/app\/oracle\/product\/12.1.0.2\/db_1\/dbs\/<\/pre>\n<p>&nbsp; <strong>2. Create required directories for Standby database Instance.<br \/>\n<\/strong><\/p>\n<p><strong><\/strong><\/p>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">- Create standby database Directories \n[oracle@paris]$ <strong>mkdir -p<\/strong>&nbsp; \/u01\/app\/oracle\/admin\/paris\/adump\n[oracle@paris]$ <strong>mkdir -p<\/strong>&nbsp; \/u01\/app\/oracle\/diag\/rdbms\/paris\/paris\/cdump\n[oracle@paris]$ <strong>mkdir -p<\/strong>&nbsp; \/u01\/app\/oracle\/diag\/rdbms\/paris\/paris\/trace\n[oracle@paris]$ <strong>mkdir -p<\/strong>&nbsp; \/u01\/app\/oracle\/audit\/paris&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \n[root@paris  ]$ <strong>mkdir -p<\/strong> \/u01\/oradata\/paris\n[root@paris  ]$ <strong>chown -R<\/strong> oracle:oinstall \/u01\/oradata\/paris\n[root@paris  ]$ <strong>chmod -R<\/strong> 775 \/u01\/oradata\/paris\n\n- Database Files directories\n[oracle@paris]$ <strong>mkdir \u2013p<\/strong> \/u01\/oradata\/paris\/data\n[oracle@paris]$ <strong>mkdir&nbsp; -p<\/strong> \/u01\/oradata\/paris\/redo\n[oracle@paris]$ <strong>mkdir&nbsp; -p<\/strong> \/u01\/oradata\/paris\/FRA\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/pre>\n<p>&nbsp; <strong>3. Ora Net Configuration<\/strong><br \/>\n&nbsp;&nbsp; &#8211;&nbsp; Add a static listener service in the <em>listener.ora<\/em> file of the standby host. The purpose to be able to see the database service while the standby DB is in nomount stage .the second service is related to the Broker configuration which will be discussed later .\n<\/p>\n<p><strong><\/strong><\/p>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">[oracle@paris ~]$ vi $ORACLE_SID\/network\/admin\/listener.ora\nLISTENER =\n&nbsp;&nbsp; (DESCRIPTION_LIST =\n&nbsp;&nbsp;&nbsp;&nbsp; (DESCRIPTION =\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST = paris.evilcorp.com) \n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (PORT = 1521))))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \n\nSID_LIST_LISTENER =\n(SID_LIST =\n&nbsp;&nbsp;&nbsp; (SID_DESC =\n&nbsp;&nbsp;&nbsp; (GLOBAL_DBNAME=PARIS.evilcorp.com)\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SID_NAME = PARIS)\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ORACLE_HOME = \/u01\/app\/oracle\/product\/12.1.0.2\/db_1))\n&nbsp;&nbsp;&nbsp; <font color=\"#0000ff\">(SID_DESC =\n&nbsp;&nbsp;&nbsp;&nbsp; (GLOBAL_DBNAME=PARIS_DGMGRL.evilcorp.com)\n&nbsp;&nbsp;&nbsp;&nbsp; (ORACLE_HOME = \/u01\/app\/oracle\/product\/12.1.0.2\/db_1)&nbsp; \n        -- For switchovers When former primary is Paris\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SID_NAME = PARIS)\n&nbsp;&nbsp;&nbsp; )<\/font>\n) \n\nADR_BASE_LISTENER = \/u01\/app\/oracle <\/pre>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">[oracle@paris ~]$lsnrctl reload \n[oracle@paris ~]$ lnsrctl status\nServices Summary...\nService \"PARIS\" has 1 instance(s).&nbsp;&nbsp; \nInstance \"PARIS\", status UNKNOWN, has 1 handler(s) for this service... <\/pre>\n<p>&#8211; Copy the tnsnames.ora from a Primary node 1 to standby database host .\n<\/p>\n<p><strong><\/strong><\/p>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">[oracle@london1]$scp $ORACLE_HOME\/network\/admin\/tnsnames.ora paris:$ORACLE_HOME\/network\/admin\/tnsnames.ora<\/pre>\n<p><strong>4. Create a parameter file on the standby host<br \/>\n<\/strong><\/p>\n<p>&#8211; add the bellow line to the temporary pfile<\/p>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">[oracle@paris]$ vi&nbsp; \/u01\/app\/oracle\/product\/12.1.0.2\/db_1\/dbs\/tempini.ora \ndb_name=PARIS <\/pre>\n<\/blockquote>\n<h3 id=\"RMANduplicate\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c. RMAN duplicate (Create standby Database)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html\"><font size=\"4\">Go to Top<\/font><\/a><\/h3>\n<p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.&nbsp; start the database in NOMOUNT mode <\/strong><\/p>\n<p><strong><\/strong><\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">[oracle@paris]$ export ORACLE_SID=PARIS&nbsp; \n[oracle@paris]$ sqlplus&nbsp; '\/ as sysdba'\nSQL&gt; STARTUP PFILE='\/u01\/app\/oracle\/product\/12.1.0.2\/db_1\/dbs\/tempini.ora' NOMOUNT;<\/pre>\n<\/blockquote>\n<blockquote>\n<p><strong>2.&nbsp; RMAN Connectivity Test<\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">[oracle@paris]$ <strong>rman target<\/strong> sys\/racattack@london auxiliary sys\/racattack@paris\n \nRecovery Manager: Release 12.1.0.2.0 - Production on Sat Jun 22 05:19:33 2019\n connected to target database: RAC_DB (DBID=2030859864)\n connected to auxiliary database: PARIS (not mounted)<\/pre>\n<\/blockquote>\n<blockquote>\n<p><strong>3.&nbsp; Verify the PDB and temp files that will need to be renamed during the duplicate process <\/strong>\n<\/p>\n<\/blockquote>\n<p><strong><\/strong><\/p>\n<p><strong><\/strong><\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 11px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">RMAN&gt; REPORT SCHEMA \nList of Permanent Datafiles\n===========================\nFile Size(MB) Tablespace&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RB segs Datafile Name\n\n---- -------- -------------------- ------- ------------------------\n\n1&nbsp;&nbsp;&nbsp; 810&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SYSTEM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YES&nbsp;&nbsp;&nbsp;&nbsp; +DATA\/RAC_DB\/DATAFILE\/system.270.975538023\n\n3&nbsp;&nbsp;&nbsp; 1390&nbsp;&nbsp;&nbsp;&nbsp; SYSAUX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +DATA\/RAC_DB\/DATAFILE\/sysaux.283.975537987\n\n4&nbsp;&nbsp;&nbsp; 260&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UNDOTBS1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YES&nbsp;&nbsp;&nbsp;&nbsp; +DATA\/RAC_DB\/DATAFILE\/undotbs1.296.975538069\n\n5&nbsp;&nbsp;&nbsp; 250&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font color=\"#0000ff\">PDB$SEED:SYSTEM<\/font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +DATA\/RAC_DB\/FD9AC20F64D24..\/DATAFILE\/system.274.975538175\n\n6&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; USERS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +DATA\/RAC_DB\/DATAFILE\/users.269.975538067\n\n7&nbsp;&nbsp;&nbsp; 580&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font color=\"#0000ff\">PDB$SEED:SYSAUX<\/font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +DATA\/RAC_DB\/FD9AC20F64D24..\/DATAFILE\/sysaux.282.975538175\n\n8&nbsp;&nbsp;&nbsp; 250&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UNDOTBS2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YES&nbsp;&nbsp;&nbsp;&nbsp; +DATA\/RAC_DB\/DATAFILE\/undotbs2.272.975538737\n\n9&nbsp;&nbsp;&nbsp; 260&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font color=\"#0000ff\">PDB:SYSTEM<\/font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +DATA\/RAC_DB\/6BAA223C8EF96..\/DATAFILE\/system.298.975539497\n\n10&nbsp;&nbsp; 600&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font color=\"#0000ff\">PDB:SYSAUX<\/font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +DATA\/RAC_DB\/6BAA223C8EF96..\/DATAFILE\/sysaux.297.975539497\n\n11&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font color=\"#0000ff\">PDB:USERS<\/font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +DATA\/RAC_DB\/6BAA223C8EF96..\/DATAFILE\/users.290.975539621\n\nList of Temporary Files\n=======================\nFile Size(MB) Tablespace&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Maxsize(MB) Tempfile Name\n---- -------- -------------------- ----------- --------------------\n1&nbsp;&nbsp;&nbsp; 201&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TEMP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 32767&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +DATA\/RAC_DB\/TEMPFILE\/temp.285.975538165\n2&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font color=\"#0000ff\">PDB$SEED:TEMP<\/font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 32767&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +DATA\/RAC_DB\/FD9AC20F64D24..\/DATAFILE\/pdbseed_temp-pm.dbf\n3&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font color=\"#0000ff\">PDB:TEMP<\/font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 32767&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +DATA\/RAC_DB\/6BAA223C8EF96..\/TEMPFILE\/temp.291.975539559<\/pre>\n<\/blockquote>\n<blockquote>\n<p><strong>5.&nbsp; Create PDB Database directories<\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">[oracle@paris]$ <strong>mkdir<\/strong> \u2013p \/u01\/oradata\/paris\/PDBSEED&nbsp;&nbsp;&nbsp;&nbsp; ##PDB$SEED:\n[oracle@paris]$ <strong>mkdir<\/strong> -p \/u01\/oradata\/paris\/PDB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ##PDB:\n[root@paris  ]$ <strong>chmod<\/strong> -R 775 \/u01\/oradata\/paris<\/pre>\n<\/blockquote>\n<blockquote>\n<p><strong>6. Duplicate the primary database to the standby site<\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">RMAN&gt; run\n{\nallocate channel prmy1 type disk;\nallocate channel prmy2 type disk;\nallocate auxiliary channel stby1 type disk;\nset newname for tempfile 1 to '\/u01\/oradata\/paris\/data\/temp01.dbf';\nset newname for tempfile 2 to '\/u01\/oradata\/paris\/PDBSEED\/temp01.dbf';\nset newname for tempfile 3 to '\/u01\/oradata\/paris\/PDB\/temp01.dbf';\nset newname for datafile 5 to '\/u01\/oradata\/paris\/PDBSEED\/system.dbf';\nset newname for datafile 7 to '\/u01\/oradata\/paris\/PDBSEED\/sysaux.dbf';\nset newname for datafile 9 to '\/u01\/oradata\/paris\/PDB\/system.dbf';\nset newname for datafile 10 to '\/u01\/oradata\/paris\/PDB\/sysaux.dbf';\nset newname for datafile 11 to '\/u01\/oradata\/paris\/PDB\/users.dbf';\nduplicate target database for standby from active database \n#DORECOVER\nspfile\nparameter_value_convert 'RAC_DB','PARIS'\nset 'db_unique_name'='PARIS'\nset diagnostic_dest='\/u01\/app\/oracle'\nset audit_file_dest='\/u01\/app\/oracle\/audit\/paris'\nset core_dump_dest='\/u01\/app\/oracle\/diag\/rdbms\/paris\/paris\/cdump'\nset db_recovery_file_dest='\/u01\/oradata\/paris\/FRA'\nset db_create_file_dest='\/u01\/oradata\/paris\/data'\nset db_create_online_log_dest_1='\/u01\/oradata\/paris\/data'\nset db_create_online_log_dest_2='\/u01\/oradata\/paris\/FRA'\nset CONTROL_FILES='\/u01\/oradata\/paris\/FRA\/control01.ctl'\nset CLUSTER_DATABASE='FALSE' \nset 'Fal_server'='london'\nset log_Archive_dest_2='SERVICE=london ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=RAC_DB'\nnofilenamecheck;&nbsp; }<\/pre>\n<\/blockquote>\n<blockquote>\n<p>see complete output here : <a title=\"https:\/\/bit.ly\/2LDnf2b\" href=\"https:\/\/bit.ly\/2LDnf2b\">https:\/\/bit.ly\/2LDnf2b<\/a><\/p>\n<\/blockquote>\n<blockquote>\n<p><strong>7. Check the Standby Database status <\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">PARIS&gt; select db_unique_name,database_role,open_mode from v$database;\nDB_UNIQUE_NAME&nbsp; DATABASE_ROLE&nbsp;&nbsp;&nbsp; OPEN_MODE\n--------------- ---------------- --------------------\nPARIS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PHYSICAL STANDBY  MOUNTED<\/pre>\n<\/blockquote>\n<h2 id=\"III\"><a href=\"https:\/\/www.blogger.com\/null\"><a href=\"https:\/\/www.blogger.com\/null\"><a href=\"https:\/\/www.blogger.com\/null\">III. DATA GUARD BROKER CONFIGURATION<\/a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html\"><font size=\"4\">Go to Top<\/font><\/a><\/h2>\n<ul>\n<h3 id=\"PrimaryHost\">a. Primary Host<\/h3>\n<\/ul>\n<p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1. Configure and Enable the broker parameter&nbsp;&nbsp; <\/strong><\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">LONDON&gt; alter system set <strong>dg_broker_config_file1<\/strong>='+DATA\/RAC_DB\/dr1london.dat' scope=both sid='*';\n\nLONDON&gt; alter system set <strong>dg_broker_config_file2<\/strong>='+FRA\/RAC_DB\/dr2london.dat' scope=both sid='*';\n\nLONDON &gt;  alter system set <strong>dg_broker_start<\/strong>=true scope=both sid='*';<\/pre>\n<p>&nbsp;<strong>2. Unset&nbsp; the <strong><em>log_archive_dest_2 <\/em><\/strong>parameter to avoid&nbsp; ORA-16698<\/strong><\/p>\n<p> Clear existing LOG_ARCHIVE_DEST_n on every instances referencing network locations is a prerequisite to create a broker configuration.&nbsp;&nbsp; <strong><br \/>\n<\/strong><\/p>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">LONDON&gt; select name,value from v$parameter where value like '%SERVICE%' ;\n\nNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUE \n------------------------ -------------------------------------------------------\nlog_archive_dest_2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SERVICE=paris SYNC REOPEN=15 VALID_FOR  \n                          (ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=PARIS<\/pre>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">LONDON&gt; alter system set log_ARCHIVE_DEST_2='' scope=both; <\/pre>\n<\/blockquote>\n<ul>\n<h3 id=\"StandbyHost\">b. Standby Host<\/h3>\n<\/ul>\n<blockquote>\n<p><strong> 1. Configure and Enable the broker parameter&nbsp;&nbsp; <\/strong><\/p>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">PARIS &gt; alter system set <strong>dg_broker_start<\/strong>=true scope=both ;<\/pre>\n<\/blockquote>\n<blockquote>\n<p><strong> 2. Unset&nbsp; the <strong><em>log_archive_dest_2 <\/em><\/strong>parameter&nbsp;&nbsp;&nbsp; <strong><br \/>\n<\/strong><\/strong><\/p>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">PARIS&gt; alter system set log_ARCHIVE_DEST_2='' scope=both; <\/pre>\n<\/blockquote>\n<ul>\n<h3 id=\"CreateBrokerconfiguration\">c. Create Broker configuration<\/h3>\n<p>&nbsp;&nbsp; <strong>1.<\/strong> <strong>Creation<\/strong><\/p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp; Execute the following in the DGMGRL window to create and enable the broker configuration\n<\/p>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">$ dgmgrl sys\/racattack@london<\/pre>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\"><font size=\"2\">DGMGRL&gt; <strong>CREATE<\/strong> <strong>CONFIGURATION<\/strong> <font color=\"#0000ff\">DG_RAC12<\/font> as primary database is <font color=\"#0000ff\">RAC_DB<\/font> connect identifier is <font color=\"#0000ff\">london<\/font>;<\/font> \n\n<font color=\"#008040\" size=\"2\"><em>Configuration \"DG_RAC12\" created with primary database \"RAC_DB\"<\/em><\/font>\n\n<font color=\"#008000\">## Add standby Database # Paris\n<\/font>\n<font size=\"2\">DGMGRL&gt; <strong>add database<\/strong> PARIS as connect identifier is paris maintained as physical;<\/font>&nbsp; \n<font color=\"#008040\" size=\"2\"><em>Database \"paris\" added\n\n## enable configuration \n<font size=\"2\"><font color=\"#000000\">DGMGRL&gt; enable configuration; \n<\/font>Enabled. <\/font><\/em><\/font><\/pre>\n<\/ul>\n<blockquote>\n<p><strong> 2. check the configuration&nbsp;&nbsp;&nbsp;&nbsp; <\/strong><\/p>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\"><font size=\"2\">DGMGRL&gt; <strong>show configuration<\/strong>\nConfiguration - dg_rac12\nProtection Mode: MaxPerformance\n&nbsp; Members:\n&nbsp; rac_db - Primary database\n&nbsp;&nbsp;&nbsp; paris&nbsp; - Physical standby database \nFast-Start Failover: DISABLED\nConfiguration Status:\nSUCCESS&nbsp;&nbsp; <\/font><\/pre>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\"><font size=\"2\">DGMGRL&gt; <strong>show database paris<\/strong>\nDatabase - paris\n  Role:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PHYSICAL STANDBY\n&nbsp; Intended State:&nbsp;&nbsp;&nbsp;&nbsp; APPLY-ON\n&nbsp; Transport Lag:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 seconds (computed 0 seconds ago)\n&nbsp; Apply Lag:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 seconds (computed 0 seconds ago)\n&nbsp; Average Apply Rate: 932.00 KByte\/s\n&nbsp; Real Time Query:&nbsp;&nbsp;&nbsp; OFF\n&nbsp; Instance(s):\n&nbsp;&nbsp;&nbsp; PARIS\nDatabase Status: SUCCESS<\/font><\/pre>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\"><font size=\"2\">DGMGRL&gt; <strong>show database rac_db<\/strong>\nDatabase - rac_db\n<font size=\"2\">&nbsp; Role:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PRIMARY\n&nbsp; Intended State:&nbsp;&nbsp;&nbsp;&nbsp; TRANSPORT-ON\n&nbsp; Instance(s):\n&nbsp;&nbsp;&nbsp; RACDB_1\n&nbsp;&nbsp;&nbsp; RACDB_2\nDatabase Status:\nSUCCESS<\/font><\/font><\/pre>\n<p>&nbsp;\n<\/p>\n<\/blockquote>\n<p><\/span><\/p>\n<h2 id=\"IV\"><a href=\"https:\/\/www.blogger.com\/null\"><a href=\"https:\/\/www.blogger.com\/null\"><a href=\"https:\/\/www.blogger.com\/null\">IV. DATA GUARD ADMINISTRATION USING ORACLE BROKER<\/a>&nbsp;&nbsp;&nbsp; <\/h2>\n<ul>\n<h3 id=\"SwitchovertoParis\"> a. Switchover to Paris&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html\"><font size=\"4\">Go to Top<\/font><\/a><\/h3>\n<\/ul>\n<p><span style=\"font-size: 14px; white-space: pre-wrap;\"><\/p>\n<p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1. validate the database prior to a role change<br \/>\n<\/strong><\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\"><a href=\"mailto:sys\/racattack@DGMGRL\"><font color=\"#000000\">DGMGRL<\/font><\/a><font color=\"#000000\">&gt;<\/font> validate database paris\n&nbsp; Database Role:&nbsp;&nbsp;&nbsp;&nbsp; Physical standby database\n&nbsp; Primary Database:&nbsp; <strong>rac_db<\/strong>\n&nbsp; Ready for Switchover: <strong>Yes<\/strong>\n&nbsp; Ready for Failover:&nbsp;&nbsp; <strong>Yes (Primary Running)<\/strong>\n&nbsp; Capacity Information:\n&nbsp;&nbsp;&nbsp; <strong>Database&nbsp; Instances&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Threads<\/strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp; rac_db&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp; paris&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp; Warning: the target standby has fewer instances than the\n&nbsp;&nbsp;&nbsp; primary database, this may impact application performance\n\n&nbsp; Flashback Database Status:\n&nbsp;&nbsp;&nbsp; rac_db:&nbsp; Off\n&nbsp;&nbsp;&nbsp; paris:&nbsp;&nbsp; Off&nbsp; <\/pre>\n<\/blockquote>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <strong>2. switchover to standby Database<br \/>\n<\/strong><\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">DGMGRL&gt; <strong>SWITCHOVER TO 'paris'<\/strong>\n<a href=\"mailto:sys\/racattack@Performing\">Performing<\/a> switchover NOW, please wait...\nOperation requires a connection to instance \"PARIS\" on database \"paris\"\nConnecting to instance \"PARIS\"...\nConnected as SYSDBA.\nNew primary database <strong>\"paris\"<\/strong> is opening...\nOracle Clusterware is restarting database <strong>\"rac_db\"<\/strong> ...\nSwitchover succeeded, <strong>new primary is \"paris\"<\/strong><\/pre>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">DGMGRL&gt; <strong>show configuration<\/strong>\nConfiguration - dg_rac12\n&nbsp; Protection Mode: MaxPerformance\n&nbsp; Members:\n&nbsp; paris&nbsp; - Primary database\n&nbsp;&nbsp;&nbsp; rac_db - Physical standby database \nFast-Start Failover: DISABLED\n\nConfiguration Status:\nSUCCESS&nbsp;&nbsp; (status updated 21 seconds ago)<\/pre>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">DGMGRL&gt;<strong> show&nbsp; database<\/strong>&nbsp; <strong>rac_db<\/strong>\nDatabase - rac_db\n&nbsp; Role:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PHYSICAL STANDBY\n&nbsp; Intended State:&nbsp;&nbsp;&nbsp;&nbsp; APPLY-ON\n&nbsp; Transport Lag:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 seconds (computed 1 second ago)\n&nbsp; Apply Lag:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 seconds (computed 1 second ago)\n&nbsp; Average Apply Rate: 128.00 KByte\/s\n&nbsp;&nbsp; Real Time Query:&nbsp;&nbsp;&nbsp; OFF\n&nbsp; Instance(s):\n&nbsp;&nbsp;&nbsp; RACDB_1 (apply instance)     --- In RAC only one instance applies redo\n&nbsp;&nbsp;&nbsp; RACDB_2<strong>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/strong><\/pre>\n<\/blockquote>\n<p><\/span><\/p>\n<ul>\n<h3 id=\"VerifyandChangetheApplyinstance\">b. Change and verify the Apply instance<\/h3>\n<\/ul>\n<p><span style=\"font-size: 14px; white-space: pre-wrap;\"><\/p>\n<p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1. change the APPLY-ON state from instance RACDB_1 to RACDB_2<\/strong><\/p>\n<blockquote>\n<p>&nbsp;&nbsp;&nbsp; Only one RAC instance can run log-apply services at any time (Apply instance). The<br \/>\n&nbsp;&nbsp;&nbsp; current apply instance is RACDB_1. Run the below command to update the Preferred Apply Instance:\n<\/p>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">DGMGRL&gt; EDIT DATABASE RAC_DB SET STATE='APPLY-ON' <font color=\"#0000ff\">WITH APPLY INSTANCE=RACDB_2<\/font>;&nbsp; \n--------------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \n Succeeded.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/pre>\n<\/blockquote>\n<blockquote>\n<p><strong>&nbsp; <\/strong>Check the applied change\n<\/p>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">DGMGRL&gt; show database <strong>rac_db<\/strong>\nDatabase - rac_db\n&nbsp; Role:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PHYSICAL STANDBY\n&nbsp; Intended State:&nbsp;&nbsp;&nbsp;&nbsp; APPLY-ON\n&nbsp; Transport Lag:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 seconds (computed 0 seconds ago)\n&nbsp; Apply Lag:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 seconds (computed 0 seconds ago)\n&nbsp; Average Apply Rate: 0 Byte\/s\n&nbsp; Real Time Query:&nbsp;&nbsp;&nbsp; OFF\n&nbsp; Instance(s):\n&nbsp;&nbsp;&nbsp; RACDB_1 \n&nbsp;&nbsp;&nbsp; <font color=\"#0000ff\">RACDB_2 (apply instance)<\/font> \n&nbsp; \n\nDatabase Status: SUCCESS<strong>&nbsp;&nbsp; \n\n<\/strong><\/pre>\n<\/blockquote>\n<p><\/span><\/p>\n<ul>\n<h3 id=\"Switchback_to_former_primary\"> c. Switch back to former primary RAC_DB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html\"><font size=\"4\">Go to Top<\/font><\/a><\/h3>\n<\/ul>\n<p><span style=\"font-size: 14px; white-space: pre-wrap;\"><\/p>\n<p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/strong>Run this if no error was shown in the validate database rac_db command&nbsp;\n<\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; font-weight: 400; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">DGMGRL&gt; <strong>switchover to \u2018rac_db\u2019<\/strong>\nPerforming switchover NOW, please wait...\nOperation requires a connection to instance \"RACDB_1\" on database \"rac_db\"\nConnecting to instance \"RACDB_1\"...\nConnected as SYSDBA.\nNew primary database <strong>\"rac_db\"<\/strong> is opening...\nOperation requires start up of instance <strong>\"PARIS\"<\/strong> on database \"paris\"\nStarting instance \"PARIS\"...\nORACLE instance started.\nDatabase mounted.\nSwitchover succeeded,<strong> new primary is \"rac_db\"<\/strong><\/pre>\n<\/blockquote>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <strong>Note : <\/strong>Additionally it\u2019s always useful to keep an eye on the below logs for errors during switchovers\n<\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">-- RAC node 1\ntail -f \/u01\/app\/oracle\/diag\/rdbms\/rac_db\/RACDB_1\/trace\/alert_RACDB_1.log\ntail -f \/u01\/app\/oracle\/diag\/rdbms\/rac_db\/RACDB_1\/trace\/drcRACDB_1.log\n-- RAC node 2\ntail -f \/u01\/app\/oracle\/diag\/rdbms\/rac_db\/RACDB_2\/trace\/alert_RACDB_2.log\ntail -f \/u01\/app\/oracle\/diag\/rdbms\/rac_db\/RACDB_2\/trace\/drcRACDB_2.log\n\n-- Single instance Paris\n#tail -f \/u01\/app\/oracle\/diag\/rdbms\/paris\/paris\/trace\/alert_PARIS.log\n#tail -f \/u01\/app\/oracle\/diag\/rdbms\/paris\/paris\/trace\/drcPARIS.log\n<\/pre>\n<\/blockquote>\n<h2><\/h2>\n<ul>\n<h3>&nbsp;&nbsp;&nbsp; <\/h3>\n<\/ul>\n<ul>\n<h3 id=\"Common_Mistakes\"> e. Common mistakes <\/h3>\n<\/ul>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <strong> 1- Data Guard broker and RAC communication:<\/strong><br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If you choose a custom service created with srvctl on the RAC Primary site in the tns description to access<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; the RAC primary instances (Connect Identifier).You will receive the below error while performing either<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; switchover or failover operation.\n<\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; white-space: pre-wrap; background-color: rgb(248, 249, 250);\">DGMGRL&gt; SWITCHOVER TO 'paris' verbose; \n&nbsp; Performing switchover NOW, please wait...\nOperation requires a connection to instance \"PARIS\" on database \"paris\"\nConnecting to instance \"PARIS\"...\nConnected as SYSDBA.\nNew primary database \"paris\" is opening...\nOracle Clusterware is restarting database \"rac_db\" ...\nUnable to connect to database using london\n\n<font color=\"#ff0000\">ORA-12514: TNS:listener does not currently know of service requested in connect descriptor<\/font><\/pre>\n<\/blockquote>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The reason behind it is that a switchover using the Data Guard broker causes the database role to be changed in the<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OCR. At the service startup, the CRS agent will check the database ROLE attribute saved in the OCR, to see if the<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; database role is matching the service role or not, and if the mismatch (service role vs new role after switchover) has<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; been detected the service won\u2019t start. Thus the Broker won\u2019t be able to communicate with the new standby DB. <\/p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <strong>Solution: <\/strong>Always use the default database service created upon RAC installation as the DGConnectidentifier .<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In my case I replaced the custom service by&nbsp; the native one rac_db which allows dynamic registration.\n<\/p>\n<blockquote>\n<pre style=\"padding: 1em; border: 1px solid rgb(234, 236, 240); border-image: none; color: black; line-height: 1.3em; font-family: monospace , monospace; font-size: 14px; font-style: normal; white-space: pre-wrap; background-color: rgb(248, 249, 250);\"><font color=\"#000000\">sys@RAC_DB.EVILCORP.COM<\/font>&gt; show parameter service_name\nNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUE\n------------------------------------ ----------- ------------------------------\nservice_names&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font color=\"#0000ff\">RAC_DB.evilcorp.com<\/font>\n\n- Check the listener service registrations after switchover\n\n[root@london1]# lsnrctl services \nService \"<font color=\"#0000ff\">RAC_DB_DGB.evilcorp.com<\/font>\" has 1 instance(s).\n&nbsp; Instance \"RACDB_2\", status READY, has 1 handler(s) for this service...\n...<\/pre>\n<\/blockquote>\n<ul>&nbsp;&nbsp;&nbsp; <strong> 2- Data Guard broker link with non grid based Oracle Database:<\/strong><br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Oracle Data Guard requires that you configure a static listener for the database and for the broker<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; agent If neither Oracle restart nor Oracle clusterware are available (non GRID installation). Refer to&nbsp;&nbsp;&nbsp;<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; the <em><u>\u201cPrimary site preparation\u201d<\/u><\/em> section upper in this guide.<\/ul>\n<ul>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/p>\n<h3><font color=\"#c4670b\"> d. Conclusion<\/font> <\/h3>\n<\/ul>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; We\u2019ve explored in this exercise how easy it became to setup a&nbsp; \u201cMaximum Availability Architecture \u2013 single instance<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Physical Standby for a High-available (RAC)&nbsp; primary environment\u201d \u2013 using RMAN duplicate and Data Guard Broker<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; in simple steps . The major challenge in this lab was certainly the Oracle network configuration as I had to face<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; different errors while trying to figure the relevant setting .<\/p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http:\/\/koussilicious.blogspot.com\/2019\/06\/maa-setup-creating-single-instance.html\"><font size=\"4\"><strong>Go to Top<\/strong><\/font><\/a><\/p>\n<p><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: Oracle provides many options for preventing downtime and data loss, all of which make up the Maximum Availability Architecture (MAA). The Oracle Maximum Availability Architecture offers a set of standard reference architectures&#8211;Bronze, Silver, Gold, and Platinum Solutions&#8211; that comply with Customer Business Objectives. With multiple instances, the RAC system gives a transparent HA and &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance\" class=\"more-link\">Read more<span class=\"screen-reader-text\"> &#8220;MAA setup\u2013 Creating Single instance Physical Standby for RAC Primary &#8211; 12c&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":396,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_editorskit_title_hidden":false,"_editorskit_reading_time":0,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","footnotes":""},"categories":[1],"tags":[42,37,59,57],"class_list":["post-395","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-data-guard","tag-oracle-database","tag-rac","tag-virtualbox"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MAA setup\u2013 Creating Single instance Physical Standby for RAC Primary - 12c - Cloudthrill<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MAA setup\u2013 Creating Single instance Physical Standby for RAC Primary - 12c - Cloudthrill\" \/>\n<meta property=\"og:description\" content=\"Introduction: Oracle provides many options for preventing downtime and data loss, all of which make up the Maximum Availability Architecture (MAA). The Oracle Maximum Availability Architecture offers a set of standard reference architectures&#8211;Bronze, Silver, Gold, and Platinum Solutions&#8211; that comply with Customer Business Objectives. With multiple instances, the RAC system gives a transparent HA and &hellip; Read more &quot;MAA setup\u2013 Creating Single instance Physical Standby for RAC Primary &#8211; 12c&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance\" \/>\n<meta property=\"og:site_name\" content=\"Cloudthrill\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-01T03:01:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-05T22:41:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cloudthrill.ca\/wp-content\/uploads\/2019\/07\/MAA_Reference_Architectures.png\" \/>\n\t<meta property=\"og:image:width\" content=\"658\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"CloudDude\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@couddude_\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"CloudDude\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"38 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/maa-setup-creating-single-instance#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/maa-setup-creating-single-instance\"},\"author\":{\"name\":\"CloudDude\",\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/#\\\/schema\\\/person\\\/aaac9d7e544fd61849e31ac4230a57f3\"},\"headline\":\"MAA setup\u2013 Creating Single instance Physical Standby for RAC Primary &#8211; 12c\",\"datePublished\":\"2019-07-01T03:01:00+00:00\",\"dateModified\":\"2024-07-05T22:41:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/maa-setup-creating-single-instance\"},\"wordCount\":3393,\"publisher\":{\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/maa-setup-creating-single-instance#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cloudthrill.ca\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/MAA_Reference_Architectures.png\",\"keywords\":[\"Data Guard\",\"Oracle Database\",\"RAC\",\"VirtualBox\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/maa-setup-creating-single-instance\",\"url\":\"https:\\\/\\\/cloudthrill.ca\\\/maa-setup-creating-single-instance\",\"name\":\"MAA setup\u2013 Creating Single instance Physical Standby for RAC Primary - 12c - Cloudthrill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/maa-setup-creating-single-instance#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/maa-setup-creating-single-instance#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cloudthrill.ca\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/MAA_Reference_Architectures.png\",\"datePublished\":\"2019-07-01T03:01:00+00:00\",\"dateModified\":\"2024-07-05T22:41:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/maa-setup-creating-single-instance#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/cloudthrill.ca\\\/maa-setup-creating-single-instance\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/maa-setup-creating-single-instance#primaryimage\",\"url\":\"https:\\\/\\\/cloudthrill.ca\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/MAA_Reference_Architectures.png\",\"contentUrl\":\"https:\\\/\\\/cloudthrill.ca\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/MAA_Reference_Architectures.png\",\"width\":658,\"height\":360},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/maa-setup-creating-single-instance#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/cloudthrill.ca\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MAA setup\u2013 Creating Single instance Physical Standby for RAC Primary &#8211; 12c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/#website\",\"url\":\"https:\\\/\\\/cloudthrill.ca\\\/\",\"name\":\"cloudthrill.ca\",\"description\":\"CloudThrill is focused on providing Cloud &amp; DevOps consulting services to clients looking to maximize their cloud\\\/on-prem estate.\",\"publisher\":{\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/cloudthrill.ca\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/#organization\",\"name\":\"cloudthrill.ca\",\"url\":\"https:\\\/\\\/cloudthrill.ca\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/cloudthrill.ca\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/Cloudthrill.png\",\"contentUrl\":\"https:\\\/\\\/cloudthrill.ca\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/Cloudthrill.png\",\"width\":1599,\"height\":588,\"caption\":\"cloudthrill.ca\"},\"image\":{\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/cloudthrill\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/cloudthrill.ca\\\/#\\\/schema\\\/person\\\/aaac9d7e544fd61849e31ac4230a57f3\",\"name\":\"CloudDude\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bba403d23c390a42783246ef373bf8a8111b022c06a373d6cb9d3cabe12587?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bba403d23c390a42783246ef373bf8a8111b022c06a373d6cb9d3cabe12587?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bba403d23c390a42783246ef373bf8a8111b022c06a373d6cb9d3cabe12587?s=96&d=mm&r=g\",\"caption\":\"CloudDude\"},\"sameAs\":[\"http:\\\/\\\/cloudthrill.io\",\"https:\\\/\\\/x.com\\\/couddude_\"],\"url\":\"https:\\\/\\\/cloudthrill.ca\\\/author\\\/clouddude\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MAA setup\u2013 Creating Single instance Physical Standby for RAC Primary - 12c - Cloudthrill","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance","og_locale":"en_US","og_type":"article","og_title":"MAA setup\u2013 Creating Single instance Physical Standby for RAC Primary - 12c - Cloudthrill","og_description":"Introduction: Oracle provides many options for preventing downtime and data loss, all of which make up the Maximum Availability Architecture (MAA). The Oracle Maximum Availability Architecture offers a set of standard reference architectures&#8211;Bronze, Silver, Gold, and Platinum Solutions&#8211; that comply with Customer Business Objectives. With multiple instances, the RAC system gives a transparent HA and &hellip; Read more \"MAA setup\u2013 Creating Single instance Physical Standby for RAC Primary &#8211; 12c\"","og_url":"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance","og_site_name":"Cloudthrill","article_published_time":"2019-07-01T03:01:00+00:00","article_modified_time":"2024-07-05T22:41:54+00:00","og_image":[{"width":658,"height":360,"url":"https:\/\/cloudthrill.ca\/wp-content\/uploads\/2019\/07\/MAA_Reference_Architectures.png","type":"image\/png"}],"author":"CloudDude","twitter_card":"summary_large_image","twitter_creator":"@couddude_","twitter_misc":{"Written by":"CloudDude","Est. reading time":"38 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance#article","isPartOf":{"@id":"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance"},"author":{"name":"CloudDude","@id":"https:\/\/cloudthrill.ca\/#\/schema\/person\/aaac9d7e544fd61849e31ac4230a57f3"},"headline":"MAA setup\u2013 Creating Single instance Physical Standby for RAC Primary &#8211; 12c","datePublished":"2019-07-01T03:01:00+00:00","dateModified":"2024-07-05T22:41:54+00:00","mainEntityOfPage":{"@id":"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance"},"wordCount":3393,"publisher":{"@id":"https:\/\/cloudthrill.ca\/#organization"},"image":{"@id":"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance#primaryimage"},"thumbnailUrl":"https:\/\/cloudthrill.ca\/wp-content\/uploads\/2019\/07\/MAA_Reference_Architectures.png","keywords":["Data Guard","Oracle Database","RAC","VirtualBox"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance","url":"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance","name":"MAA setup\u2013 Creating Single instance Physical Standby for RAC Primary - 12c - Cloudthrill","isPartOf":{"@id":"https:\/\/cloudthrill.ca\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance#primaryimage"},"image":{"@id":"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance#primaryimage"},"thumbnailUrl":"https:\/\/cloudthrill.ca\/wp-content\/uploads\/2019\/07\/MAA_Reference_Architectures.png","datePublished":"2019-07-01T03:01:00+00:00","dateModified":"2024-07-05T22:41:54+00:00","breadcrumb":{"@id":"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance#primaryimage","url":"https:\/\/cloudthrill.ca\/wp-content\/uploads\/2019\/07\/MAA_Reference_Architectures.png","contentUrl":"https:\/\/cloudthrill.ca\/wp-content\/uploads\/2019\/07\/MAA_Reference_Architectures.png","width":658,"height":360},{"@type":"BreadcrumbList","@id":"https:\/\/cloudthrill.ca\/maa-setup-creating-single-instance#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cloudthrill.ca\/"},{"@type":"ListItem","position":2,"name":"MAA setup\u2013 Creating Single instance Physical Standby for RAC Primary &#8211; 12c"}]},{"@type":"WebSite","@id":"https:\/\/cloudthrill.ca\/#website","url":"https:\/\/cloudthrill.ca\/","name":"cloudthrill.ca","description":"CloudThrill is focused on providing Cloud &amp; DevOps consulting services to clients looking to maximize their cloud\/on-prem estate.","publisher":{"@id":"https:\/\/cloudthrill.ca\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cloudthrill.ca\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/cloudthrill.ca\/#organization","name":"cloudthrill.ca","url":"https:\/\/cloudthrill.ca\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudthrill.ca\/#\/schema\/logo\/image\/","url":"https:\/\/cloudthrill.ca\/wp-content\/uploads\/2024\/07\/Cloudthrill.png","contentUrl":"https:\/\/cloudthrill.ca\/wp-content\/uploads\/2024\/07\/Cloudthrill.png","width":1599,"height":588,"caption":"cloudthrill.ca"},"image":{"@id":"https:\/\/cloudthrill.ca\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/cloudthrill"]},{"@type":"Person","@id":"https:\/\/cloudthrill.ca\/#\/schema\/person\/aaac9d7e544fd61849e31ac4230a57f3","name":"CloudDude","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/02bba403d23c390a42783246ef373bf8a8111b022c06a373d6cb9d3cabe12587?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/02bba403d23c390a42783246ef373bf8a8111b022c06a373d6cb9d3cabe12587?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/02bba403d23c390a42783246ef373bf8a8111b022c06a373d6cb9d3cabe12587?s=96&d=mm&r=g","caption":"CloudDude"},"sameAs":["http:\/\/cloudthrill.io","https:\/\/x.com\/couddude_"],"url":"https:\/\/cloudthrill.ca\/author\/clouddude"}]}},"brizy_media":[],"_links":{"self":[{"href":"https:\/\/cloudthrill.ca\/wp-json\/wp\/v2\/posts\/395","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cloudthrill.ca\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudthrill.ca\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudthrill.ca\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudthrill.ca\/wp-json\/wp\/v2\/comments?post=395"}],"version-history":[{"count":1,"href":"https:\/\/cloudthrill.ca\/wp-json\/wp\/v2\/posts\/395\/revisions"}],"predecessor-version":[{"id":581,"href":"https:\/\/cloudthrill.ca\/wp-json\/wp\/v2\/posts\/395\/revisions\/581"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cloudthrill.ca\/wp-json\/wp\/v2\/media\/396"}],"wp:attachment":[{"href":"https:\/\/cloudthrill.ca\/wp-json\/wp\/v2\/media?parent=395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudthrill.ca\/wp-json\/wp\/v2\/categories?post=395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudthrill.ca\/wp-json\/wp\/v2\/tags?post=395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}