What is Real Time Apply in Dataguard”<\/a><\/p>\nSQL> alter database recover managed standby database using current logfile disconnect; \n\nDatabase altered.\n<\/pre>\nStep3:<\/strong> Check the instance status and the role of Databases.<\/p>\nSQL> select status from gv$instance;\n\nSTATUS\n------------\nMOUNTED\nMOUNTED\n\nSQL> select OPEN_MODE, DATABASE_ROLE from v$database;\n\nOPEN_MODE DATABASE_ROLE\n-------------------- ----------------\nMOUNTED PHYSICAL STANDBY\n<\/pre>\nStep4:<\/strong> On the primary side, Log Switch operation is performed separately from both Node.<\/p>\nSQL> alter system switch logfile;\n\nSystem altered.\n\nSQL> SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#) THREAD#\n-------------- ----------\n 77 1\n 40 2\n\nSQL> alter system switch logfile;\n\nSystem altered.\n\nSQL> SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#) THREAD#\n-------------- ----------\n 77 1\n 42 2\n<\/pre>\nStep5:<\/strong> Check whether Redo-Transport is coming to standby side.<\/p>\nSQL> SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#) THREAD#\n-------------- ----------\n 77 1\n 42 2\n<\/pre>\nStep6:<\/strong> By checking the LAG status, check whether the redos transported are applied or not.<\/p>\nSQL> column name format a22\nSQL> column value format a15\nSQL> column value format a30\nSQL> column datum_time format a20\nSQL> column time_computed format a20\nSQL> set linesize 9000\nSQL> \nSQL> select * from v$dataguard_stats;\n\nNAME VALUE UNIT TIME_COMPUTED DATUM_TIME\n---------------------- ------------------------------ ------------------------------ -------------------- --------------------\ntransport lag +00 00:00:00 day(2) to second(0) interval 01\/03\/2017 21:57:43 01\/03\/2017 21:57:42\napply lag +00 00:00:00 day(2) to second(0) interval 01\/03\/2017 21:57:43 01\/03\/2017 21:57:42\napply finish time +00 00:00:00.000 day(2) to second(3) interval 01\/03\/2017 21:57:43\nestimated startup time 33 second 01\/03\/2017 21:57:43\n<\/pre>\n\n
\n
Create Global Temporary Tables On Active Data Guard<\/h3>\n Active Data Guard is a physical standby database that can only be used read-only. Inserting data to the Temprorary table is not allowed, as it does not allow any operations to produce Redo on it.<\/p>\n
Temporary Tablespace is used during insert data into the Temproray table. A Redo is not produced for this process, but since Undo Tablespace is used for Undo, Oracle internally produces Redo. For this reason, inserting data is not allowed to Global Temprorary table in versions before 12c. When you try to insert data to Global Temprorary table, you receive the following error.<\/p>\n
ORA-16000: database open for read-only access<\/em><\/span><\/p>\n[Physical-1] SQL> INSERT INTO my_temp_table\n 2 WITH data AS (\n 3 SELECT 1 AS id\n 4 FROM dual\n 5 CONNECT BY level < 10000\n 6 )\n 7 SELECT rownum, TO_CHAR(rownum)\n 8 FROM data a, data b\n 9 WHERE rownum <= 1000000;\nINSERT INTO my_temp_table\n*\nERROR at line 1:\nORA-16000: database open for read-only access<\/pre>\ntemp_undo_enabled in oracle 12c<\/h3>\n In 12c, this situation is solved with the TEMP_UNDO_ENABLED parameter. For transactions using Temporary Tablespace, Temporary Undo Tablespace is used. For this reason, no Redo is produced and data can be inserted into Temporary Tables.<\/p>\n
This parameter can be used in both Primary and Physical Standby. When used on the primary side, Redo production decreases 100 times , while on the Active Data Guard side, no Redo is produced.<\/p>\n
In Active Data Guard, this parameter is enabled by default.<\/p>\n
temp_undo_enabled Example<\/strong><\/h4>\nStep1:<\/strong> Create a user in the primary database.<\/p>\n[Primary] SQL> create user tempundo identified by \"1\" account unlock;\n\nUser created.\n<\/pre>\nStep2:<\/strong> Grant permission to the user so that the user can connect to the database.<\/p>\n[Primary] SQL> grant create session to tempundo;\n\nGrant succeeded.\n<\/pre>\nStep3:<\/strong> Grant permission to the user so that the user can create a temporary table.<\/p>\n[Primary] SQL> grant create table to tempundo;\n\nGrant succeeded.\n<\/pre>\nNote:<\/strong> The reason why CREATE TABLE is granted is that it cannot create any other table other than temporary table because it is already a Read-only database. If the user wants to create another table using this authorization, he\/she gets the error as follows.<\/p>\nERROR at line 1:<\/em><\/span>ORA-00604: error occurred at recursive SQL level 1<\/em><\/span>ORA-16000: database or pluggable database open for read-only access<\/em><\/span><\/p>\n[Physical] SQL> create table employees_yedek as select * from hr.employees;\ncreate table employees_yedek as select * from hr.employees\n *\nERROR at line 1:\nORA-00604: error occurred at recursive SQL level 1\nORA-16000: database or pluggable database open for read-only access<\/pre>\nStep4:<\/strong> Grant permission to user so that the user can query for objects.<\/p>\n[Primary] SQL> grant select on v_$tempundostat to tempundo;\n\nGrant succeeded.\n\n[Primary] SQL> grant select on v_$transaction to tempundo;\n\nGrant succeeded.<\/pre>\nStep5:<\/strong> Create a Temporary table by switching to TEMPUNDO user.<\/p>\n[Primary] SQL> conn tempundo\/1\nConnected.\n[Primary] SQL> show user\nUSER is \"TEMPUNDO\"<\/pre>\n[Primary] SQL> create global temporary table my_temp_table (id number, description varchar2(20)) on commit delete rows;\n\nTable created.\n<\/pre>\nNote:<\/strong> The reason I wrote ON COMMIT DELETE ROWS<\/strong> while creating the table is that I want the data in the table to be deleted at the end of the session.<\/p>\nStep6:<\/strong> Open autotrace to see statistics.<\/p>\n[Primary] SQL> SET AUTOTRACE ON STATISTICS;\nSP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled\nSP2-0611: Error enabling STATISTICS report\n<\/pre>\nSP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled <\/em><\/span><\/p>\nSP2-0611: Error enabling STATISTICS report<\/em><\/span><\/p>\nMake some adjustments to fix the error.<\/p>\n
[Primary] SQL> conn \/ as sysdba\nConnected.\n[Primary] SQL> show user\nUSER is \"SYS\"<\/pre>\n[Primary] SQL> create role plustrace;\n\nRole created.\n\n[Primary] SQL> grant select on v_$sesstat to plustrace;\n\nGrant succeeded.\n\n[Primary] SQL> grant select on v_$statname to plustrace;\n\nGrant succeeded.\n\n[Primary] SQL> grant select on v_$session to plustrace;\n\nGrant succeeded.\n\n[Primary] SQL> grant select on v_$mystat to plustrace;\n\nGrant succeeded.\n\n[Primary] SQL> grant plustrace to dba with admin option;\n\nGrant succeeded.\n\n[Primary] SQL> grant plustrace to tempundo;\n\nGrant succeeded.\n<\/pre>\nSwitch to TEMPUNDO user and open trace.<\/p>\n
[Primary] SQL> conn tempundo\/1;\nConnected.\n[Primary] SQL> show user\nUSER is \"TEMPUNDO\"\n\n[Primary] SQL> set autotrace on statistics;\n<\/pre>\nStep7:<\/strong> Insert into temp table to see statistics.<\/p>\n[Primary] SQL> INSERT INTO my_temp_table\n 2 WITH data AS (\n 3 SELECT 1 AS id\n 4 FROM dual\n 5 CONNECT BY level < 10000\n 6 )\n 7 SELECT rownum, TO_CHAR(rownum)\n 8 FROM data a, data b\n 9 WHERE rownum <= 1000000;\n\n1000000 rows created.\n\n\nStatistics\n----------------------------------------------------------\n 22 recursive calls\n 15687 db block gets\n 2359 consistent gets\n 343 physical reads\n 3070280 redo size\n 861 bytes sent via SQL*Net to client\n 986 bytes received via SQL*Net from client\n 3 SQL*Net roundtrips to\/from client\n 3 sorts (memory)\n 0 sorts (disk)\n 1000000 rows processed<\/pre>\nStep8:<\/strong> Let’s see how much Undo is produced for this Redo produced.<\/p>\n[Primary] SQL> SELECT t.used_ublk,\n 2 t.used_urec\n 3 FROM v$transaction t,\n 4 v$session s\n 5 WHERE s.saddr = t.ses_addr\n 6 AND s.audsid = SYS_CONTEXT('USERENV', 'SESSIONID');\n\n USED_UBLK USED_UREC\n---------- ----------\n 653 12476\n<\/pre>\nUSED_UBLK:<\/strong> Number of Undo Blocks UsedUSED_UREC:<\/strong> Undo Records Used<\/p>\nStep9:<\/strong> Set the TEMP_UNDO_ENABLED parameter to true and let’s see the REDO produced as a result of the same test.<\/p>\n[Primary] SQL> conn \/ as sysdba\nConnected.\n[Primary] SQL> alter system set temp_undo_enabled=TRUE scope=both;\n\nSystem altered.\n\n[Primary] SQL> show parameter temp_undo\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\ntemp_undo_enabled boolean TRUE\n<\/pre>\nStep10:<\/strong> Login with the TEMPUNDO user and open trace.<\/p>\n[Primary] SQL> conn tempundo\/1\nConnected.\n[Primary] SQL> show user\nUSER is \"TEMPUNDO\"\n\n[Primary] SQL> set autotrace on statistics<\/pre>\nStep11:<\/strong> Insert into temp table to see produced redo.<\/p>\n[Primary] SQL> INSERT INTO my_temp_table\n 2 WITH data AS (\n 3 SELECT 1 AS id\n 4 FROM dual\n 5 CONNECT BY level < 10000\n 6 )\n 7 SELECT rownum, TO_CHAR(rownum)\n 8 FROM data a, data b\n 9 WHERE rownum <= 1000000;\n\n1000000 rows created.\n\n\nStatistics\n----------------------------------------------------------\n 23 recursive calls\n 15365 db block gets\n 2357 consistent gets\n 16 physical reads\n 528 redo size\n 857 bytes sent via SQL*Net to client\n 986 bytes received via SQL*Net from client\n 3 SQL*Net roundtrips to\/from client\n 3 sorts (memory)\n 0 sorts (disk)\n 1000000 rows processed\n<\/pre>\nAs can be seen, while TEMP_UNDO_ENABLED parameter is FALSE, 3070280 bytes REDO is produced as a result of the same bulk insert, and 528 bytes REDO is produced when the parameter is set to TRUE.<\/p>\n
Step12:<\/strong> The actual effect of the parameter is seen in the Active Data Guard Physical Standby Database.<\/p>\nQuery the current value of the parameter:<\/p>\n
[Physical] SQL> show parameter temp_undo\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\ntemp_undo_enabled boolean FALSE\n<\/pre>\nStep13:<\/strong> Check whether the “user and the table” created on the primary side are on the Standby side.<\/p>\n[Physical] SQL> select username from dba_users where username='TEMPUNDO';\n\nUSERNAME\n--------------------------------------------------------------------------------\nTEMPUNDO\n\n[Physical] SQL> select object_name from dba_objects where owner='TEMPUNDO';\n\nOBJECT_NAME\n--------------------------------------------------------------------------------\nMY_TEMP_TABLE<\/pre>\nStep14:<\/strong> Open the trace by connecting with the TEMPUNDO user.<\/p>\n[Physical] SQL> conn tempundo\/1\nConnected.\n[Physical] SQL> show user\nUSER is \"TEMPUNDO\"\n\n[Physical] SQL> set autotrace on statistics<\/pre>\nStep15:<\/strong> Bulk insert in the same way.<\/p>\n[Physical] SQL> INSERT INTO my_temp_table\n 2 WITH data AS (\n 3 SELECT 1 AS id\n 4 FROM dual\n 5 CONNECT BY level < 10000\n 6 )\n 7 SELECT rownum, TO_CHAR(rownum)\n 8 FROM data a, data b\n 9 WHERE rownum <= 1000000;\n\n1000000 rows created.\n\n\nStatistics\n----------------------------------------------------------\n 23 recursive calls\n 15397 db block gets\n 2341 consistent gets\n 152 physical reads\n 0 redo size\n 857 bytes sent via SQL*Net to client\n 987 bytes received via SQL*Net from client\n 3 SQL*Net roundtrips to\/from client\n 3 sorts (memory)\n 0 sorts (disk)\n 1000000 rows processed\n<\/pre>\nSince REDO is not produced, data can be inserted into this TEMPORARY table.<\/p>\n<\/div>\n<\/div>\n
<\/div>\n
<\/path><\/svg><\/i> <\/div>\n","protected":false},"excerpt":{"rendered":"
What is Oracle Active Data Guard? Oracle Active Data Guard is a Physical Standby Option available with Enterprise Edition. Thanks to Active Data Guard, we do not leave Data Guard idle. It contains many features like below. It licensed. Active Data Guard provides automatic block repair feature. With this feature, a DML operation on the …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> <\/div>\n","protected":false},"author":484,"featured_media":15042,"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":[8732,8710,8715,8719,8714,8712,8713,8760,8757,8711,8704,8706,8707,8705,8709,7491,8779,8747,8731,8741,8739,8740,8777,8763,8775,8750,8751,8728,8729,8730,8783,8773,8758,8726,8745,8723,8746,8744,8717,8748,8749,8721,8720,8722,8724,8725,8727,8776,3905,8772,8762,8761,8774,8754,8734,7591,8718,8755,8716,8756,8708,8742,8753,8752,8738,8759,8737,8733,8782,8781,8780,8778,8743,8765,8771,8766,8770,8764,8767,8769,8768,8736,8735,8784,8785],"class_list":["post-15037","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-activate-active-data-guard-11g","tag-active-data-guard","tag-active-data-guard-12c","tag-active-data-guard-block-corruption","tag-active-data-guard-configuration-steps-in-oracle-11g","tag-active-data-guard-in-oracle","tag-active-data-guard-setup-in-oracle-11g","tag-active-data-guard-temp-tablespace","tag-active-data-guard-temporary-tables","tag-active-data-guard-vs-data-guard","tag-automatic-block-repair","tag-automatic-block-repair-11g","tag-automatic-block-repair-12c","tag-automatic-block-repair-active-data-guard","tag-automatic-block-repair-oracle-11g","tag-best-practices-for-synchronous-redo-transport-data-guard-and-active-data-guard","tag-cannot-find-the-session-identifier-check-plustrace-role-is-enabled","tag-check-standby-database-recovery-mode","tag-configure-active-data-guard-11gr2","tag-convert-physical-standby-database-to-active-data-guard","tag-convert-physical-standby-into-active-data-guard","tag-convert-physical-standby-to-active-data-guard","tag-creating-temp-table-in-oracle-sql","tag-database-open-for-read-only-access","tag-database-or-pluggable-database-open-for-read-only-access","tag-disable-active-data-guard","tag-disable-active-data-guard-option","tag-enable-active-data-guard","tag-enable-active-data-guard-11g","tag-enable-active-data-guard-option","tag-error-enabling-statistics-report","tag-error-occurred-at-recursive-sql-level-1","tag-global-temporary-table-active-data-guard","tag-how-to-activate-active-data-guard","tag-how-to-change-physical-standby-to-active-data-guard","tag-how-to-configure-oracle-active-data-guard","tag-how-to-convert-physical-standby-database-to-active-data-guard","tag-how-to-convert-physical-standby-to-active-data-guard","tag-how-to-create-standby-database-in-oracle","tag-how-to-disable-active-data-guard","tag-how-to-disable-oracle-active-data-guard","tag-how-to-enable-active-data-guard-in-oracle","tag-how-to-enable-active-data-guard","tag-how-to-install-oracle-active-data-guard","tag-how-to-setup-active-data-guard-oracle","tag-how-to-setup-active-data-guard-oracle-11g","tag-how-to-turn-off-active-data-guard","tag-on-commit-delete-rows","tag-ora-00604","tag-ora-00604-error-occurred-at-recursive-sql-level-1","tag-ora-16000","tag-ora-16000-database-open-for-read-only-access","tag-ora-16000-database-or-pluggable-database-open-for-read-only-access","tag-oracle-11g-disable-active-data-guard","tag-oracle-11gr2-active-data-guard-setup","tag-oracle-active-data-guard-automatic-block-repair","tag-oracle-active-data-guard-block-corruption","tag-oracle-active-data-guard-global-temporary-tables","tag-oracle-active-data-guard-setup-step-by-step","tag-oracle-active-data-guard-temporary-tables","tag-oracle-automatic-block-repair","tag-oracle-convert-physical-standby-to-active-data-guard","tag-oracle-disable-active-data-guard","tag-oracle-disable-active-data-guard-option","tag-oracle-enable-active-data-guard","tag-oracle-global-temporary-table-in-active-data-guard","tag-oracle-turn-off-active-data-guard","tag-setup-active-data-guard-oracle-11g","tag-sp2-0611","tag-sp2-0611-error-enabling-statistics-report","tag-sp2-0618","tag-sp2-0618-cannot-find-the-session-identifier-check-plustrace-role-is-enabled","tag-steps-to-convert-physical-standby-to-active-data-guard","tag-temp_undo_enabled","tag-temp_undo_enabled-12-2","tag-temp_undo_enabled-12c","tag-temp_undo_enabled-18c","tag-temp_undo_enabled-in-oracle-12c","tag-temp_undo_enabled-oracle","tag-temp_undo_enabledfalse","tag-temp_undo_enabledtrue","tag-turn-off-active-data-guard","tag-turn-on-active-data-guard","tag-used_ublk","tag-used_urec"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":2831,"today_views":0},"yoast_head":"\n
Oracle Active Data Guard - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Oracle Active Data Guard\" \/>\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\/02\/17\/oracle-active-data-guard\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Active Data Guard - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Oracle Active Data Guard\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-17T07:09:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-02-17T11:07:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-12.png\" \/>\n\t<meta property=\"og:image:width\" content=\"560\" \/>\n\t<meta property=\"og:image:height\" content=\"317\" \/>\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=\"10 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\/02\/17\/oracle-active-data-guard\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Oracle Active Data Guard\",\"datePublished\":\"2020-02-17T07:09:54+00:00\",\"dateModified\":\"2020-02-17T11:07:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/\"},\"wordCount\":976,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-12.png\",\"keywords\":[\"activate active data guard 11g\",\"active data guard\",\"active data guard 12c\",\"active data guard block corruption\",\"active data guard configuration steps in oracle 11g\",\"active data guard in oracle\",\"active data guard setup in oracle 11g\",\"active data guard temp tablespace\",\"active data guard temporary tables\",\"active data guard vs data guard\",\"automatic block repair\",\"automatic block repair 11g\",\"automatic block repair 12c\",\"automatic block repair active data guard\",\"automatic block repair oracle 11g\",\"best practices for synchronous redo transport data guard and active data guard\",\"Cannot find the Session Identifier. Check PLUSTRACE role is enabled\",\"check standby database recovery mode\",\"configure active data guard 11gr2\",\"convert physical standby database to active data guard\",\"Convert Physical Standby into Active Data Guard\",\"convert physical standby to active data guard\",\"creating temp table in oracle sql\",\"database open for read-only access\",\"database or pluggable database open for read-only access\",\"disable active data guard\",\"disable active data guard option\",\"enable active data guard\",\"enable active data guard 11g\",\"enable active data guard option\",\"Error enabling STATISTICS report\",\"error occurred at recursive SQL level 1\",\"global temporary table active data guard\",\"how to activate active data guard\",\"how to change physical standby to active data guard\",\"how to configure oracle active data guard\",\"how to convert physical standby database to active data guard\",\"how to convert physical standby to active data guard\",\"how to create standby database in oracle\",\"How To Disable Active Data Guard\",\"how to disable oracle active data guard\",\"how to enable active data guard in oracle\",\"How To Enable Active Data Guard?\",\"how to install oracle active data guard\",\"how to setup active data guard oracle\",\"how to setup active data guard oracle 11g\",\"how to turn off active data guard\",\"ON COMMIT DELETE ROWS\",\"ORA-00604:\",\"ORA-00604: error occurred at recursive SQL level 1\",\"ORA-16000\",\"ORA-16000: database open for read-only access\",\"ORA-16000: database or pluggable database open for read-only access\",\"oracle 11g disable active data guard\",\"oracle 11gr2 active data guard setup\",\"oracle active data guard automatic block repair\",\"oracle active data guard block corruption\",\"oracle active data guard global temporary tables\",\"oracle active data guard setup step by step\",\"oracle active data guard temporary tables\",\"oracle automatic block repair\",\"oracle convert physical standby to active data guard\",\"oracle disable active data guard\",\"oracle disable active data guard option\",\"oracle enable active data guard\",\"oracle global temporary table in active data guard\",\"oracle turn off active data guard\",\"setup active data guard oracle 11g\",\"SP2-0611\",\"SP2-0611: Error enabling STATISTICS report\",\"SP2-0618\",\"SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled\",\"steps to convert physical standby to active data guard\",\"temp_undo_enabled\",\"temp_undo_enabled 12.2\",\"temp_undo_enabled 12c\",\"temp_undo_enabled 18c\",\"temp_undo_enabled in oracle 12c\",\"temp_undo_enabled oracle\",\"temp_undo_enabled=false\",\"temp_undo_enabled=true\",\"turn off active data guard\",\"turn on active data guard\",\"USED_UBLK\",\"USED_UREC\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/\",\"name\":\"Oracle Active Data Guard - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-12.png\",\"datePublished\":\"2020-02-17T07:09:54+00:00\",\"dateModified\":\"2020-02-17T11:07:55+00:00\",\"description\":\"Oracle Active Data Guard\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-12.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-12.png\",\"width\":560,\"height\":317},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Active Data Guard\"}]},{\"@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 Active Data Guard - Database Tutorials","description":"Oracle Active Data Guard","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\/02\/17\/oracle-active-data-guard\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Active Data Guard - Database Tutorials","og_description":"Oracle Active Data Guard","og_url":"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/","og_site_name":"Database Tutorials","article_published_time":"2020-02-17T07:09:54+00:00","article_modified_time":"2020-02-17T11:07:55+00:00","og_image":[{"width":560,"height":317,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-12.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Oracle Active Data Guard","datePublished":"2020-02-17T07:09:54+00:00","dateModified":"2020-02-17T11:07:55+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/"},"wordCount":976,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-12.png","keywords":["activate active data guard 11g","active data guard","active data guard 12c","active data guard block corruption","active data guard configuration steps in oracle 11g","active data guard in oracle","active data guard setup in oracle 11g","active data guard temp tablespace","active data guard temporary tables","active data guard vs data guard","automatic block repair","automatic block repair 11g","automatic block repair 12c","automatic block repair active data guard","automatic block repair oracle 11g","best practices for synchronous redo transport data guard and active data guard","Cannot find the Session Identifier. Check PLUSTRACE role is enabled","check standby database recovery mode","configure active data guard 11gr2","convert physical standby database to active data guard","Convert Physical Standby into Active Data Guard","convert physical standby to active data guard","creating temp table in oracle sql","database open for read-only access","database or pluggable database open for read-only access","disable active data guard","disable active data guard option","enable active data guard","enable active data guard 11g","enable active data guard option","Error enabling STATISTICS report","error occurred at recursive SQL level 1","global temporary table active data guard","how to activate active data guard","how to change physical standby to active data guard","how to configure oracle active data guard","how to convert physical standby database to active data guard","how to convert physical standby to active data guard","how to create standby database in oracle","How To Disable Active Data Guard","how to disable oracle active data guard","how to enable active data guard in oracle","How To Enable Active Data Guard?","how to install oracle active data guard","how to setup active data guard oracle","how to setup active data guard oracle 11g","how to turn off active data guard","ON COMMIT DELETE ROWS","ORA-00604:","ORA-00604: error occurred at recursive SQL level 1","ORA-16000","ORA-16000: database open for read-only access","ORA-16000: database or pluggable database open for read-only access","oracle 11g disable active data guard","oracle 11gr2 active data guard setup","oracle active data guard automatic block repair","oracle active data guard block corruption","oracle active data guard global temporary tables","oracle active data guard setup step by step","oracle active data guard temporary tables","oracle automatic block repair","oracle convert physical standby to active data guard","oracle disable active data guard","oracle disable active data guard option","oracle enable active data guard","oracle global temporary table in active data guard","oracle turn off active data guard","setup active data guard oracle 11g","SP2-0611","SP2-0611: Error enabling STATISTICS report","SP2-0618","SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled","steps to convert physical standby to active data guard","temp_undo_enabled","temp_undo_enabled 12.2","temp_undo_enabled 12c","temp_undo_enabled 18c","temp_undo_enabled in oracle 12c","temp_undo_enabled oracle","temp_undo_enabled=false","temp_undo_enabled=true","turn off active data guard","turn on active data guard","USED_UBLK","USED_UREC"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/","url":"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/","name":"Oracle Active Data Guard - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-12.png","datePublished":"2020-02-17T07:09:54+00:00","dateModified":"2020-02-17T11:07:55+00:00","description":"Oracle Active Data Guard","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-12.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-12.png","width":560,"height":317},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/17\/oracle-active-data-guard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Active Data Guard"}]},{"@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\/15037","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=15037"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/15037\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/15042"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=15037"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=15037"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=15037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/img_5e4646bf81d68.png\")
<\/p>\n