{"id":3810,"date":"2021-12-15T08:00:00","date_gmt":"2021-12-15T05:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=3810"},"modified":"2024-03-09T23:13:05","modified_gmt":"2024-03-09T20:13:05","slug":"pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/","title":{"rendered":"How do we install Oracle Data Guard as a Physical Standby for Disaster Recovery?"},"content":{"rendered":"<p>In this article we will see step by step how to install it <strong>Oracle Data Guard<\/strong> as Physical Standby on Unix. By using it, we have the possibility that changes made in the primary base are automatically transferred to another standby base. The standby base during this process is not accessible unless it is activated <strong>Active Data Guard<\/strong> which enables us to make it accessible for reading data.<\/p>\n\n\n\n<p>How it works and what options we have in Oracle Data Guard can be seen in detail in the article <a href=\"https:\/\/www.dataplatform.gr\/en\/ti-einai-to-oracle-data-guard\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n\n<p>This article comes to replace an older article with all the steps being much more detailed.<\/p>\n\n\n\n<p>To do the installation we will use the tool <a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e40771\/concepts.htm#DGBKR001\" target=\"_blank\" rel=\"noreferrer noopener\">Data Guard Broker<\/a> \/ <strong>DGMGRL<\/strong>.<\/p>\n\n\n\n<p>Below is the Data Guard infrastructure diagram:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"946\" height=\"388\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-14.png\" alt=\"\" class=\"wp-image-3812\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-14.png 946w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-14-300x123.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-14-768x315.png 768w\" sizes=\"auto, (max-width: 946px) 100vw, 946px\" \/><figcaption class=\"wp-element-caption\">01 (docs.oracle.com)<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Prerequisites<\/h2>\n\n\n\n<p>For starters we should have set it up <strong>Oracle Database Software<\/strong> on the primary and on the standby server and <strong>Oracle Database<\/strong> in primary to <em><strong>archivelog mode<\/strong><\/em>. How we do these installations can be seen step by step in the article <a href=\"https:\/\/www.dataplatform.gr\/en\/pos-kanoyme-mia-kainoyrgia-egkatasta\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Installing Data Guard<\/h2>\n\n\n\n<p>Go to the primary and standby server and pass the names of the servers with their IP:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">vi \/etc\/hosts<\/pre>\n\n\n\n<pre class=\"wp-block-code\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>\n172.21.64.11    oracledev1\n172.21.64.22    oracledev2\n<\/code><\/pre>\n\n\n\n<p>Then we change it <strong>tnsnames.ora<\/strong> on both servers (as service_name we will set the name of the instance):<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">vi $ORACLE_HOME\/network\/admin\/tnsnames.ora<\/pre>\n\n\n\n<pre class=\"wp-block-code\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>ORADEV =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = oracledev1)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = oradev)\n    )\n  )\n\nORADEVDR =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = oracledev2)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = oradev)\n    )\n  )<\/code><\/pre>\n\n\n\n<p>Then we change it too <strong>listener.ora<\/strong> on both servers:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">vi $ORACLE_HOME\/network\/admin\/listener.ora<\/pre>\n\n\n\n<p><em><strong>On primary (oracledev1):<\/strong><\/em><\/p>\n\n\n\n<pre class=\"wp-block-code\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>LISTENER =\n  (DESCRIPTION_LIST =\n    (DESCRIPTION =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = oracledev1)(PORT = 1521))\n      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\n    )\n  )\n\nSID_LIST_LISTENER =\n  (SID_LIST =\n    (SID_DESC =\n      (GLOBAL_DBNAME = oradev)\n      (ORACLE_HOME = \/oracle\/app\/oracle\/product\/19.3.0\/dbhome_1)\n      (SID_NAME = oradev)\n    )\n    (SID_DESC =\n      (GLOBAL_DBNAME = oradev_dgmgrl)\n      (ORACLE_HOME = \/oracle\/app\/oracle\/product\/19.3.0\/dbhome_1)\n      (SID_NAME = oradev)\n    )\n  )\n\nADR_BASE_LISTENER = \/oracle\/app\/oracle<\/code><\/pre>\n\n\n\n<p><em><strong> On standby (oracledev2): <\/strong><\/em><\/p>\n\n\n\n<pre class=\"wp-block-code\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>LISTENER =\n  (DESCRIPTION_LIST =\n    (DESCRIPTION =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = oracledev2)(PORT = 1521))\n      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\n    )\n  )\n\nSID_LIST_LISTENER =\n  (SID_LIST =\n    (SID_DESC =\n      (GLOBAL_DBNAME = oradev)\n      (ORACLE_HOME = \/oracle\/app\/oracle\/product\/19.3.0\/dbhome_1)\n      (SID_NAME = oradev)\n    )\n    (SID_DESC =\n      (GLOBAL_DBNAME = oradevdr_dgmgrl)\n      (ORACLE_HOME = \/oracle\/app\/oracle\/product\/19.3.0\/dbhome_1)\n      (SID_NAME = oradev)\n    )\n  )\n\nADR_BASE_LISTENER = \/oracle\/app\/oracle<\/code><\/pre>\n\n\n\n<p>After <strong>we connect to the primary base<\/strong> and we check how many online redo groups and what size they are. Accordingly, we create as many standby logfiles with as many groups as we have plus one with the size of the redo log groups:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">sqlplus \/ as sysdba<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">select group#,bytes\/1024\/1024 from v$log;<\/pre>\n\n\n\n<p>In our case we have three redo groups of 200mb so we make four of 200mb:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">ALTER DATABASE ADD STANDBY LOGFILE ('\/oracle\/oradata\/ORADEV\/standby_redo01.log') SIZE 200M;\nALTER DATABASE ADD STANDBY LOGFILE ('\/oracle\/oradata\/ORADEV\/standby_redo02.log') SIZE 200M;\nALTER DATABASE ADD STANDBY LOGFILE ('\/oracle\/oradata\/ORADEV\/standby_redo03.log') SIZE 200M;\nALTER DATABASE ADD STANDBY LOGFILE ('\/oracle\/oradata\/ORADEV\/standby_redo04.log') SIZE 200M;\n<\/pre>\n\n\n\n<p>Then we activate and change the following parameters in the primary: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enable force logging.<\/li>\n\n\n\n<li>Activation of the flashback (so that after a failover the database is created by itself without the need to restore).<\/li>\n\n\n\n<li>Set flashback retention in minutes and size as large as possible for the above.<\/li>\n\n\n\n<li>Activation of remote login in the password file.<\/li>\n\n\n\n<li>Activation of the broker.<\/li>\n\n\n\n<li>Definition of log_archive_config with the two tnsnames, will be needed if we want to have Data Guard in Maximum Availability mode. (it is optional).<\/li>\n\n\n\n<li>Activation of standby_file_management in auto, so that any file we create in our primary base is also created in the standby automatically.<\/li>\n\n\n\n<li>Definition of the local_listener with the hostname and the default port to make the services auto register.<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">ALTER DATABASE FORCE LOGGING;\n\nALTER SYSTEM SWITCH LOGFILE;\n\nALTER DATABASE FLASHBACK ON;\n\nALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET = 2880;\n\nALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 20G SCOPE=BOTH;\n\nALTER SYSTEM SET REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE SCOPE=BOTH;\n\nALTER SYSTEM SET DG_BROKER_START=TRUE;\n\nALTER SYSTEM SET log_archive_config='DG_CONFIG=(ORADEV,ORADEVDR)' SCOPE=BOTH;\n\nALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;\n\nALTER SYSTEM SET LOCAL_LISTENER='(ADDRESS=(PROTOCOL=tcp)(HOST=oracledev1)(PORT=1521))' SCOPE=BOTH;\n\nexit;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">The creation of the standby database<\/h3>\n\n\n\n<p>To create standby on <strong>standby server<\/strong> (oracledev2), we export it <strong>SID<\/strong> with the name of the instance and we build it <strong>pfile <\/strong>which we will need to make the base:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">export ORACLE_SID=oradev\n\nvi $ORACLE_HOME\/dbs\/initORADEVDR.ora\n\n\n<\/pre>\n\n\n\n<p>In the pfile we put only the base name (instance_number is for RAC):<\/p>\n\n\n\n<pre class=\"wp-block-code\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>*.db_name='oradev'\n*.instance_number='1'<\/code><\/pre>\n\n\n\n<p>Then we create the central folders where our database files will go if they don&#039;t already exist:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">mkdir -p \/oracle\/oradata\/\nmkdir -p \/oracle\/fast_recovery_area\/\nmkdir -p \/oracle\/app\/oracle\/admin\/oradev\/adump\n\nchown -R oracle:oinstall \/oracle\nchmod -R 775 \/oracle<\/pre>\n\n\n\n<p>We&#039;ll need to make one <strong>password file <\/strong>to be able to connect one base to another:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">orapwd file=$ORACLE_HOME\/dbs\/orapworadev password=\"Kwdikos1!\" entries=10 force=y<\/pre>\n\n\n\n<p>We connect with sqlplus to our standby and start the database in <strong>nomount <\/strong>with the pfile we created earlier:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">sqlplus \/ as sysdba\n<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">startup nomount pfile='$ORACLE_HOME\/dbs\/initORADEVDR.ora';<\/pre>\n\n\n\n<p>To transfer the base from primary to standby is done very easily by using it <strong>RMAN Duplicate<\/strong>.<\/p>\n\n\n\n<p>To do this we will connect to the RMAN tool from standby with as <strong>TARGET <\/strong>the primary basis and as <strong>AUXILIARY <\/strong>the standby with the code we gave in the password file:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">rman TARGET \"sys\/Kwdikos1!\"@ORADEV AUXILIARY \"sys\/Kwdikos1!\"@ORADEVDR;\n<\/pre>\n\n\n\n<p>After connecting we run the following script, in this we set the <strong>db_unique_name <\/strong>which must be different from the primary (oradevdr), the <strong>local_listener<\/strong> with the local hostname (oracledev2) and we can, if we want, change the names of the folders where our files coming from the primary will go (the subfolders will be created by itself).<\/p>\n\n\n\n<pre class=\"wp-block-code\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>DUPLICATE TARGET DATABASE\n  FOR STANDBY\n  FROM ACTIVE DATABASE\n  DORECOVER\n  SPFILE\n    SET db_unique_name='oradevdr' COMMENT 'Is standby'\n    SET log_archive_dest_2=''\n    SET db_file_name_convert='\/oracle\/oradata\/ORADEV\/','\/oracle\/oradata\/ORADEVDR\/'\n    SET control_files='\/oracle\/oradata\/ORADEVDR\/control01.ctl','\/oracle\/fast_recovery_area\/ORADEVDR\/control02.ctl'\n    SET local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=oracledev2)(PORT=1521))'\n    SET log_file_name_convert='\/oracle\/oradata\/ORADEV\/','\/oracle\/oradata\/ORADEVDR\/'\n    SET log_archive_dest_1='location=\/oracle\/fast_recovery_area\/ORADEVDR\/archivelog\/'\n##log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST'\n##  SET log_archive_config=''\n  NOFILENAMECHECK;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"701\" height=\"600\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-20.png\" alt=\"\" class=\"wp-image-3824\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-20.png 701w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-20-300x257.png 300w\" sizes=\"auto, (max-width: 701px) 100vw, 701px\" \/><figcaption class=\"wp-element-caption\">02<\/figcaption><\/figure>\n\n\n\n<p>After it is completed, we connect to the standby base that was just created and activate the flashback and the broker there as well as we did in the primary:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">sqlplus \/ as sysdba<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">ALTER DATABASE FLASHBACK ON;\n\nALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET = 2880;\n\nALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 20G SCOPE=BOTH;\n\nALTER SYSTEM SET DG_BROKER_START=TRUE;\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Enabling Data Guard<\/h3>\n\n\n\n<p>It&#039;s time to enable Data Guard through the broker.<\/p>\n\n\n\n<p>We connect to primary:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">dgmgrl \"sys\/Kwdikos1!\"@ORADEV<\/pre>\n\n\n\n<p>We make the configuration by adding the primary:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">create configuration dg_config as primary database is oradev connect identifier is oradev;<\/pre>\n\n\n\n<p>Then we add the standby:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">add database oradevdr as connect identifier is oradevdr maintained as physical;<\/pre>\n\n\n\n<p>And before activating it, check the configuration:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">show configuration;<\/pre>\n\n\n\n<p>If we have a warning for slow transfer and apply of the logs because we can set it up like a lab, we can raise the threshold so that it does not show us warnings for fewer seconds:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">edit database oradev set property 'TransportLagThreshold'='90';\nedit database oradevdr set property 'TransportLagThreshold'='90';\n\nedit database oradev set property 'TransportDisconnectedThreshold'='90';\nedit database oradevdr set property 'TransportDisconnectedThreshold'='90';\n\nedit database oradev set property 'ApplyLagThreshold'='90';\nedit database oradevdr set property 'ApplyLagThreshold'='90';<\/pre>\n\n\n\n<p>If everything is ok, activate the configuration:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">enable configuration;<\/pre>\n\n\n\n<p>With the following commands we can see the status of the databases and the configuration:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">show database oradev;\n\nshow database oradevdr;\n\nshow configuration verbose;<\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"693\" height=\"868\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-01.png\" alt=\"\" class=\"wp-image-3813\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-01.png 693w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-01-240x300.png 240w\" sizes=\"auto, (max-width: 693px) 100vw, 693px\" \/><figcaption class=\"wp-element-caption\">03<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How do we delete archivelogs from standby?<\/h2>\n\n\n\n<p>In order to automatically delete archivelogs that have been applied to standby, we must go to <strong>RMAN <\/strong>on both servers and change the policy with the following steps.<\/p>\n\n\n\n<p><em>*On each server it will keep the archivelogs it needs to keep the retention window we have defined.<\/em><\/p>\n\n\n\n<p>We connect to RMAN:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">rman target \/<\/pre>\n\n\n\n<p>We change the parameter:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;<\/pre>\n\n\n\n<p>We can also change the retention policy by adjusting how many days it will keep them:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;<\/pre>\n\n\n\n<p>We do the same process for the second server.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"660\" height=\"835\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/12\/dgo-01_02.png\" alt=\"\" class=\"wp-image-4762\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/12\/dgo-01_02.png 660w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/12\/dgo-01_02-237x300.png 237w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><figcaption class=\"wp-element-caption\">04<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Activation of Active Data Guard for read access on standby<\/h2>\n\n\n\n<p>To be able to run select in physical standby we should activate it <strong>Active Data Guard<\/strong>. The process is very simple but Oracle gives it as an extra license which means increased costs.<\/p>\n\n\n\n<p>To activate it we connect to the standby (oracledev2):<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">sqlplus \/ a sysdba<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">shutdown immediate;\n\nstartup mount;\n\nalter database open read only;\n\nalter database recover managed standby database using current logfile disconnect from session;<\/pre>\n\n\n\n<p>Then to see that it has definitely been activated as it should, we run the following query which should appear <code>OPEN_MODE: <strong>READ ONLY WITH APPLY<\/strong><\/code>:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">select open_mode from v$database;<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Testing Data Guard<\/h2>\n\n\n\n<p>Now if we make a table with entries in the primary:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">create table users (id int,name varchar(20));\ninsert into users values (1,'Nikos');\ninsert into users values (2,'Giorgos');\ninsert into users values (3,'Stratos');\ncommit;\n<\/pre>\n\n\n\n<p>And if we select from the standby, we will see that they have passed there immediately:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">select id,name,(select db_unique_name||'   ' ||database_role from v$database) as UniqueName_And_Role from users;<\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"438\" height=\"177\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-06.png\" alt=\"\" class=\"wp-image-3816\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-06.png 438w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-06-300x121.png 300w\" sizes=\"auto, (max-width: 438px) 100vw, 438px\" \/><figcaption class=\"wp-element-caption\">05<\/figcaption><\/figure>\n\n\n\n<p>If we try to create a file in our primary, we will see that it will automatically be created in the standby as well:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">create tablespace test datafile '\/oracle\/oradata\/ORADEV\/test.dbf' size 20m online;<\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"575\" height=\"217\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-12.png\" alt=\"\" class=\"wp-image-3818\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-12.png 575w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-12-300x113.png 300w\" sizes=\"auto, (max-width: 575px) 100vw, 575px\" \/><figcaption class=\"wp-element-caption\">06<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How do we switchover to standby?<\/h2>\n\n\n\n<p>To turn the standby base into primary, all we have to do is switchover through the broker:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">dgmgrl \"sys\/Kwdikos1!\"@ORADEV<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">switchover to oradevdr<\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"601\" height=\"269\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-03.png\" alt=\"\" class=\"wp-image-3814\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-03.png 601w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-03-300x134.png 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><figcaption class=\"wp-element-caption\">07<\/figcaption><\/figure>\n\n\n\n<p>Once completed, we will see that standby has become primary and the primary standby:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"206\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-04.png\" alt=\"\" class=\"wp-image-3815\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-04.png 602w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-04-300x103.png 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><figcaption class=\"wp-element-caption\">08<\/figcaption><\/figure>\n\n\n\n<p>Then we can go back with another switchover:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">switchover to oradev<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">How do we force failover on standby<\/h2>\n\n\n\n<p>In case we have lost communication with our primary, we can force failover so that our standby becomes primary:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">dgmgrl \"sys\/Kwdikos1!\"@ORADEVDR<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">failover to oradevdr<\/pre>\n\n\n\n<p>But when the database comes back and we see the configuration from the broker, we will see that the physical standby is disabled and that the database that was the former primary should become <strong>reset<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"639\" height=\"521\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-13.png\" alt=\"\" class=\"wp-image-3819\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-13.png 639w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-13-300x245.png 300w\" sizes=\"auto, (max-width: 639px) 100vw, 639px\" \/><figcaption class=\"wp-element-caption\">09<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">How to restore the primary base after failover<\/h3>\n\n\n\n<p>To build it, we must first connect to the primary and manually convert it to physical standby:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">sqlplus \/ as sysdba<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">alter database convert to physical standby;\n\nshutdown immediate;\n\nstartup mount;\n<\/pre>\n\n\n\n<p>Then through the broker we reset it:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">dgmgrl \"sys\/Kwdikos1!\"@ORADEVDR<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">reinstate database oradev<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">How do we make a standby snapshot for testing?<\/h2>\n\n\n\n<p>We can if we want to convert the standby base to <strong>snapshot standby<\/strong> which has the read-write capability. So we can do tests on new releases that we want to run on the base and then turn the base to physical standby by reverting the changes. However, we should know that as long as the base is snapshot standby, it is not updated.<\/p>\n\n\n\n<p>So we connect to the standby base:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">dgmgrl \"sys\/Kwdikos1!\"@ORADEVDR<\/pre>\n\n\n\n<p>And we convert it to Snapshot Standby:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">convert database oradevdr to snapshot standby;\nexit;<\/pre>\n\n\n\n<p>When the change is complete we can try passing changes to a table:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">insert into users values (4,'Maria');\ncommit;\n\nselect id,name,(select db_unique_name||'   ' ||database_role from v$database) as UniqueName_And_Role from users;\n<\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"393\" height=\"197\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-11.png\" alt=\"\" class=\"wp-image-3817\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-11.png 393w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-11-300x150.png 300w\" sizes=\"auto, (max-width: 393px) 100vw, 393px\" \/><figcaption class=\"wp-element-caption\">10<\/figcaption><\/figure>\n\n\n\n<p>And as soon as we turn the base to physical standby we will see that these changes have been lost:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">dgmgrl \"sys\/Kwdikos1!\"@ORADEV<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">convert database oradevdr to physical standby;\nexit;<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">select id,name,(select db_unique_name||'   ' ||database_role from v$database) as UniqueName_And_Role from users;<\/pre>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"438\" height=\"177\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-06.png\" alt=\"\" class=\"wp-image-3816\" style=\"width:438px;height:177px\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-06.png 438w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-06-300x121.png 300w\" sizes=\"auto, (max-width: 438px) 100vw, 438px\" \/><figcaption class=\"wp-element-caption\">11<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Useful monitoring queries<\/h2>\n\n\n\n<p>By running the following query on the primary, we see the difference in the sent and applied logs between the primary and the standby:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">SELECT \nARCS.DEST_ID,\nLAST_SEQUENCE_RECEIVED,\nLAST_SEQUENCE_APPLIED,\nLAST_SEQUENCE_RECEIVED-MAX_SEQUENCE RECEIVED_DIFFERENCE,\nLAST_SEQUENCE_APPLIED-LAST_SEQUENCE_RECEIVED APPLIED_DIFFERENCE\nFROM\n(SELECT DEST_ID, max(SEQUENCE#) LAST_SEQUENCE_RECEIVED\nFROM V$ARCHIVED_LOG where resetlogs_change#=(select resetlogs_change# from v$database)\nGROUP BY DEST_ID) ARCS\nLEFT JOIN\n(SELECT DEST_ID, max(SEQUENCE#) LAST_SEQUENCE_APPLIED\nFROM V$ARCHIVED_LOG\nwhere APPLIED='YES' AND DEST_ID not in (0,1) and resetlogs_change#=(select resetlogs_change# from v$database)\nGROUP BY DEST_ID\nUNION\nSELECT 1 DEST_ID,max(SEQUENCE#) LAST_SEQUENCE_APPLIED\nFROM V$LOG_HISTORY\nwhere resetlogs_change#=(select resetlogs_change# from v$database)\n) APPLIED ON APPLIED.DEST_ID=ARCS.DEST_ID\n,\n(SELECT max(SEQUENCE#) MAX_SEQUENCE\nFROM V$LOG_HISTORY\nwhere resetlogs_change#=(select resetlogs_change# from v$database))MAX\nWHERE 1=1\n--and LAST_SEQUENCE_RECEIVED-MAX_SEQUENCE &lt; -1\n--or LAST_SEQUENCE_APPLIED-LAST_SEQUENCE_RECEIVED &lt; -1\n;<\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"721\" height=\"116\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/12\/dgrp-00.png\" alt=\"\" class=\"wp-image-5091\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/12\/dgrp-00.png 721w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/12\/dgrp-00-300x48.png 300w\" sizes=\"auto, (max-width: 721px) 100vw, 721px\" \/><figcaption class=\"wp-element-caption\">12<\/figcaption><\/figure>\n\n\n\n<p>With the following query on standby we see what status the logs are in (APPLYING_LOG):<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">select process, status, thread#, sequence#, block#, blocks\n  from gv$managed_standby; #APPLYING_LOG \/ WRITING<\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"511\" height=\"210\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-05.png\" alt=\"\" class=\"wp-image-3820\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-05.png 511w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/09\/dgo-05-300x123.png 300w\" sizes=\"auto, (max-width: 511px) 100vw, 511px\" \/><figcaption class=\"wp-element-caption\">13<\/figcaption><\/figure>\n\n\n\n<p>Some useful information about the base can be seen through the broker:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">show database verbose 'ORADEVDR';\n\nshow database 'ORADEVDR' statusreport; \n\nshow database verbose 'ORADEVDR' LogXptStatus;\n\nshow database verbose 'ORADEVDR' InconsistentLogXptProps\n\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">How do we stop Data Guard?<\/h2>\n\n\n\n<p>If we want to stop the transport or the apply of the logs, we can do the following:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">edit database oradev set state='TRANSPORT-OFF';\n\nedit database oradev set state='TRANSPORT-ON';\n\nedit database oradevdr set state='APPLY-OFF';\n\nedit database oradevdr set state='APPLY-ON';<\/pre>\n\n\n\n<p>If we want to remove Data Guard completely then:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">dgmgrl \"sys\/Kwdikos1!\"@ORADEV<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">disable configuration;\nremove configuration;\nexit;<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">sqplus \/ as sysdba<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">alter system set dg_broker_start=false;<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Sources:<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.oracle.com\/cd\/B19306_01\/server.102\/b14230\/cli.htm\" target=\"_blank\" rel=\"noreferrer noopener\">Scenarios Using the DGMGRL Command-Line Interface<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.oracle.com\/technical-resources\/articles\/smiley-fsfo.html?fbclid=IwAR3m0ITdmhQAfDzaDWYWwp6maUHT6pmVmL3YU7lxgLkUaoh18mfuBbTqfRs\" target=\"_blank\" rel=\"noreferrer noopener\">Guide to Oracle Data Guard Fast-Start Failover<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>In this article we will see step by step how to install Oracle Data Guard as Physical Standby on Unix. By using it, we have the possibility that changes made in the primary base are automatically transferred to another standby base. The standby base during this process is only accessible by activating [...]<\/p>","protected":false},"author":1,"featured_media":704,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,16],"tags":[67,29,66,5,30,492],"class_list":["post-3810","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-oracle-db","tag-data-guard","tag-databases","tag-disaster-recovery","tag-oracle-database","tag-rdbms","tag-replication"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03c4\u03bf Oracle Data Guard \u03c9\u03c2 Physical Standby \u03b3\u03b9\u03b1 Disaster Recovery - DataPlatform.gr<\/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:\/\/www.dataplatform.gr\/en\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03c4\u03bf Oracle Data Guard \u03c9\u03c2 Physical Standby \u03b3\u03b9\u03b1 Disaster Recovery - DataPlatform.gr\" \/>\n<meta property=\"og:description\" content=\"\u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03b2\u03ae\u03bc\u03b1 \u03b2\u03ae\u03bc\u03b1 \u03c0\u03c9\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03c4\u03bf Oracle Data Guard \u03c9\u03c2 Physical Standby \u03c3\u03b5 Unix. \u039c\u03b5 \u03c4\u03b7 \u03c7\u03c1\u03ae\u03c3\u03b7 \u03c4\u03bf\u03c5 \u03ad\u03c7\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7 \u03b4\u03c5\u03bd\u03b1\u03c4\u03cc\u03c4\u03b7\u03c4\u03b1 \u03cc\u03c4\u03b9 \u03b1\u03bb\u03bb\u03b1\u03b3\u03ad\u03c2 \u03b3\u03af\u03bd\u03bf\u03bd\u03c4\u03b1\u03b9 \u03c3\u03c4\u03b7\u03bd primary \u03b2\u03ac\u03c3\u03b7 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03bd\u03c4\u03b1\u03b9 \u03b1\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b1 \u03c3\u03b5 \u03ac\u03bb\u03bb\u03b7 standby \u03b2\u03ac\u03c3\u03b7. \u0397 standby \u03b2\u03ac\u03c3\u03b7 \u03ba\u03b1\u03c4\u03ac \u03c4\u03b7\u03bd \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 \u03b1\u03c5\u03c4\u03ae \u03b4\u03b5\u03bd \u03b5\u03af\u03bd\u03b1\u03b9 \u03c0\u03c1\u03bf\u03c3\u03b2\u03ac\u03c3\u03b9\u03bc\u03ae \u03c0\u03b1\u03c1\u03ac \u03bc\u03cc\u03bd\u03bf \u03bc\u03b5 \u03c4\u03b7\u03bd \u03b5\u03bd\u03b5\u03c1\u03b3\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dataplatform.gr\/en\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/\" \/>\n<meta property=\"og:site_name\" content=\"DataPlatform.gr\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dataplatform.gr\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-15T05:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-09T20:13:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Stratos Matzouranis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stratos Matzouranis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\\\/\"},\"author\":{\"name\":\"Stratos Matzouranis\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\"},\"headline\":\"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03c4\u03bf Oracle Data Guard \u03c9\u03c2 Physical Standby \u03b3\u03b9\u03b1 Disaster Recovery\",\"datePublished\":\"2021-12-15T05:00:00+00:00\",\"dateModified\":\"2024-03-09T20:13:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\\\/\"},\"wordCount\":308,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_oracle.png\",\"keywords\":[\"Data Guard\",\"Databases\",\"Disaster Recovery\",\"Oracle Database\",\"RDBMS\",\"Replication\"],\"articleSection\":[\"Databases\",\"Oracle Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\\\/\",\"name\":\"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03c4\u03bf Oracle Data Guard \u03c9\u03c2 Physical Standby \u03b3\u03b9\u03b1 Disaster Recovery - DataPlatform.gr\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_oracle.png\",\"datePublished\":\"2021-12-15T05:00:00+00:00\",\"dateModified\":\"2024-03-09T20:13:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_oracle.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_oracle.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Oracle Database\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/oracle-db\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03c4\u03bf Oracle Data Guard \u03c9\u03c2 Physical Standby \u03b3\u03b9\u03b1 Disaster Recovery\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"name\":\"dataplatform.gr - Sky is not the limit!\",\"description\":\"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dataplatform.gr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\",\"name\":\"dataplatform.gr\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"width\":322,\"height\":139,\"caption\":\"dataplatform.gr\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dataplatform.gr\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dataplatform-gr\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\",\"name\":\"Stratos Matzouranis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"caption\":\"Stratos Matzouranis\"},\"sameAs\":[\"https:\\\/\\\/www.dataplatform.gr\"],\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/en\\\/author\\\/stratos-matzouranis\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03c4\u03bf Oracle Data Guard \u03c9\u03c2 Physical Standby \u03b3\u03b9\u03b1 Disaster Recovery - DataPlatform.gr","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:\/\/www.dataplatform.gr\/en\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/","og_locale":"en_US","og_type":"article","og_title":"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03c4\u03bf Oracle Data Guard \u03c9\u03c2 Physical Standby \u03b3\u03b9\u03b1 Disaster Recovery - DataPlatform.gr","og_description":"\u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03b2\u03ae\u03bc\u03b1 \u03b2\u03ae\u03bc\u03b1 \u03c0\u03c9\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03c4\u03bf Oracle Data Guard \u03c9\u03c2 Physical Standby \u03c3\u03b5 Unix. \u039c\u03b5 \u03c4\u03b7 \u03c7\u03c1\u03ae\u03c3\u03b7 \u03c4\u03bf\u03c5 \u03ad\u03c7\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7 \u03b4\u03c5\u03bd\u03b1\u03c4\u03cc\u03c4\u03b7\u03c4\u03b1 \u03cc\u03c4\u03b9 \u03b1\u03bb\u03bb\u03b1\u03b3\u03ad\u03c2 \u03b3\u03af\u03bd\u03bf\u03bd\u03c4\u03b1\u03b9 \u03c3\u03c4\u03b7\u03bd primary \u03b2\u03ac\u03c3\u03b7 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03bf\u03bd\u03c4\u03b1\u03b9 \u03b1\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b1 \u03c3\u03b5 \u03ac\u03bb\u03bb\u03b7 standby \u03b2\u03ac\u03c3\u03b7. \u0397 standby \u03b2\u03ac\u03c3\u03b7 \u03ba\u03b1\u03c4\u03ac \u03c4\u03b7\u03bd \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 \u03b1\u03c5\u03c4\u03ae \u03b4\u03b5\u03bd \u03b5\u03af\u03bd\u03b1\u03b9 \u03c0\u03c1\u03bf\u03c3\u03b2\u03ac\u03c3\u03b9\u03bc\u03ae \u03c0\u03b1\u03c1\u03ac \u03bc\u03cc\u03bd\u03bf \u03bc\u03b5 \u03c4\u03b7\u03bd \u03b5\u03bd\u03b5\u03c1\u03b3\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 [&hellip;]","og_url":"https:\/\/www.dataplatform.gr\/en\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/","og_site_name":"DataPlatform.gr","article_publisher":"https:\/\/www.facebook.com\/dataplatform.gr\/","article_published_time":"2021-12-15T05:00:00+00:00","article_modified_time":"2024-03-09T20:13:05+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png","type":"image\/png"}],"author":"Stratos Matzouranis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stratos Matzouranis","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/#article","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/"},"author":{"name":"Stratos Matzouranis","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf"},"headline":"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03c4\u03bf Oracle Data Guard \u03c9\u03c2 Physical Standby \u03b3\u03b9\u03b1 Disaster Recovery","datePublished":"2021-12-15T05:00:00+00:00","dateModified":"2024-03-09T20:13:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/"},"wordCount":308,"commentCount":2,"publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png","keywords":["Data Guard","Databases","Disaster Recovery","Oracle Database","RDBMS","Replication"],"articleSection":["Databases","Oracle Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/","url":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/","name":"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03c4\u03bf Oracle Data Guard \u03c9\u03c2 Physical Standby \u03b3\u03b9\u03b1 Disaster Recovery - DataPlatform.gr","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/#primaryimage"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png","datePublished":"2021-12-15T05:00:00+00:00","dateModified":"2024-03-09T20:13:05+00:00","breadcrumb":{"@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/#primaryimage","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.dataplatform.gr\/pos-kanoyme-egkatastasi-to-oracle-data-guard-os-physical-standby-g\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae","item":"https:\/\/www.dataplatform.gr\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/www.dataplatform.gr\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Oracle Database","item":"https:\/\/www.dataplatform.gr\/category\/databases\/oracle-db\/"},{"@type":"ListItem","position":4,"name":"\u03a0\u03ce\u03c2 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b5\u03b3\u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u03c4\u03bf Oracle Data Guard \u03c9\u03c2 Physical Standby \u03b3\u03b9\u03b1 Disaster Recovery"}]},{"@type":"WebSite","@id":"https:\/\/www.dataplatform.gr\/#website","url":"https:\/\/www.dataplatform.gr\/","name":"dataplatform.gr - Sky is not the limit!","description":"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.","publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dataplatform.gr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dataplatform.gr\/#organization","name":"dataplatform.gr","url":"https:\/\/www.dataplatform.gr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","width":322,"height":139,"caption":"dataplatform.gr"},"image":{"@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dataplatform.gr\/","https:\/\/www.linkedin.com\/company\/dataplatform-gr\/"]},{"@type":"Person","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf","name":"Stratos Matzouranis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","caption":"Stratos Matzouranis"},"sameAs":["https:\/\/www.dataplatform.gr"],"url":"https:\/\/www.dataplatform.gr\/en\/author\/stratos-matzouranis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/3810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/comments?post=3810"}],"version-history":[{"count":7,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/3810\/revisions"}],"predecessor-version":[{"id":5686,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/3810\/revisions\/5686"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media\/704"}],"wp:attachment":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media?parent=3810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/categories?post=3810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/tags?post=3810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}