{"id":14415,"date":"2019-12-27T08:06:10","date_gmt":"2019-12-27T08:06:10","guid":{"rendered":"https:\/\/dbtut.com\/?p=14415"},"modified":"2019-12-27T10:47:42","modified_gmt":"2019-12-27T10:47:42","slug":"recover-datbase-using-service-refresh-standby-database-in-oracle-12c","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/","title":{"rendered":"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c)"},"content":{"rendered":"<p>Before 12c if one of the standby database goes out of sync with respect to the primary database we have to perform the below steps in order to make the standby in sync with the primary.<\/p>\n<ul>\n<li>Check the current of the SCN of the standby database from where recovery needs to be done.<\/li>\n<li>We need to take the incremental backup of the primary database from that SCN obtained from the standby database.<\/li>\n<li>Copy the backup from primary to the standby and catalog the backups<\/li>\n<li>Cancel the MRP of the standby database and apply the backup from the primary<\/li>\n<li>Create a new control file for the standby database from the primary and mount the standby using the new control file.<\/li>\n<li>Start the managed recovery of the standby database.<\/li>\n<\/ul>\n<p>In 12c, the method remains the same, but it has been made easier. We can use the <strong>RECOVER DATABASE USING SERVICE<\/strong> to sync the standby database with the primary.<\/p>\n<p>The command does the same as described above in the background creates incremental backups containing the changes in the primary database. All changes to datafile on the primary database starting with the SCN in the standby data file header all are included in the incremental backup then the backup will be transferred over the network to the standby location and the incremental backup will be applied to the standby database.<\/p>\n<p><strong>Below are the details which we will use:<\/strong><\/p>\n<p><strong>Primary Database <\/strong><\/p>\n<pre class=\"lang:default decode:true \">DB_UNIQUE_NAME=AMIT(NET SERVICE NAME AMIT)\n\nService name can be selected by giving the below query\n\nSQL&gt; Show parameter service\n\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\n\n------------------------------------ ----------- ------------------------------\n\nservice_names\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 AMIT<\/pre>\n<p><strong>Standby Database:<\/strong><\/p>\n<pre class=\"lang:default decode:true\">DB_UNIQUE_NAME=VASHISHTH(Net service Name VASHISHTH)\n\nSQL&gt; Show parameter service\n\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\n\n------------------------------------ ----------- ------------------------------\n\nservice_names\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 VASHISHTH<\/pre>\n<p>There are few prerequisites before we start the activity for 12c<\/p>\n<ul>\n<li>There should be Oracle net connectivity between standby and primary which can be done by adding the TNS entry in the tnsnames.ora file of the standby database.<\/li>\n<li>This only work for oracle 12c or higher version of the database so the COMPATIBLE parameter should be set to 12 or the higher version.<\/li>\n<li>Check the space on the standby database location make sure we have enough space on the server.<\/li>\n<\/ul>\n<p><strong>Place the standby database in mount Mode:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; shutdown immediate;\n\nDatabase closed.\n\nDatabase dismounted.\n\nORACLE instance shut down.\n\nSQL&gt; startup mount;\n\nORACLE instance started.\n\nTotal System Global Area 1.52875E+10 bytes\n\nFixed Size 8796438 bytes\n\nVariable Size 4630514240 bytes\n\nDatabase Buffers 9193914368 bytes\n\nRedo Buffers 104153088 bytes\n\nDatabase mounted.<\/pre>\n<p><strong>Checking if Managed Recovery is running on the standby <\/strong><\/p>\n<pre class=\"lang:default decode:true \">SQL&gt;set feedback off\n\nset pages 0\n\nset lines 180\n\nselect\u00a0 THREAD#,SEQUENCE#,STATUS ,BLOCK# from gv$managed_standby ;SQL&gt; SQL&gt; SQL&gt; SQL&gt;\n\n1\u00a0\u00a0\u00a0\u00a0 150829 CLOSING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1757184\n\n0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 CONNECTED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n\n1\u00a0\u00a0\u00a0\u00a0 150860 CLOSING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1593344\n\n1\u00a0\u00a0\u00a0\u00a0 150830 CLOSING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1785856\n\n1\u00a0\u00a0\u00a0\u00a0 150859 CLOSING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1662976\n\n0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 IDLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n\n0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 IDLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n\n0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 IDLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n\n1\u00a0\u00a0\u00a0\u00a0 150861 IDLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2255\n\n1\u00a0\u00a0\u00a0\u00a0 150861 APPLYING_LOG\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2256\n\nSQL&gt;\n\ncurrently applying the log from thread 1 Seq# 150861<\/pre>\n<p><strong>CHECK WHETHER REDO APPLY ACTIVE<\/strong><\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; set feedback off\n\nset pages 0\n\nset lines 180\n\nselect\u00a0 trim(BLOCK#) from gv$managed_standby where PROCESS='MRP0';SQL&gt; SQL&gt; SQL&gt;\n\n2256<\/pre>\n<p>By executing the above command if the BLOCK# is keep on changing the redo apply is active and database will be in sync with the primary, if the BLOCK# remain the same we need to do the recovery.<\/p>\n<p>We can check the sync by using the command <strong>archive log list<\/strong> on both primary and standby and comparing the <strong>current log sequence no<\/strong>. If there is no difference, we are good else we need to sync the standby database with the primary by executing the below steps on the standby database.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; recover managed standby database cancel;\n\nMedia recovery complete.<\/pre>\n<p><strong>Check SCN of the Standby database <\/strong><\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; SELECT TO_CHAR(dbms_flashback.get_system_change_number) FROM dual;\n\n12835661337649<\/pre>\n<p>This will be used in later steps.<\/p>\n<p><strong>Connect to the RMAN to refreshes the standby database using the service name<\/strong><\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; recover database from service AMIT noredo using compressed backupset;<\/pre>\n<p>Below is the sample output:<\/p>\n<pre class=\"lang:default decode:true \">Starting recover at 22-DEC-19\n\nusing target database control file instead of recovery catalog\n\nallocated channel: ORA_DISK_1\n\nchannel ORA_DISK_1: SID=342 device type=DISK\n\nchannel ORA_DISK_1: starting incremental datafile backup set restore\n\nchannel ORA_DISK_1: using compressed network backup set from service AMIT\n\ndestination for restore of datafile 00001: \/archive\/AMIT\/AMIT\/system01.dbf\n\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\n\nchannel ORA_DISK_1: starting incremental datafile backup set restore\n\nchannel ORA_DISK_1: using compressed network backup set from service AMIT\n\ndestination for restore of datafile 00002: \/archive\/AMIT\/AMIT\/sysaux01.dbf\n\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\n\nchannel ORA_DISK_1: starting incremental datafile backup set restore\n\nchannel ORA_DISK_1: using compressed network backup set from service AMIT\n\ndestination for restore of datafile 00003: \/archive\/AMIT\/AMIT\/undotbs01.dbf\n\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\n\nchannel ORA_DISK_1: starting incremental datafile backup set restore\n\nchannel ORA_DISK_1: using compressed network backup set from service AMIT\n\ndestination for restore of datafile 00004: \/archive\/AMIT\/AMIT\/users01.dbf\n\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\n\nFinished recover at 22-DEC-19<\/pre>\n<p>At this point the standby will be in sync with the primary but the control file of the standby database contains the old values of SCN so to complete the synchronization. We<strong> need to refresh the control file from the primary database.<\/strong><\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; shutdown immediate;\n\ndatabase dismounted\n\nOracle instance shut down\n\nRMAN&gt; startup nomount;\n\nconnected to target database (not started)\n\nOracle instance started\n\nTotal System Global Area 26587413659 bytes\n\nFixed Size 60025612 bytes\n\nVariable Size 46305684240 bytes\n\nDatabase Buffers 9132569914368 bytes\n\nRedo Buffers 104458963088 bytes\n\nRMAN&gt; restore standby controlfile from service AMIT;\n\nStarting restore at 22-DEC-19\n\nallocated channel: ORA_DISK_1\n\nchannel ORA_DISK_1: SID=678 device type=DISK\n\nchannel ORA_DISK_1: starting datafile backup set restore\n\nchannel ORA_DISK_1: using network backup set from service AMIT\n\nchannel ORA_DISK_1: restoring control file\n\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\n\noutput file name=\/archive\/AMIT\/AMIT\/control01.ctl\n\noutput file name=\/archive\/AMIT\/AMIT\/control02.ctl\n\nFinished restore at 22-DEC-19\n\nRMAN&gt; alter database mount;\n\nRMAN&gt; report schema;<\/pre>\n<p>Report schema will do an implicit crosscheck and catalogued the files in the recovery area.<\/p>\n<p>If the directory structure of the primary and standby database is different you will get the below alert while performing the above steps<\/p>\n<p><strong>RMAN-06139: WARNING: control file is not current for REPORT SCHEMA<\/strong><\/p>\n<p><strong>Report of database schema for database with db_unique_name\u00a0 VASHISHTH <\/strong><\/p>\n<p>To rectify perform the below steps:<\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; Catalog start with '\/archive\/AMITDB\/AMIT\/VASHISHTH\/';\u00e7location of the files\n\nRMAN&gt; SWITCH DATABASE TO COPY;<\/pre>\n<p><strong>We need recover the standby database before opening in read only mode :<\/strong><\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; RECOVER DATABASE;<\/pre>\n<p>If we open the database now and start the managed process, we will get the below alert in the alertlog<\/p>\n<p><strong>RFS[4]: No standby redo logfiles available for thread 1<\/strong><\/p>\n<p>So, we need to drop the standby redo logs and recreate them<\/p>\n<pre class=\"lang:default decode:true  \">SQL&gt; alter database drop logfile group 5;\n\nDatabase altered.\n\nSQL&gt; alter database drop logfile group 4;\n\nDatabase altered.\n\nSQL&gt; alter database drop logfile group 6;\n\nDatabase altered.\n\nSQL&gt; select thread#, group#, sequence#, status from v$standby_log;\n\nno rows selected\n\nSQL&gt; alter database add standby logfile '\/archive\/AMIT\/AMIT\/stdby_redo04.log' size 64532100;\n\nDatabase altered.\n\nSQL&gt; alter database add standby logfile '\/archive\/AMIT\/AMIT\/stdby_redo05.log' size 64532100;\n\nDatabase altered.\n\nSQL&gt; alter database add standby logfile '\/archive\/AMIT\/AMIT\/stdby_redo06.log' size 64532100;\n\nDatabase altered.\n\nSQL&gt; alter database add standby logfile '\/archive\/AMIT\/AMIT\/stdby_redo07.log' size 64532100;\n\nDatabase altered.<\/pre>\n<p>Open the standby database in read only mode and start the recovery managed process<\/p>\n<pre class=\"lang:default decode:true  \">SQL&gt; ALTER DATABASE OPEN READ ONLY;\n\nSQL&gt; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;<\/pre>\n<p>The standby database will be in sync with primary database now. Which can be checked using archive log list or using<\/p>\n<pre class=\"lang:default decode:true \">select max(sequence#) from v$log_history;<\/pre>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14415\" class=\"pvc_stats all  \" data-element-id=\"14415\" 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>Before 12c if one of the standby database goes out of sync with respect to the primary database we have to perform the below steps in order to make the standby in sync with the primary. Check the current of the SCN of the standby database from where recovery needs to be done. We need &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14415\" class=\"pvc_stats all  \" data-element-id=\"14415\" 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":481,"featured_media":14422,"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":[7151,7149,7136,7146,7148,7147,7150,7140,7153,7156,7154,7152,7145,7143,7157,7155,7137,7142,7144,7141],"class_list":["post-14415","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-oracle-12c-recover-database-from-service","tag-oracle-12c-recover-standby-database-from-service","tag-oracle12c","tag-recover-database-from-service","tag-recover-database-from-service-12c","tag-recover-database-from-service-12c-standby","tag-recover-database-from-service-oracle","tag-recover-database-using-service","tag-recover-standby-database-from-service-12c","tag-recover-standby-database-from-service-primary_db","tag-recover-standby-database-using-service","tag-recover-standby-database-using-service-12c","tag-recovering-a-standby-over-the-network-in-12c","tag-refresh-standby-database-in-oracle-12c","tag-refresh-the-physical-standby-using-recover-from-service","tag-rman-recover-standby-database-from-service","tag-standby-database","tag-sync-standby-database","tag-sync-standby-database-in-oracle-12c","tag-sync-the-standby-database-with-the-primary"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":7198,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c)\" \/>\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\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-27T08:06:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-27T10:47:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-23.png\" \/>\n\t<meta property=\"og:image:width\" content=\"540\" \/>\n\t<meta property=\"og:image:height\" content=\"321\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Amit Vashishth\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Amit Vashishth\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/\"},\"author\":{\"name\":\"Amit Vashishth\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/498d05a2429aa44b0ee5e0707bfb8315\"},\"headline\":\"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c)\",\"datePublished\":\"2019-12-27T08:06:10+00:00\",\"dateModified\":\"2019-12-27T10:47:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/\"},\"wordCount\":664,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-23.png\",\"keywords\":[\"oracle 12c recover database from service\",\"oracle 12c recover standby database from service\",\"Oracle12c\",\"recover database from service\",\"recover database from service 12c\",\"recover database from service 12c standby\",\"recover database from service oracle\",\"RECOVER DATABASE USING SERVICE\",\"recover standby database from service 12c\",\"recover standby database from service primary_db\",\"recover standby database using service\",\"recover standby database using service 12c\",\"Recovering a standby over the network in 12c\",\"Refresh standby database in Oracle 12c\",\"Refresh the Physical Standby using RECOVER FROM SERVICE\",\"rman recover standby database from service\",\"Standby database\",\"sync standby database\",\"Sync standby database in Oracle 12c\",\"sync the standby database with the primary\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/\",\"name\":\"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-23.png\",\"datePublished\":\"2019-12-27T08:06:10+00:00\",\"dateModified\":\"2019-12-27T10:47:42+00:00\",\"description\":\"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-23.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-23.png\",\"width\":540,\"height\":321},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c)\"}]},{\"@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\/498d05a2429aa44b0ee5e0707bfb8315\",\"name\":\"Amit Vashishth\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1151b8ba4366b28f37b7864d09bc41e952f55c1e541e29bc6b499dc55f8a502d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1151b8ba4366b28f37b7864d09bc41e952f55c1e541e29bc6b499dc55f8a502d?s=96&d=mm&r=g\",\"caption\":\"Amit Vashishth\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/amitvashishth\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c) - Database Tutorials","description":"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c)","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\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/","og_locale":"en_US","og_type":"article","og_title":"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c) - Database Tutorials","og_description":"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/","og_site_name":"Database Tutorials","article_published_time":"2019-12-27T08:06:10+00:00","article_modified_time":"2019-12-27T10:47:42+00:00","og_image":[{"width":540,"height":321,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-23.png","type":"image\/png"}],"author":"Amit Vashishth","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Amit Vashishth","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/"},"author":{"name":"Amit Vashishth","@id":"https:\/\/dbtut.com\/#\/schema\/person\/498d05a2429aa44b0ee5e0707bfb8315"},"headline":"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c)","datePublished":"2019-12-27T08:06:10+00:00","dateModified":"2019-12-27T10:47:42+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/"},"wordCount":664,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-23.png","keywords":["oracle 12c recover database from service","oracle 12c recover standby database from service","Oracle12c","recover database from service","recover database from service 12c","recover database from service 12c standby","recover database from service oracle","RECOVER DATABASE USING SERVICE","recover standby database from service 12c","recover standby database from service primary_db","recover standby database using service","recover standby database using service 12c","Recovering a standby over the network in 12c","Refresh standby database in Oracle 12c","Refresh the Physical Standby using RECOVER FROM SERVICE","rman recover standby database from service","Standby database","sync standby database","Sync standby database in Oracle 12c","sync the standby database with the primary"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/","url":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/","name":"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-23.png","datePublished":"2019-12-27T08:06:10+00:00","dateModified":"2019-12-27T10:47:42+00:00","description":"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-23.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-23.png","width":540,"height":321},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/recover-datbase-using-service-refresh-standby-database-in-oracle-12c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c)"}]},{"@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\/498d05a2429aa44b0ee5e0707bfb8315","name":"Amit Vashishth","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1151b8ba4366b28f37b7864d09bc41e952f55c1e541e29bc6b499dc55f8a502d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1151b8ba4366b28f37b7864d09bc41e952f55c1e541e29bc6b499dc55f8a502d?s=96&d=mm&r=g","caption":"Amit Vashishth"},"url":"https:\/\/dbtut.com\/index.php\/author\/amitvashishth\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14415","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\/481"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14415"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14415\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14422"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}