{"id":15128,"date":"2020-03-05T08:53:40","date_gmt":"2020-03-05T08:53:40","guid":{"rendered":"https:\/\/dbtut.com\/?p=15128"},"modified":"2020-03-05T08:59:59","modified_gmt":"2020-03-05T08:59:59","slug":"oracle-snapshot-standby-database","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/","title":{"rendered":"Oracle Snapshot Standby Database"},"content":{"rendered":"<p>You can find the below informations about Snapshot Standby Database in this article.<\/p>\n<ul>\n<li>What is Oracle Snapshot Standby Database?<\/li>\n<li>Convert Physical Standby to Snapshot Standby<\/li>\n<li>Convert Physical Standby to Snapshot Standby using Dgmgrl<\/li>\n<li>Convert Snapshot Standby Back to Physical Standby<\/li>\n<\/ul>\n<h3>What is Oracle Snapshot Standby Database?<\/h3>\n<p>Snapshot Standby Database is an updatable database created from Physical Standby Database.<\/p>\n<p>There is redo flow to Snapshot Standby Database, but there is no redo apply.<\/p>\n<p>As soon as the Physical Standby Database is converted to Snapshot Standby Database, an implicit restore point is created and Flashback logs are activated.<\/p>\n<p>Besides being a nice feature to be updated, Snapshot Standby Database also has dangerous points.<\/p>\n<h4>Dangerous Points of Snapshot Database<\/h4>\n<ul>\n<li>Suppose one of the redo log files is corrupted in Snapshot Standby Database. In this case, we cannot know what the problem is until we convert it to a physical standby database and redo-apply it with the MRP process. If something happens to our Primary database at this moment, we will have a definite data loss because there is no other place to get that log.<\/li>\n<li>\u00a0If Flashback Logs are corrupted or deleted, we cannot return to Physical Standby Database.<\/li>\n<li>\u00a0Let&#8217;s say something happens to Primary Database while Standby Database is in Snapshot mode. In this case, it will be rewound with Flashback logs first. Since it will run the archives later, it means an interruption for as much as this time.<\/li>\n<\/ul>\n<h4>Physical Standby Database cannot be converted to Snapshot Standby Database in the following cases;<\/h4>\n<ul>\n<li>If Maximum Protection mode is used and there is only one Standby Database in the Data Guard Environment. The reason is that when there is only one Standby Database, it must be sync with Primary as much as possible so that it can be Primary quickly if a Failover occurs.<\/li>\n<li>\u00a0If it is the Standby Database where Fast-Start Failover will be made.<\/li>\n<\/ul>\n<h3>Convert Physical Standby to Snapshot Standby<\/h3>\n<p><strong>Step1:<\/strong><\/p>\n<p>Some checks are made on the Primary and Standby sides.<\/p>\n<pre class=\"lang:default decode:true \">[Standby-1]\nSQL&gt; select database_role from v$database;\n\nDATABASE_ROLE\n----------------\nPHYSICAL STANDBY\n\nSQL&gt; select flashback_on from v$database;\n\nFLASHBACK_ON\n------------------\nNO\n\nSQL&gt; show parameter DB_FLASHBACK_RETENTION_TARGET\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ndb_flashback_retention_target        integer     1440\nSQL&gt; show parameter DB_RECOVERY_FILE_DEST\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ndb_recovery_file_dest                string      +FRA\ndb_recovery_file_dest_size           big integer 10G\nSQL&gt; select file_type,number_of_files,percent_space_used from v$recovery_area_usage;\n\nFILE_TYPE            NUMBER_OF_FILES PERCENT_SPACE_USED\n-------------------- --------------- ------------------\nCONTROL FILE                       0                  0\nREDO LOG                           0                  0\nARCHIVED LOG                     333              88.24\nBACKUP PIECE                       0                  0\nIMAGE COPY                         0                  0\nFLASHBACK LOG                      0                  0\nFOREIGN ARCHIVED LOG               0                  0\n\n7 rows selected.<\/pre>\n<pre class=\"lang:default decode:true \">[Primary-1]\nSQL&gt; select database_role from v$database;\n\nDATABASE_ROLE\n----------------\nPRIMARY\n\nSQL&gt; select flashback_on from v$database;\n\nFLASHBACK_ON\n------------------\nNO\n\nSQL&gt; show parameter DB_FLASHBACK_RETENTION_TARGET\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ndb_flashback_retention_target        integer     1440\nSQL&gt; show parameter DB_RECOVERY_FILE_DEST\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ndb_recovery_file_dest                string      +FRA\ndb_recovery_file_dest_size           big integer 40G\nSQL&gt; select file_type,number_of_files,percent_space_used from v$recovery_area_usage;\n\nFILE_TYPE            NUMBER_OF_FILES PERCENT_SPACE_USED\n-------------------- --------------- ------------------\nCONTROL FILE                       0                  0\nREDO LOG                           0                  0\nARCHIVED LOG                     338              22.15\nBACKUP PIECE                       0                  0\nIMAGE COPY                         0                  0\nFLASHBACK LOG                      0                  0\nFOREIGN ARCHIVED LOG               0                  0\n\n7 rows selected.\n<\/pre>\n<p><strong>Step2:<\/strong><\/p>\n<p>Stop the Redo-Apply on the Standby.<\/p>\n<pre class=\"lang:default decode:true \">[Standby-1]\nSQL&gt; alter database recover managed standby database cancel;\n\nDatabase altered.<\/pre>\n<p><strong>Step3:<\/strong><\/p>\n<p>Convert Physical Standby to Snapshot Standby.<\/p>\n<pre class=\"lang:default decode:true \">[Standby-1]\nSQL&gt; alter database convert to snapshot standby;\n\nDatabase altered.\n<\/pre>\n<p><strong>Step4:<\/strong><\/p>\n<p>Check the databse role and Flashback status.<\/p>\n<pre class=\"lang:default decode:true \">[Standby-1]\nSQL&gt; select database_role from v$database;\n\nDATABASE_ROLE\n----------------\nSNAPSHOT STANDBY<\/pre>\n<pre class=\"lang:default decode:true \">[Primary-1]\nSQL&gt; select flashback_on from v$database;\n\nFLASHBACK_ON\n------------------\nNO<\/pre>\n<pre class=\"lang:default decode:true \">[Standby-1]\nSQL&gt; select flashback_on from v$database;\n\nFLASHBACK_ON\n------------------\nRESTORE POINT ONLY<\/pre>\n<p><strong>Step5:<\/strong><\/p>\n<p>The created restore point&#8217;s storage size can be seen.<\/p>\n<pre class=\"lang:default decode:true \">[Standby-1]\nSQL&gt; set linesize 500\nSQL&gt; column name format a50\nSQL&gt; select name, storage_size from v$restore_point;\n\nNAME                                               STORAGE_SIZE\n-------------------------------------------------- ------------\nSNAPSHOT_STANDBY_REQUIRED_01\/05\/2017 14:30:05         104857600<\/pre>\n<p><strong>Step6:<\/strong><\/p>\n<p>Check databases modes.<\/p>\n<pre class=\"lang:default decode:true \">[Primary-1]\nSQL&gt; select open_mode from v$database;\n\nOPEN_MODE\n--------------------\nREAD WRITE<\/pre>\n<pre class=\"lang:default decode:true \">[Standby-1]\nSQL&gt; select open_mode from v$database;\n\nOPEN_MODE\n--------------------\nMOUNTED\n<\/pre>\n<p><strong>Step7:<\/strong><\/p>\n<p>Check if the flashback logs start to created.<\/p>\n<pre class=\"lang:default decode:true \">[Standby-1]\nSQL&gt; select file_type,number_of_files,percent_space_used from v$recovery_area_usage;\n\nFILE_TYPE            NUMBER_OF_FILES PERCENT_SPACE_USED\n-------------------- --------------- ------------------\nCONTROL FILE                       0                  0\nREDO LOG                           0                  0\nARCHIVED LOG                     334              88.34\nBACKUP PIECE                       0                  0\nIMAGE COPY                         0                  0\nFLASHBACK LOG                      4               1.99\nFOREIGN ARCHIVED LOG               0                  0\n\n7 rows selected.<\/pre>\n<pre class=\"lang:default decode:true \">[Primary-1]\nSQL&gt; select file_type,number_of_files,percent_space_used from v$recovery_area_usage;\n\nFILE_TYPE            NUMBER_OF_FILES PERCENT_SPACE_USED\n-------------------- --------------- ------------------\nCONTROL FILE                       0                  0\nREDO LOG                           0                  0\nARCHIVED LOG                     339              22.17\nBACKUP PIECE                       0                  0\nIMAGE COPY                         0                  0\nFLASHBACK LOG                      0                  0\nFOREIGN ARCHIVED LOG               0                  0\n\n7 rows selected.<\/pre>\n<p><strong>Step8:<\/strong><\/p>\n<p>Change Standby Database Mode as Open.<\/p>\n<pre class=\"lang:default decode:true \">[Standby-1]\nSQL&gt; alter database open;\n\nDatabase altered.\n\nSQL&gt; select status from gv$instance;\n\nSTATUS\n------------\nOPEN\nMOUNTED<\/pre>\n<pre class=\"lang:default decode:true \">[Standby-2]\nSQL&gt; alter database open;\n\nDatabase altered.\n\nSQL&gt; select status from gv$instance;\n\nSTATUS\n------------\nOPEN\nOPEN<\/pre>\n<p><strong>Step9:<\/strong><\/p>\n<p>Check the Log Sequence numbers for both sides.<\/p>\n<pre class=\"lang:default decode:true \">[Primary-1-2 &amp; Standby-1-2]\nSQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n           244          1\n           104          2<\/pre>\n<p><strong>Step10:<\/strong><\/p>\n<p>Create a new table.<\/p>\n<pre class=\"lang:default decode:true \">[Standby-1]\nSQL&gt; select table_name from dba_tables where owner='HR';\n\nTABLE_NAME\n------------------------------\nJOB_HISTORY\nEMPLOYEES\nJOBS\nLOCATIONS\nREGIONS\nDEPARTMENTS\nCOUNTRIES\n\n7 rows selected.\n\nSQL&gt; create table test.jobs_yedek as select * from hr.jobs;\n\nTable created.\n\nSQL&gt; select count(*) from test.jobs_yedek;\n\n  COUNT(*)\n----------\n        19<\/pre>\n<pre class=\"lang:default decode:true \">[Standby-2]\nSQL&gt; select count(*) from test.jobs_yedek;\n\n  COUNT(*)\n----------\n        19<\/pre>\n<p><strong>Step11:<\/strong><\/p>\n<p>On the primary side, perform log switch operation on each instance and to check whether Redo-Transport is working properly.<\/p>\n<pre class=\"lang:default decode:true \">[Primary-1]\nSQL&gt; alter system switch logfile;\n\nSystem altered.<\/pre>\n<pre class=\"lang:default decode:true \">[Primary-2]\nSQL&gt; alter system switch logfile;\n\nSystem altered.<\/pre>\n<pre class=\"lang:default decode:true \">[Primary-1-2 &amp; Standby-1-2]\nSQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n           245          1\n           105          2<\/pre>\n<h3>Convert Physical Standby to Snapshot Standby using Dgmgrl<\/h3>\n<p><strong>Step1:<\/strong><\/p>\n<p>Check the Configuration.<\/p>\n<pre class=\"lang:default decode:true\">DGMGRL&gt; show configuration\n\nConfiguration - DRSolution\n\n  Protection Mode: MaxPerformance\n  Members:\n  primary  - Primary database\n    prmyFS   - Far sync instance \n      physical - Physical standby database \n      snapshot - Physical standby database \n      logical  - Logical standby database \n      logical2 - Physical standby database \n\n  Members Not Receiving Redo:\n  physclFS - Far sync instance \n\nFast-Start Failover: DISABLED\n\nConfiguration Status:\nSUCCESS   (status updated 49 seconds ago)\n<\/pre>\n<p><strong>Step2:<\/strong><\/p>\n<p>Convert Physical Standby to Snapshot Standby using dgmgrl.<\/p>\n<pre class=\"lang:default decode:true \">DGMGRL&gt; convert database snapshot to snapshot standby;\nConverting database \"snapshot\" to a Snapshot Standby database, please wait...\nDatabase \"snapshot\" converted successfully<\/pre>\n<p><strong>Step3:<\/strong><\/p>\n<p>Check the configuration again.<\/p>\n<pre class=\"lang:default decode:true \">DGMGRL&gt; show configuration\n\nConfiguration - DRSolution\n\n  Protection Mode: MaxPerformance\n  Members:\n  primary  - Primary database\n    prmyFS   - Far sync instance \n      physical - Physical standby database \n      snapshot - Snapshot standby database \n      logical  - Logical standby database \n      logical2 - Physical standby database \n\n  Members Not Receiving Redo:\n  physclFS - Far sync instance \n\nFast-Start Failover: DISABLED\n\nConfiguration Status:\nSUCCESS   (status updated 49 seconds ago)<\/pre>\n<p><strong>Step4:<\/strong><\/p>\n<p>Check the Flashback status.<\/p>\n<pre class=\"lang:default decode:true \">[Snapshot - 07-04-2017 14:04:19] SQL&gt; select flashback_on from v$database;\n\nFLASHBACK_ON\n------------------\nRESTORE POINT ONLY<\/pre>\n<p><strong>Step5:<\/strong><\/p>\n<p>Check the database role.<\/p>\n<pre class=\"lang:default decode:true \">[Snapshot - 07-04-2017 14:04:31] SQL&gt; select open_mode, database_role from v$database;\n\nOPEN_MODE            DATABASE_ROLE\n-------------------- ----------------\nREAD WRITE           SNAPSHOT STANDBY<\/pre>\n<p>Sometimes, when it is checked from the Broker after this convert operation, the following warnings about the configuration can be received. A few minutes after these warnings, errors appear to solved on their own without any intervention from the DBA. The cause and solution of the error is below.<\/p>\n<p><span style=\"color: #ff0000;\"><em>ORA-16778: redo transport error for one or more databases<\/em><\/span><\/p>\n<p><strong>Step1:<\/strong><\/p>\n<p>Convert Physical Standby to Snapshot Standby using dgmgrl.<\/p>\n<pre class=\"lang:default decode:true \">DGMGRL&gt; convert database snapshot to snapshot standby;\nConverting database \"snapshot\" to a Snapshot Standby database, please wait...\nDatabase \"snapshot\" converted successfully<\/pre>\n<p><strong>Step2:<\/strong><\/p>\n<p>Check the configuration.<\/p>\n<pre class=\"lang:default decode:true\">DGMGRL&gt; show configuration\n\nConfiguration - DRSolution\n\n  Protection Mode: MaxPerformance\n  Members:\n  primary  - Primary database\n    prmyFS   - Far sync instance \n      Error: ORA-16778: redo transport error for one or more databases\n\n      physical - Physical standby database \n      snapshot - Snapshot standby database \n      logical  - Logical standby database \n      logical2 - Logical standby database \n\n  Members Not Receiving Redo:\n  physclFS - Far sync instance \n\nFast-Start Failover: DISABLED\n\nConfiguration Status:\nERROR   (status updated 25 seconds ago)<\/pre>\n<p><strong>Step3:<\/strong><\/p>\n<p>Check the archives&#8217; status in Primary and Snapshot.<\/p>\n<pre class=\"lang:default decode:true \">[Primary - 10-04-2017 11:19:16] SQL&gt; select max(sequence#) from v$archived_log group by thread#;\n\nMAX(SEQUENCE#)\n--------------\n           869\n\n[Snapshot - 10-04-2017 11:19:16] SQL&gt; select max(sequence#),applied from v$archived_log group by thread#,applied;\n\nMAX(SEQUENCE#) APPLIED\n-------------- ---------\n           868 YES<\/pre>\n<p><strong>Step4:<\/strong><\/p>\n<p>Check if the logs are transferred to snapshot by performing the Log Switch.<\/p>\n<pre class=\"lang:default decode:true \">[Primary - 10-04-2017 11:19:18] SQL&gt; alter system switch logfile;\n\nSystem altered.\n\n[Primary - 10-04-2017 11:19:58] SQL&gt; select max(sequence#) from v$archived_log group by thread#;\n\nMAX(SEQUENCE#)\n--------------\n           870\n\n[Snapshot - 10-04-2017 11:19:36] SQL&gt; \/\n\nMAX(SEQUENCE#) APPLIED\n-------------- ---------\n           868 YES<\/pre>\n<p><strong>Note:<\/strong> We have seen that the logs are not transferred to the Snapshot database.<\/p>\n<p><strong>Step5:<\/strong><\/p>\n<p>Check RedoRoutes from Primary Far SYNC.<\/p>\n<pre class=\"lang:default decode:true \">DGMGRL&gt; show far_sync 'prmyFS' redoroutes\n  RedoRoutes = '(primary:physical,snapshot,logical,logical2 ASYNC)'\n\n\nDGMGRL&gt; show configuration\n\nConfiguration - DRSolution\n\n  Protection Mode: MaxPerformance\n  Members:\n  primary  - Primary database\n    prmyFS   - Far sync instance \n      Error: ORA-16778: redo transport error for one or more databases\n\n      physical - Physical standby database \n      snapshot - Snapshot standby database \n        Warning: ORA-16857: standby disconnected from redo source for longer than specified threshold\n\n      logical  - Logical standby database \n      logical2 - Logical standby database \n\n  Members Not Receiving Redo:\n  physclFS - Far sync instance \n\nFast-Start Failover: DISABLED\n\nConfiguration Status:\nERROR   (status updated 35 seconds ago)<\/pre>\n<p>There is no error related to Redo Transport. When the error is investigated, it is understood that it is caused by the &#8220;TransportDisconnectedThreshold&#8221; and &#8220;ReopenSecs&#8221; parameters.<\/p>\n<p><strong>TransportDisconnectedThreshold:<\/strong> Indicates that the last communication with the Primary has exceeded the specified threshold. After this exceed, Primary cannot send redos to this location. Default is 30 seconds.<\/p>\n<p><strong>ReopenSecs:<\/strong> If one of the destinations where the Redos will be sent fails, it determines how many seconds later it will try to send. It is 300 seconds in the default.<\/p>\n<p><strong>MaxFailure:<\/strong> It determine maxfailure count. If you set 3 , it tries 3 times to send redos even if it has failed. Default is 0. So it tries endless times.<\/p>\n<pre class=\"lang:default decode:true \">DGMGRL&gt; show database primary TransportDisconnectedThreshold\n  TransportDisconnectedThreshold = '30'\nDGMGRL&gt; show database primary MaxFailure\n  MaxFailure = '0'\nDGMGRL&gt; show database primary ReopenSecs\n  ReopenSecs = '300'\n\nDGMGRL&gt; show far_sync 'prmyFS' TransportDisconnectedThreshold\n  TransportDisconnectedThreshold = '30'\nDGMGRL&gt; show far_sync 'prmyFS' MaxFailure\n  MaxFailure = '0'\nDGMGRL&gt; show far_sync 'prmyFS' ReopenSecs\n  ReopenSecs = '300'<\/pre>\n<p><strong>Step7:<\/strong><\/p>\n<p>The ReopenSecs parameter is reduced to 30 seconds. After this parameter is set, sending logs is started.<\/p>\n<p>In addition, the TransportDisconnectedThreshold parameter is set to 300 seconds so that no errors are received.<\/p>\n<pre class=\"lang:default decode:true \">DGMGRL&gt; edit database snapshot set property 'ReopenSecs'=30;\nProperty \"ReopenSecs\" updated\n\nDGMGRL&gt; edit database snapshot set property TransportDisconnectedThreshold=300;\nProperty \"transportdisconnectedthreshold\" updated<\/pre>\n<p><strong>Step8:<\/strong><\/p>\n<p>Check the configuration again.<\/p>\n<pre class=\"lang:default decode:true \">DGMGRL&gt; show configuration\n\nConfiguration - DRSolution\n\n  Protection Mode: MaxPerformance\n  Members:\n  primary  - Primary database\n    prmyFS   - Far sync instance \n      physical - Physical standby database \n      snapshot - Snapshot standby database \n      logical  - Logical standby database \n      logical2 - Logical standby database \n\n  Members Not Receiving Redo:\n  physclFS - Far sync instance \n\nFast-Start Failover: DISABLED\n\nConfiguration Status:\nSUCCESS   (status updated 7 seconds ago)<\/pre>\n<h3>Convert Snapshot Standby Back to Physical Standby<\/h3>\n<p><strong>Step1:<\/strong><\/p>\n<p>Shut down all Snapshot Standby Instances<\/p>\n<pre class=\"lang:default decode:true \">[Standby-1-2]\nSQL&gt; shutdown immediate;\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.<\/pre>\n<p><strong>Step2:<\/strong><\/p>\n<p>Start only the first Snapshot Standby Instance in mount mode.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; startup mount;\nORACLE instance started.\n\nTotal System Global Area 6480490496 bytes\nFixed Size                  2265384 bytes\nVariable Size            1241517784 bytes\nDatabase Buffers         5217714176 bytes\nRedo Buffers               18993152 bytes\nDatabase mounted.\n<\/pre>\n<p><strong>Step3:<\/strong><\/p>\n<p>Convert snapshot standby back to physical standby .<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; alter database convert to physical standby;\n\nDatabase altered.<\/pre>\n<p>The logs are as follows.<\/p>\n<pre class=\"lang:default decode:true \">[Standby-1]\nalter database convert to physical standby\nALTER DATABASE CONVERT TO PHYSICAL STANDBY (primary1)\nFlashback Restore Start\nFlashback Restore Complete\nDrop guaranteed restore point \nDeleted Oracle managed file +FRA\/standby\/flashback\/log_1.599.932481007\nDeleted Oracle managed file +FRA\/standby\/flashback\/log_2.600.932481007\nDeleted Oracle managed file +FRA\/standby\/flashback\/log_3.601.932481011\nDeleted Oracle managed file +FRA\/standby\/flashback\/log_4.602.932481013\nGuaranteed restore point  dropped\nClearing standby activation ID 1769842254 (0x697da64e)\nThe primary database controlfile was created using the\n'MAXLOGFILES 192' clause.\nThere is space for up to 188 standby redo logfiles\nUse the following SQL commands on the standby database to create\nstandby redo logfiles that match the primary database:\nALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800;\nALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;\nALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 52428800;\nALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 52428800;\nALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 52428800;\nShutting down archive processes\nArchiving is disabled\nThu Jan 05 15:40:40 2017\nARCH shutting down\nARC7: Archival stopped\nThu Jan 05 15:40:40 2017\nARCH shutting down\nARC1: Archival stopped\nThu Jan 05 15:40:40 2017\nARCH shutting down\nThu Jan 05 15:40:40 2017\nARCH shutting down\nARC3: Archival stopped\nARC0: Archival stopped\nThu Jan 05 15:40:40 2017\nARCH shutting down\nARC2: Archival stopped\nThu Jan 05 15:40:40 2017\nARCH shutting down\nARC5: Archival stopped\nThu Jan 05 15:40:40 2017\nARCH shutting down\nARC6: Archival stopped\nThu Jan 05 15:40:40 2017\nARCH shutting down\nARC4: Archival stopped\nCompleted: alter database convert to physical standby\nThu Jan 05 15:40:47 2017\nSUCCESS: diskgroup FRA was dismounted\nSUCCESS: diskgroup DATA was dismounted\nNOTE: Database dismounted; ASMB process exiting\nStopping background process RBAL\nStopping background process MARK\nThu Jan 05 15:40:49 2017\nNOTE: Shutting down MARK background process<\/pre>\n<p><strong>Step4:<\/strong><\/p>\n<p>Close Standby &#8211; 1 again and start in mount mode.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; shutdown immediate;\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\nSQL&gt; startup mount;\nORACLE instance started.\n\nTotal System Global Area 6480490496 bytes\nFixed Size                  2265384 bytes\nVariable Size            1241517784 bytes\nDatabase Buffers         5217714176 bytes\nRedo Buffers               18993152 bytes\nDatabase mounted.\n<\/pre>\n<p><strong>Step5:<\/strong><\/p>\n<p>Start Standby -2 in mount mode.<\/p>\n<pre class=\"lang:default decode:true \">[Standby-2]\nSQL&gt; startup mount;\nORACLE instance started.\n\nTotal System Global Area 6480490496 bytes\nFixed Size                  2265384 bytes\nVariable Size            1241517784 bytes\nDatabase Buffers         5217714176 bytes\nRedo Buffers               18993152 bytes\nDatabase mounted.\n<\/pre>\n<p><strong>Step6:<\/strong><\/p>\n<p>If you will use Active Data Guard, open the databases.<\/p>\n<pre class=\"lang:default decode:true \">[Standby-1-2]\nSQL&gt; alter database open read only;\n\nDatabase altered.<\/pre>\n<p><strong>Step7:<\/strong><\/p>\n<p>Check the existence of the table created when we convert it to Snapshot Standby.<\/p>\n<pre class=\"lang:default decode:true \">[Standby-1-2]\nSQL&gt; select count(*) from test.jobs_yedek;\nselect count(*) from test.jobs_yedek\n                          *\nERROR at line 1:\nORA-00942: table or view does not exist<\/pre>\n<p><strong>Step8:<\/strong><\/p>\n<p>Start recovery.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; alter database recover managed standby database using current logfile disconnect;\n\nDatabase altered.\n<\/pre>\n<p>The logs are as follows.<\/p>\n<pre class=\"lang:default decode:true \">alter database recover managed standby database using current logfile disconnect\nAttempt to start background Managed Standby Recovery process (primary1)\nThu Jan 05 15:58:54 2017\nMRP0 started with pid=58, OS id=21657 \nMRP0: Background Managed Standby Recovery process started (primary1)\n started logmerger process\nThu Jan 05 15:58:59 2017\nManaged Standby Recovery starting Real Time Apply\nThu Jan 05 15:59:00 2017\nReconfiguration started (old inc 4, new inc 6)\nList of instances:\n 1 2 (myinst: 1) \n Global Resource Directory frozen\n Communication channels reestablished\n Master broadcasted resource hash value bitmaps\n Non-local Process blocks cleaned out\nThu Jan 05 15:59:00 2017\n LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived\nThu Jan 05 15:59:00 2017\n LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived\n Set master node info \n Submitted all remote-enqueue requests\n Dwn-cvts replayed, VALBLKs dubious\n All grantable enqueues granted\n Submitted all GCS remote-cache requests\n Fix write in gcs resources\nReconfiguration complete\nParallel Media Recovery started with 4 slaves\nThu Jan 05 15:59:01 2017\nCHANGE TRACKING found new resetlogs, resetting.\nold SCN: 0x0000.00215455, new SCN: 0x0000.000e2006\nold time: 932481024, new time=932222810\nCHANGE TRACKING is reinitializing the change tracking file.\nStarting background process CTWR\nThu Jan 05 15:59:01 2017\nCTWR started with pid=64, OS id=21692 \nBlock change tracking service is active.\nWaiting for all non-current ORLs to be archived...\nAll non-current ORLs have been archived.\nCompleted: alter database recover managed standby database using current logfile disconnect\nClearing online redo logfile 1 +DATA\/standby\/onlinelog\/group_1.263.932283679\nClearing online log 1 of thread 1 sequence number 249\nClearing online redo logfile 1 complete\nClearing online redo logfile 3 +DATA\/standby\/onlinelog\/group_3.265.932283681\nClearing online log 3 of thread 2 sequence number 109\nClearing online redo logfile 3 complete\nMedia Recovery Log +FRA\/standby\/archivelog\/2017_01_05\/thread_2_seq_104.603.932481323\nMedia Recovery Log +FRA\/standby\/archivelog\/2017_01_05\/thread_1_seq_244.604.932481381\nMedia Recovery Log +FRA\/standby\/archivelog\/2017_01_05\/thread_2_seq_105.606.932481785\nMedia Recovery Log +FRA\/standby\/archivelog\/2017_01_05\/thread_1_seq_245.605.932481781\nMedia Recovery Log +FRA\/standby\/archivelog\/2017_01_05\/thread_1_seq_246.599.932486007\nMedia Recovery Log +FRA\/standby\/archivelog\/2017_01_05\/thread_2_seq_106.600.932486007\nMedia Recovery Log +FRA\/standby\/archivelog\/2017_01_05\/thread_2_seq_107.602.932486007\nMedia Recovery Log +FRA\/standby\/archivelog\/2017_01_05\/thread_1_seq_247.601.932486007\nMedia Recovery Log +FRA\/standby\/archivelog\/2017_01_05\/thread_2_seq_108.609.932486009\nMedia Recovery Log +FRA\/standby\/archivelog\/2017_01_05\/thread_1_seq_248.608.932486007\nMedia Recovery Waiting for thread 1 sequence 249 (in transit)\nRecovery of Online Redo Log: Thread 1 Group 5 Seq 249 Reading mem 0\n  Mem# 0: +DATA\/standby\/onlinelog\/group_5.267.932283683\n  Mem# 1: +FRA\/standby\/onlinelog\/group_5.260.932283683\nMedia Recovery Waiting for thread 2 sequence 109 (in transit)\nRecovery of Online Redo Log: Thread 2 Group 8 Seq 109 Reading mem 0\n  Mem# 0: +DATA\/standby\/onlinelog\/group_8.270.932283685\n  Mem# 1: +FRA\/standby\/onlinelog\/group_8.263.932283685<\/pre>\n<p><strong>Step9:<\/strong><\/p>\n<p>Check for flashback logs and restore points.<\/p>\n<pre class=\"lang:default decode:true  \">[Standby-1-2]\nSQL&gt; select file_type,number_of_files,percent_space_used from v$recovery_area_usage;\n\nFILE_TYPE            NUMBER_OF_FILES PERCENT_SPACE_USED\n-------------------- --------------- ------------------\nCONTROL FILE                       0                  0\nREDO LOG                           0                  0\nARCHIVED LOG                     344              88.66\nBACKUP PIECE                       0                  0\nIMAGE COPY                         0                  0\nFLASHBACK LOG                      0                  0\nFOREIGN ARCHIVED LOG               0                  0\n\n7 rows selected.\n\n\nSQL&gt; set linesize 500\nSQL&gt; column name format a50\nSQL&gt; select name, storage_size from v$restore_point;\n\nno rows selected<\/pre>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_15128\" class=\"pvc_stats all  \" data-element-id=\"15128\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>You can find the below informations about Snapshot Standby Database in this article. What is Oracle Snapshot Standby Database? Convert Physical Standby to Snapshot Standby Convert Physical Standby to Snapshot Standby using Dgmgrl Convert Snapshot Standby Back to Physical Standby What is Oracle Snapshot Standby Database? Snapshot Standby Database is an updatable database created from &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_15128\" class=\"pvc_stats all  \" data-element-id=\"15128\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":484,"featured_media":15133,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[8989,8988,8976,8995,8994,9004,9005,9008,9003,8983,8993,8992,8997,9007,9000,8998,8990,8999,9002,8978,8986,8985,8984,8977,8991,8996,9006,9001,8987,8980,8979,8982,8981],"class_list":["post-15128","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-convert-physical-standby-database-to-snapshot-standby-database","tag-convert-physical-standby-to-snapshot-standby","tag-convert-physical-standby-to-snapshot-standby-database","tag-convert-physical-standby-to-snapshot-standby-dgmgrl","tag-convert-physical-standby-to-snapshot-standby-using-dgmgrl","tag-convert-snapshot-standby-back-to-physical-standby","tag-convert-snapshot-standby-database-to-physical-standby","tag-convert-snapshot-standby-database-to-physical-standby-database","tag-convert-snapshot-standby-to-physical-standby","tag-create-snapshot-standby-database-oracle","tag-how-to-convert-physical-standby-database-to-snapshot-standby","tag-how-to-convert-physical-standby-to-snapshot-standby","tag-how-to-convert-physical-standby-to-snapshot-standby-using-dgmgrl","tag-how-to-convert-snapshot-standby-to-physical-standby","tag-ora-16778","tag-ora-16778-redo-transport-error-for-one-or-more-databases","tag-oracle-convert-snapshot-standby-to-physical-standby","tag-redo-transport-error-for-one-or-more-databases","tag-reopensecs","tag-snapshot-standby-database-in-oracle","tag-snapshot-standby-database-in-oracle-11gr2","tag-snapshot-standby-database-in-oracle-11gr2-steps","tag-snapshot-standby-database-oracle-data-guard","tag-snapshot-standby-database-steps","tag-steps-to-convert-physical-standby-to-snapshot-standby","tag-steps-to-convert-physical-standby-to-snapshot-standby-using-dgmgrl","tag-steps-to-convert-snapshot-standby-to-physical-standby","tag-transportdisconnectedthreshold","tag-what-is-oracle-snapshot-standby-database","tag-what-is-snapshot-standby-database-in-oracle","tag-what-is-snapshot-standby-database-in-oracle-11g","tag-what-is-the-use-of-snapshot-standby-database-in-oracle","tag-what-is-the-use-of-snapshot-standby-database-in-oracle-11g"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle Snapshot Standby Database - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Oracle Snapshot Standby Database\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Snapshot Standby Database - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Oracle Snapshot Standby Database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-05T08:53:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-05T08:59:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"536\" \/>\n\t<meta property=\"og:image:height\" content=\"314\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\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:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Oracle Snapshot Standby Database\",\"datePublished\":\"2020-03-05T08:53:40+00:00\",\"dateModified\":\"2020-03-05T08:59:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/\"},\"wordCount\":815,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-3.png\",\"keywords\":[\"convert physical standby database to snapshot standby database\",\"convert physical standby to snapshot standby\",\"Convert physical standby to snapshot standby database\",\"convert physical standby to snapshot standby dgmgrl\",\"convert physical standby to snapshot standby using dgmgrl\",\"convert snapshot standby back to physical standby\",\"convert snapshot standby database to physical standby\",\"Convert Snapshot Standby Database to Physical Standby Database\",\"convert snapshot standby to physical standby\",\"create snapshot standby database oracle\",\"how to convert physical standby database to snapshot standby\",\"how to convert physical standby to snapshot standby\",\"how to convert physical standby to snapshot standby using dgmgrl\",\"how to convert snapshot standby to physical standby\",\"ORA-16778\",\"ORA-16778: redo transport error for one or more databases\",\"oracle convert snapshot standby to physical standby\",\"redo transport error for one or more databases\",\"ReopenSecs\",\"snapshot standby database in oracle\",\"snapshot standby database in oracle 11gr2\",\"snapshot standby database in oracle 11gr2 steps\",\"snapshot standby database oracle data guard\",\"snapshot standby database steps\",\"steps to convert physical standby to snapshot standby\",\"steps to convert physical standby to snapshot standby using dgmgrl\",\"steps to convert snapshot standby to physical standby\",\"TransportDisconnectedThreshold\",\"what is oracle snapshot standby database\",\"what is snapshot standby database in oracle\",\"what is snapshot standby database in oracle 11g\",\"what is the use of snapshot standby database in oracle\",\"what is the use of snapshot standby database in oracle 11g\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/\",\"name\":\"Oracle Snapshot Standby Database - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-3.png\",\"datePublished\":\"2020-03-05T08:53:40+00:00\",\"dateModified\":\"2020-03-05T08:59:59+00:00\",\"description\":\"Oracle Snapshot Standby Database\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-3.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-3.png\",\"width\":536,\"height\":314},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Snapshot Standby Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Snapshot Standby Database - Database Tutorials","description":"Oracle Snapshot Standby Database","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:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Snapshot Standby Database - Database Tutorials","og_description":"Oracle Snapshot Standby Database","og_url":"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/","og_site_name":"Database Tutorials","article_published_time":"2020-03-05T08:53:40+00:00","article_modified_time":"2020-03-05T08:59:59+00:00","og_image":[{"width":536,"height":314,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-3.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Oracle Snapshot Standby Database","datePublished":"2020-03-05T08:53:40+00:00","dateModified":"2020-03-05T08:59:59+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/"},"wordCount":815,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-3.png","keywords":["convert physical standby database to snapshot standby database","convert physical standby to snapshot standby","Convert physical standby to snapshot standby database","convert physical standby to snapshot standby dgmgrl","convert physical standby to snapshot standby using dgmgrl","convert snapshot standby back to physical standby","convert snapshot standby database to physical standby","Convert Snapshot Standby Database to Physical Standby Database","convert snapshot standby to physical standby","create snapshot standby database oracle","how to convert physical standby database to snapshot standby","how to convert physical standby to snapshot standby","how to convert physical standby to snapshot standby using dgmgrl","how to convert snapshot standby to physical standby","ORA-16778","ORA-16778: redo transport error for one or more databases","oracle convert snapshot standby to physical standby","redo transport error for one or more databases","ReopenSecs","snapshot standby database in oracle","snapshot standby database in oracle 11gr2","snapshot standby database in oracle 11gr2 steps","snapshot standby database oracle data guard","snapshot standby database steps","steps to convert physical standby to snapshot standby","steps to convert physical standby to snapshot standby using dgmgrl","steps to convert snapshot standby to physical standby","TransportDisconnectedThreshold","what is oracle snapshot standby database","what is snapshot standby database in oracle","what is snapshot standby database in oracle 11g","what is the use of snapshot standby database in oracle","what is the use of snapshot standby database in oracle 11g"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/","url":"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/","name":"Oracle Snapshot Standby Database - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-3.png","datePublished":"2020-03-05T08:53:40+00:00","dateModified":"2020-03-05T08:59:59+00:00","description":"Oracle Snapshot Standby Database","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-3.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-3.png","width":536,"height":314},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/05\/oracle-snapshot-standby-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Snapshot Standby Database"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/15128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=15128"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/15128\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/15133"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=15128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=15128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=15128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}