{"id":11572,"date":"2018-08-23T20:04:42","date_gmt":"2018-08-23T18:04:42","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/"},"modified":"2023-06-09T17:02:31","modified_gmt":"2023-06-09T15:02:31","slug":"oracle-18c-dataguard-with-nologging-mode","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/","title":{"rendered":"Oracle 18c DataGuard with Nologging Mode"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

With Oracle 18c database nologging has been extended with two new modes: Standby Nologging for Load Performance and Standby Nologging for Data Availability. These modes provide better support for use in an Oracle Active Data Guard environment without significantly increasing the amount of redo generated. In the documentation we can find following definitions:<\/p>\n

FORCE LOGGING mode prevents any load operation from being performed in a nonlogged manner. This can slow down the load process because the loaded data must be copied into the redo logs.<\/p>\n

STANDBY NOLOGGING FOR DATA AVAILABILITY mode causes the load operation to send the loaded data to each standby through its own connection to the standby. The commit is delayed until all the standbys have applied the data as part of running managed recovery in an Active Data Guard environment.<\/p>\n

STANDBY NOLOGGING FOR LOAD PERFORMANCE is similar to the previous mode except that the loading process can stop sending the data to the standbys if the network cannot keep up with the speed at which data is being loaded to the primary. In this mode it is possible that the standbys may have missing data, but each standby automatically fetches the data from the primary as a normal part of running managed recovery in an Active Data Guard environment.<\/p>\n

In this Blog I am doing a test with the mode STANDBY NOLOGGING FOR LOAD PERFORMANCE. I am using two virtual machines.
\nThis mode is enabled in the primary database using following command.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
SQL> ALTER DATABASE SET STANDBY NOLOGGING FOR LOAD PERFORMANCE;<\/code><\/div>\n
<\/div>\n
Database altered.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> db_unique_name,force_logging from <\/code>v<\/code>$database;<\/code><\/div>\n
<\/div>\n
DB_UNIQUE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FORCE_LOGGING<\/code><\/div>\n
------------------------------ ---------------------------------------<\/code><\/div>\n
CONT18C_SITE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STANDBY NOLOGGING FOR LOAD PERFORMANCE<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And then we build a Data Guard environment (steps not shown). Below the configuration of the Data Guard.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
DGMGRL> show configuration;<\/code><\/div>\n
<\/div>\n
Configuration - CONT18C_DR<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxPerformance<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>CONT18C_SITE\u00a0 - Primary database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CONT18C_SITE1 - Physical standby database<\/code><\/div>\n
<\/div>\n
Fast-Start Failover: DISABLED<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS\u00a0\u00a0 (status updated 3 seconds ago)<\/code><\/div>\n
<\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now that the Data Guard is build, let\u2019s do some nologging operation in the primary and let\u2019s see if there are replicated on the standby<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n<\/td>\n
\n
\n
SQL> show con_name<\/code><\/div>\n
<\/div>\n
CON_NAME<\/code><\/div>\n
------------------------------<\/code><\/div>\n
PDB1<\/code><\/div>\n
<\/div>\n
SQL> create tablespace TBS_NOLOG datafile <\/code>'\/u01\/app\/oracle\/oradata\/CONT18C\/PDB1\/tbs_nolog01.dbf'<\/code> size 5M nologging;<\/code><\/div>\n
<\/div>\n
Tablespace created.<\/code><\/div>\n
SQL> create table testnlog nologging tablespace TBS_NOLOG as <\/code>select<\/code> * from hr.EMPLOYEES;<\/code><\/div>\n
<\/div>\n
Table created.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

In the standby when we select the query we got following errors<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>select<\/code> db_unique_name,force_logging,open_mode from <\/code>v<\/code>$database;<\/code><\/div>\n
<\/div>\n
DB_UNIQUE_NAME\u00a0 FORCE_LOGGING\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 OPEN_MODE<\/code><\/div>\n
--------------- --------------------------------------- --------------------<\/code><\/div>\n
CONT18C_SITE1\u00a0\u00a0 STANDBY NOLOGGING FOR LOAD PERFORMANCE\u00a0 READ ONLY WITH APPLY<\/code><\/div>\n
<\/div>\n
SQL> show con_name<\/code><\/div>\n
<\/div>\n
CON_NAME<\/code><\/div>\n
------------------------------<\/code><\/div>\n
PDB1<\/code><\/div>\n
<\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> count(*) from testnlog;<\/code><\/div>\n
select<\/code> count(*) from testnlog<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>*<\/code><\/div>\n
ERROR at line 1:<\/code><\/div>\n
ORA-01578: ORACLE data block corrupted (<\/code>file<\/code> # 13, block # 163)<\/code><\/div>\n
ORA-01110: data <\/code>file<\/code> 13: <\/code>'\/u01\/app\/oracle\/oradata\/CONT18C\/PDB1\/tbs_nolog01.dbf'<\/code><\/div>\n
ORA-26040: Data block was loaded using the NOLOGGING option<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Why the replication did not work. In fact in this licencing document https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/18\/dblic\/Licensing-Information.html#GUID-0F9EB85D-4610-4EDF-89C2-4916A0E7AC87<\/p>\n

We can verify that the feature Oracle Data Guard\u2014Automatic Correction of Non-logged Blocks at a Data Guard Standby Database is available on Oracle Database Enterprise Edition on Engineered Systems (EE_ES) and in the Cloud.<\/p>\n

So let\u2019s simulate an Exadata using the hidden parameter “_exadata_feature_on\u201d on both servers (do not in production).<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
SQL> alter system <\/code>set<\/code> \"_exadata_feature_on\"<\/code>=<\/code>true<\/code> scope=spfile;<\/code><\/div>\n
<\/div>\n
System altered.<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

After both databases restart let\u2019s ty again
\nOn the primary database<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
SQL> drop table testnlog;<\/code><\/div>\n
<\/div>\n
Table dropped.<\/code><\/div>\n
<\/div>\n
SQL> create table testnlog nologging tablespace TBS_NOLOG as <\/code>select<\/code> * from hr.EMPLOYEES;<\/code><\/div>\n
<\/div>\n
Table created.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

On the standby, we can see that nologged data are now replicated<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>select<\/code> db_unique_name,force_logging,open_mode from <\/code>v<\/code>$database;<\/code><\/div>\n
<\/div>\n
DB_UNIQUE_NAME\u00a0 FORCE_LOGGING\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 OPEN_MODE<\/code><\/div>\n
--------------- --------------------------------------- --------------------<\/code><\/div>\n
CONT18C_SITE1\u00a0\u00a0 STANDBY NOLOGGING FOR LOAD PERFORMANCE\u00a0 READ ONLY WITH APPLY<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> count(*) from testnlog;<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>COUNT(*)<\/code><\/div>\n
----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>107<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Conclusion<\/strong> :
\nWith Oracle 18c, we can now configure database with no-logging mode. But this feature is only supported on following editions :<\/p>\n\n\n\n\n\n\n\n
Oracle Database Enterprise Edition on Engineered Systems<\/td>\nOn-Premises<\/td>\nEE-ES<\/strong><\/td>\nOracle Database Enterprise Edition software installed on an on-premises engineered system (Oracle Exadata Database Machine or Oracle Database Appliance).<\/td>\n<\/tr>\n
Oracle Database Cloud Service Enterprise Edition<\/td>\nCloud<\/td>\nDBCS EE<\/strong><\/td>\nIncludes Oracle Database Enterprise Edition software.<\/td>\n<\/tr>\n
Oracle Database Cloud Service Enterprise Edition – High Performance<\/td>\nCloud<\/td>\nDBCS EE-HP<\/strong><\/td>\nIncludes Oracle Database Enterprise Edition software plus many Oracle Database options and Oracle management packs.<\/td>\n<\/tr>\n
Oracle Database Cloud Service Enterprise Edition – Extreme Performance<\/td>\nCloud<\/td>\nDBCS EE-EP<\/strong><\/td>\nIncludes Oracle Database Enterprise Edition software plus all Oracle Database options and Oracle management packs that are appropriate for use in Oracle Database Cloud Service.<\/td>\n<\/tr>\n
Oracle Database Exadata Cloud Service<\/td>\nCloud<\/td>\nExaCS<\/strong><\/td>\nIncludes Oracle Database Enterprise Edition software plus all Oracle Database options and Oracle management packs that are appropriate for use in Oracle Database Exadata Cloud Service.<\/p>\n

The licensing policies for ExaCS also apply to Oracle Database Exadata Cloud at Customer.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw With Oracle 18c database nologging has been extended with two new modes: Standby Nologging for Load Performance and Standby Nologging for Data Availability. These modes provide better support for use in an Oracle Active Data Guard environment without significantly increasing the amount of redo generated. In the documentation we can find following […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[1381,1429,1430],"type_dbi":[],"class_list":["post-11572","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-active-data-guard","tag-nologging-mode","tag-oracle-broker"],"acf":[],"yoast_head":"\nOracle 18c DataGuard with Nologging Mode - dbi Blog<\/title>\n<meta name=\"description\" content=\"Active Data Guard, Oracle Broker,oracle 18c, nlogging mode\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 18c DataGuard with Nologging Mode\" \/>\n<meta property=\"og:description\" content=\"Active Data Guard, Oracle Broker,oracle 18c, nlogging mode\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-23T18:04:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-09T15:02:31+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 18c DataGuard with Nologging Mode\",\"datePublished\":\"2018-08-23T18:04:42+00:00\",\"dateModified\":\"2023-06-09T15:02:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/\"},\"wordCount\":601,\"commentCount\":0,\"keywords\":[\"Active Data Guard\",\"nologging mode\",\"Oracle Broker\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/\",\"name\":\"Oracle 18c DataGuard with Nologging Mode - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2018-08-23T18:04:42+00:00\",\"dateModified\":\"2023-06-09T15:02:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"Active Data Guard, Oracle Broker,oracle 18c, nlogging mode\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 18c DataGuard with Nologging Mode\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle 18c DataGuard with Nologging Mode - dbi Blog","description":"Active Data Guard, Oracle Broker,oracle 18c, nlogging mode","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 18c DataGuard with Nologging Mode","og_description":"Active Data Guard, Oracle Broker,oracle 18c, nlogging mode","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/","og_site_name":"dbi Blog","article_published_time":"2018-08-23T18:04:42+00:00","article_modified_time":"2023-06-09T15:02:31+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 18c DataGuard with Nologging Mode","datePublished":"2018-08-23T18:04:42+00:00","dateModified":"2023-06-09T15:02:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/"},"wordCount":601,"commentCount":0,"keywords":["Active Data Guard","nologging mode","Oracle Broker"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/","name":"Oracle 18c DataGuard with Nologging Mode - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-08-23T18:04:42+00:00","dateModified":"2023-06-09T15:02:31+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"Active Data Guard, Oracle Broker,oracle 18c, nlogging mode","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-with-nologging-mode\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 18c DataGuard with Nologging Mode"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11572","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11572"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11572\/revisions"}],"predecessor-version":[{"id":25779,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11572\/revisions\/25779"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11572"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}