{"id":892,"date":"2021-08-22T19:11:53","date_gmt":"2021-08-22T22:11:53","guid":{"rendered":"https:\/\/www.fernandosimon.com\/blog\/?p=892"},"modified":"2021-08-22T19:11:53","modified_gmt":"2021-08-22T22:11:53","slug":"21c-prepare-database-for-data-guard","status":"publish","type":"post","link":"https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/","title":{"rendered":"21c, PREPARE DATABASE FOR DATA GUARD"},"content":{"rendered":"

With the release of Oracle 21c is time for us to start to check the new features. Besides 21c is an innovative release, it shows what we will use in the future in daily activities. For Data Guard and Broker one new feature is the PREPARE DATABASE FOR DATA GUARD<\/strong> that adjusts the database and some parameters to become primary. Release notes can be checked here<\/a>.<\/p>\n

\"\"<\/a><\/p>\n

<\/p>\n

I created one simple database for this test and you can see below that not in archivelog mode, the Broker is not configured, and the flashback is off. For later comparison I create one pfile as well:<\/p>\n

[oracle@orcl19s ~]$ export ORACLE_HOME=\/u01\/app\/oracle\/product\/21.0.0.0\/dbhome_1\r\n[oracle@orcl19s ~]$ export ORACLE_BASE=\/u01\/app\/oracle\r\n[oracle@orcl19s ~]$ export PATH=$ORACLE_HOME\/bin:$ORACLE_HOME\/OPatch:$PATH\r\n[oracle@orcl19s ~]$ export ORACLE_SID=dg21nf1\r\n[oracle@orcl19s ~]$\r\n[oracle@orcl19s ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 21.0.0.0.0 - Production on Sun Aug 22 17:29:38 2021\r\nVersion 21.3.0.0.0\r\n\r\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production\r\nVersion 21.3.0.0.0\r\n\r\nSQL> archive log list;\r\nDatabase log mode              No Archive Mode\r\nAutomatic archival             Disabled\r\nArchive destination            \/u01\/app\/oracle\/homes\/OraDB21Home1\/dbs\/arch\r\nOldest online log sequence     11\r\nCurrent log sequence           13\r\nSQL>\r\nSQL> \r\nSQL> select FLASHBACK_ON, DATAGUARD_BROKER, DB_UNIQUE_NAME from v$database;\r\n\r\nFLASHBACK_ON       DATAGUAR DB_UNIQUE_NAME\r\n------------------ -------- ------------------------------\r\nNO                 DISABLED dg21nf\r\n\r\nSQL>\r\nSQL>\r\nSQL> create pfile = '\/tmp\/pfile-dg21nf.ora' from spfile;\r\n\r\nFile created.\r\n\r\nSQL><\/pre>\n
The prepare statement is to be used at the Broker directly (even if you have not configured it). The changes made by it follow the MAA best practices and you can define some parameters when you call the command.<\/p>\n
[oracle@orcl19s ~]$ dgmgrl \/\r\nDGMGRL for Linux: Release 21.0.0.0.0 - Production on Sun Aug 22 17:37:16 2021\r\nVersion 21.3.0.0.0\r\n\r\nCopyright (c) 1982, 2021, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nWelcome to DGMGRL, type \"help\" for information.\r\nConnected to \"dg21nf\"\r\nConnected as SYSDG.\r\nDGMGRL> help prepare\r\n\r\nPrepare a primary database for a Data Guard environment.\r\n\r\nSyntax:\r\n\r\n  PREPARE DATABASE FOR DATA GUARD\r\n    [WITH [DB_UNIQUE_NAME IS <db-unique-name>]\r\n          [DB_RECOVERY_FILE_DEST IS <directory-location>]\r\n          [DB_RECOVERY_FILE_DEST_SIZE IS <size>]\r\n          [BROKER_CONFIG_FILE_1 IS <broker-config-file-1-location>]\r\n          [BROKER_CONFIG_FILE_2 IS <broker-config-file-2-location>]];\r\n\r\n\r\nDGMGRL><\/pre>\n
The command has some parameters that can be used: DB_UNIQUE_NAME, DB_RECOVERY_FILE_DEST, DB_RECOVERY_FILE_DEST_SIZE, BROKER_CONFIG-FILE1 (and 2). Below, you can check how I called it:<\/p>\n
DGMGRL> PREPARE DATABASE FOR DATA GUARD\r\n> WITH\r\n>      DB_UNIQUE_NAME IS dg21nf\r\n>      DB_RECOVERY_FILE_DEST IS '+RECO'\r\n>      DB_RECOVERY_FILE_DEST_SIZE is 5G\r\n>      BROKER_CONFIG_FILE_1 is '+DATA'\r\n>      BROKER_CONFIG_FILE_2 is '+RECO'\r\n> ;\r\nPreparing database \"dg21nf\" for Data Guard.\r\nInitialization parameter DB_FILES set to 1024.\r\nInitialization parameter LOG_BUFFER set to 268435456.\r\nPrimary database must be restarted after setting static initialization parameters.\r\nPrimary database must be restarted to enable archivelog mode.\r\nShutting down database \"dg21nf\".\r\nDatabase stopped.\r\nStarting database \"dg21nf\" to mounted mode.\r\nDatabase started.\r\nInitialization parameter DB_FLASHBACK_RETENTION_TARGET set to 120.\r\nInitialization parameter DB_LOST_WRITE_PROTECT set to 'TYPICAL'.\r\nRMAN configuration archivelog deletion policy set to SHIPPED TO ALL STANDBY.\r\nInitialization parameter DB_RECOVERY_FILE_DEST_SIZE set to '5g'.\r\nInitialization parameter DB_RECOVERY_FILE_DEST set to '+RECO'.\r\nInitialization parameter DG_BROKER_CONFIG_FILE1 set to '+DATA'.\r\nInitialization parameter DG_BROKER_CONFIG_FILE2 set to '+RECO'.\r\nLOG_ARCHIVE_DEST_n initialization parameter already set for local archival.\r\nInitialization parameter LOG_ARCHIVE_DEST_2 set to 'location=use_db_recovery_file_dest valid_for=(all_logfiles, all_roles)'.\r\nInitialization parameter LOG_ARCHIVE_DEST_STATE_2 set to 'Enable'.\r\nAdding standby log group size 209715200 and assigning it to thread 1.\r\nAdding standby log group size 209715200 and assigning it to thread 1.\r\nAdding standby log group size 209715200 and assigning it to thread 1.\r\nInitialization parameter STANDBY_FILE_MANAGEMENT set to 'AUTO'.\r\nInitialization parameter DG_BROKER_START set to TRUE.\r\nDatabase set to FORCE LOGGING.\r\nDatabase set to ARCHIVELOG.\r\nDatabase set to FLASHBACK ON.\r\nShutting down database \"dg21nf\".\r\nDatabase stopped.\r\nStarting database \"dg21nf\".\r\nDatabase started.\r\nDGMGRL><\/pre>\n
And you can see from the output above, the command restarted the database and set several parameters and database details. It put the database in archivelog mode, force logging, and flashback enabled. Some parameters for Broker and file management are set too. Another detail is that it will create the standby log groups too.<\/p>\n
Below you can see the difference between the pfile that I created before calling the commands, and one generate later (check for \u201c>\u201d<\/strong>). Check all the changes and additional parameters set:<\/p>\n
[oracle@orcl19s ~]$ diff \/tmp\/pfile-dg21nf.ora \/tmp\/pfile-dg21nf-after-prep.ora\r\n2c2\r\n< dg21nf1.__db_cache_size=1409286144\r\n---\r\n> dg21nf1.__db_cache_size=1258291200\r\n10,11c10,11\r\n< dg21nf1.__shared_io_pool_size=100663296\r\n< dg21nf1.__shared_pool_size=603979776\r\n---\r\n> dg21nf1.__shared_io_pool_size=83886080\r\n> dg21nf1.__shared_pool_size=486539264\r\n19a20,22\r\n> *.db_files=1024\r\n> *.db_flashback_retention_target=120\r\n> *.db_lost_write_protect='TYPICAL'\r\n20a24,28\r\n> *.db_recovery_file_dest_size=5368709120\r\n> *.db_recovery_file_dest='+RECO'\r\n> *.dg_broker_config_file1='+DATA'\r\n> *.dg_broker_config_file2='+RECO'\r\n> *.dg_broker_start=TRUE\r\n26a35,37\r\n> *.log_archive_dest_2='location=use_db_recovery_file_dest valid_for=(all_logfiles, all_roles)'\r\n> *.log_archive_dest_state_2='Enable'\r\n> *.log_buffer=268435456\r\n33a45\r\n> *.standby_file_management='AUTO'\r\n[oracle@orcl19s ~]$\r\n<\/pre>\n
Not all parameters that are needed for data guard creation was set (like LOG_ARCHIVE_CONFIG), but most of them are there. Be aware that you can\u2019t modify the values for these parameters when you call the command (like db_files parameter), you need to adjust them later. You can see more detailed info in the official doc<\/a>, and the command PREPARE DATABASE FOR DATA GUARD for 12.2+ databases since the dgmgrl is for Broker and not attached to any database at all.<\/p>\n
 <\/p>\n
Disclaimer<\/strong>: \u201cThe postings on this site are my own and don\u2019t necessarily represent my actual employer positions, strategies or opinions. The information here was edited to be useful for general purpose, specific data and identifications were removed to allow reach the generic audience and to be useful for the community. Post protected by copyright.\u201d<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"
With the release of Oracle 21c is time for us to start to check the new features. Besides 21c is an innovative release, it shows what we will use in the future in daily activities. For Data Guard and Broker one new feature is the PREPARE DATABASE FOR DATA GUARD that adjusts the database and […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[164,50,41,29,5],"tags":[166,85,67,65],"class_list":["post-892","post","type-post","status-publish","format-standard","hentry","category-21c","category-broker","category-data-guard","category-database","category-oracle","tag-21c","tag-broker","tag-data-guard","tag-oracle"],"yoast_head":"\n21c, PREPARE DATABASE FOR DATA GUARD - Fernando Simon<\/title>\n<meta name=\"description\" content=\"Check how to use the new feature and command PREPARE DATABASE FOR DATA GUARD for Oracle 21c Broker.\" \/>\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.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"21c, PREPARE DATABASE FOR DATA GUARD - Fernando Simon\" \/>\n<meta property=\"og:description\" content=\"Check how to use the new feature and command PREPARE DATABASE FOR DATA GUARD for Oracle 21c Broker.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/\" \/>\n<meta property=\"og:site_name\" content=\"Fernando Simon\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-22T22:11:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/database-evolution.png\" \/>\n<meta name=\"author\" content=\"Simon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Simon\" \/>\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.fernandosimon.com\\\/blog\\\/21c-prepare-database-for-data-guard\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-prepare-database-for-data-guard\\\/\"},\"author\":{\"name\":\"Simon\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#\\\/schema\\\/person\\\/386da956604bca0d5be5dd52210c1dd9\"},\"headline\":\"21c, PREPARE DATABASE FOR DATA GUARD\",\"datePublished\":\"2021-08-22T22:11:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-prepare-database-for-data-guard\\\/\"},\"wordCount\":405,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-prepare-database-for-data-guard\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/database-evolution.png\",\"keywords\":[\"21c\",\"Broker\",\"Data Guard\",\"Oracle\"],\"articleSection\":[\"21c\",\"Broker\",\"Data Guard\",\"Database\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-prepare-database-for-data-guard\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-prepare-database-for-data-guard\\\/\",\"url\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-prepare-database-for-data-guard\\\/\",\"name\":\"21c, PREPARE DATABASE FOR DATA GUARD - Fernando Simon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-prepare-database-for-data-guard\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-prepare-database-for-data-guard\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/database-evolution.png\",\"datePublished\":\"2021-08-22T22:11:53+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#\\\/schema\\\/person\\\/386da956604bca0d5be5dd52210c1dd9\"},\"description\":\"Check how to use the new feature and command PREPARE DATABASE FOR DATA GUARD for Oracle 21c Broker.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-prepare-database-for-data-guard\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-prepare-database-for-data-guard\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-prepare-database-for-data-guard\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/database-evolution.png\",\"contentUrl\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/database-evolution.png\",\"width\":333,\"height\":329},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-prepare-database-for-data-guard\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"21c, PREPARE DATABASE FOR DATA GUARD\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/\",\"name\":\"Fernando Simon\",\"description\":\"Have you hugged your backup today?\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#\\\/schema\\\/person\\\/386da956604bca0d5be5dd52210c1dd9\",\"name\":\"Simon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"caption\":\"Simon\"},\"sameAs\":[\"http:\\\/\\\/www.fernandosimon.com\"],\"url\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/author\\\/simon\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"21c, PREPARE DATABASE FOR DATA GUARD - Fernando Simon","description":"Check how to use the new feature and command PREPARE DATABASE FOR DATA GUARD for Oracle 21c Broker.","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.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/","og_locale":"en_US","og_type":"article","og_title":"21c, PREPARE DATABASE FOR DATA GUARD - Fernando Simon","og_description":"Check how to use the new feature and command PREPARE DATABASE FOR DATA GUARD for Oracle 21c Broker.","og_url":"https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/","og_site_name":"Fernando Simon","article_published_time":"2021-08-22T22:11:53+00:00","og_image":[{"url":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/database-evolution.png","type":"","width":"","height":""}],"author":"Simon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Simon","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/#article","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/"},"author":{"name":"Simon","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"headline":"21c, PREPARE DATABASE FOR DATA GUARD","datePublished":"2021-08-22T22:11:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/"},"wordCount":405,"commentCount":1,"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/database-evolution.png","keywords":["21c","Broker","Data Guard","Oracle"],"articleSection":["21c","Broker","Data Guard","Database","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/","url":"https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/","name":"21c, PREPARE DATABASE FOR DATA GUARD - Fernando Simon","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/#primaryimage"},"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/database-evolution.png","datePublished":"2021-08-22T22:11:53+00:00","author":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"description":"Check how to use the new feature and command PREPARE DATABASE FOR DATA GUARD for Oracle 21c Broker.","breadcrumb":{"@id":"https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/#primaryimage","url":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/database-evolution.png","contentUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/database-evolution.png","width":333,"height":329},{"@type":"BreadcrumbList","@id":"https:\/\/www.fernandosimon.com\/blog\/21c-prepare-database-for-data-guard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fernandosimon.com\/blog\/"},{"@type":"ListItem","position":2,"name":"21c, PREPARE DATABASE FOR DATA GUARD"}]},{"@type":"WebSite","@id":"https:\/\/www.fernandosimon.com\/blog\/#website","url":"https:\/\/www.fernandosimon.com\/blog\/","name":"Fernando Simon","description":"Have you hugged your backup today?","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fernandosimon.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9","name":"Simon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","caption":"Simon"},"sameAs":["http:\/\/www.fernandosimon.com"],"url":"https:\/\/www.fernandosimon.com\/blog\/author\/simon\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5ofTp-eo","_links":{"self":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/892","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/comments?post=892"}],"version-history":[{"count":0,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/892\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/media?parent=892"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/categories?post=892"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/tags?post=892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}