{"id":733,"date":"2020-06-01T20:39:20","date_gmt":"2020-06-01T23:39:20","guid":{"rendered":"https:\/\/www.fernandosimon.com\/blog\/?p=733"},"modified":"2020-07-19T19:08:38","modified_gmt":"2020-07-19T22:08:38","slug":"db_unique_name-pdb-and-data-guard","status":"publish","type":"post","link":"https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/","title":{"rendered":"DB_UNIQUE_NAME, PDB, and Data Guard"},"content":{"rendered":"

When you change the parameters for the database is possible to specify the db_unique_name<\/em> and allow more control where you want to apply\/use it. This is very useful to limit the scope, but you need to be aware of some collateral effects. Even not present at the official doc<\/a>, you can use it. But check here some details that you need to take care of.<\/p>\n

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

<\/p>\n

Unplug and Plug<\/h2>\n

The environment below is a simple 19c single instance database. There, exists 3 PDB\u2019s and you can see the db_unique_name<\/em> for this CDB:<\/p>\n

SQL> show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\n         3 PDBDG                          READ WRITE NO\r\n         5 PDBMOVE                        READ WRITE NO\r\nSQL> show parameter db_unique_name;\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndb_unique_name                       string      or19dg\r\nSQL><\/pre>\n
And we can connect in the PDBMOVE and change the parameters. First, as usual, normal set without any special parameter:<\/p>\n
SQL> alter system set open_cursors = 300 scope = spfile;\r\n\r\nSystem altered.\r\n\r\nSQL><\/pre>\n
But, we can specify the db_unique_name for an alter system. ALTER SYSTEM\u2026 DB_UNIQUE_NAME = \u2018VALUE\u2019. <\/strong>Here you can see that I used the same that as defined for the root level.<\/p>\n
SQL> alter system set sessions = 100  scope = spfile db_unique_name = 'or19dg';\r\n\r\nSystem altered.\r\n\r\nSQL> alter system set cursor_sharing = FORCE scope = spfile db_unique_name = 'or19dg';\r\n\r\nSystem altered.\r\n\r\nSQL><\/pre>\n
Detail #1 here, if you specify the DB_UNIQUE_NAME the scope can be JUST spfile. Otherwise, you will receive an error.<\/p>\n
SQL> alter system set cursor_sharing = FORCE scope = both db_unique_name = 'or19dg';\r\nalter system set cursor_sharing = FORCE scope = both db_unique_name = 'or19dg'\r\n*\r\nERROR at line 1:\r\nORA-65147: DB_UNIQUE_NAME specified without SPFILE scope\r\n\r\n\r\nSQL><\/pre>\n
In this example, I set two parameters for PDB level and you can see at PDB_SPFILE$ inside of root cdb that values was set:<\/p>\n
SQL> alter session set container = cdb$root;\r\n\r\nSession altered.\r\n\r\nSQL> select DB_UNIQ_NAME, NAME, VALUE$, PDB_UID from PDB_SPFILE$ where PDB_UID = 2549618825;\r\n\r\nDB_UNIQ_NAME                   NAME                           VALUE$                                      PDB_UID\r\n------------------------------ ------------------------------ ---------------------------------------- ----------\r\n*                              open_cursors                   300                                      2549618825\r\nor19dg                         cursor_sharing                 'FORCE'                                  2549618825\r\nor19dg                         sessions                       100                                      2549618825\r\n\r\nSQL><\/pre>\n
And after the reload of the database the values are set:<\/p>\n
[oracle@orcl19p ~]$ srvctl stop database -d or19dg\r\n[oracle@orcl19p ~]$ srvctl start database -d or19dg\r\n[oracle@orcl19p ~]$ \r\n[oracle@orcl19p ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 1 17:33:29 2020\r\nVersion 19.5.0.0.0\r\n\r\nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.5.0.0.0\r\n\r\nSQL> show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\n         3 PDBDG                          READ WRITE NO\r\n         5 PDBMOVE                        READ WRITE NO\r\nSQL> alter session set container = PDBMOVE;\r\n\r\nSession altered.\r\n\r\nSQL> show parameter cursor_sharing;\r\n\r\nNAME                                 TYPE                             VALUE\r\n------------------------------------ -------------------------------- ------------------------------\r\ncursor_sharing                       string                           FORCE\r\nSQL><\/pre>\n
UNPLUG<\/h3>\n
But if I need to unplug the PDB, the values will be exported too, right? Yes, but no as you imagine.<\/p>\n
So, doing a simple unplug to XML:<\/p>\n
SQL> alter pluggable database PDBMOVE close immediate;\r\n\r\nPluggable database altered.\r\n\r\nSQL> alter pluggable database PDBMOVE unplug into '\/tmp\/pdbmove_par.xml';\r\n\r\nPluggable database altered.\r\n\r\nSQL> drop pluggable database PDBMOVE keep datafiles;\r\n\r\nPluggable database dropped.\r\n\r\nSQL><\/pre>\n
And checking the file for these parameters at generated XML:<\/p>\n
[oracle@orcl19p ~]$ cat \/tmp\/pdbmove_par.xml |grep open_cursors\r\n      <spfile>*.open_cursors=300#HWM:300,<\/spfile>\r\n[oracle@orcl19p ~]$ cat \/tmp\/pdbmove_par.xml |grep cursor_sharing\r\n      <spfile>*.cursor_sharing='FORCE'<\/spfile>\r\n[oracle@orcl19p ~]$ cat \/tmp\/pdbmove_par.xml |grep sessions\r\n      <spfile>*.sessions=100#HWM:100,flag:1,<\/spfile>\r\n[oracle@orcl19p ~]$<\/pre>\n
As you can see here, the parameters were exported, but the parameter changed to \u201c*\u201d. The definition of specific db_unique_name was cleared.<\/p>\n
And if we try to plug again the same PDB, we can see that parameter was loaded as \u201c*\u201d:<\/p>\n
SQL> create  pluggable database PDBMOVE USING '\/tmp\/pdbmove_par.xml' NOCOPY TEMPFILE REUSE;\r\n\r\nPluggable database created.\r\n\r\nSQL> col name format a30\r\nSQL> col VALUE$ format a40\r\nSQL> set linesize 250\r\nSQL> select CON_ID,DBID,CON_UID,GUID,NAME from v$pdbs;\r\n\r\n    CON_ID       DBID    CON_UID GUID                             NAME\r\n---------- ---------- ---------- -------------------------------- ------------------------------\r\n         2  826464235  826464235 9B151A78B6DB533AE0533205A00AFC30 PDB$SEED\r\n         3 1340021208 1340021208 9B155010BEAC661BE0533205A00AF21B PDBDG\r\n         4 2549618825 3364812106 A7082B6C610C5E1DE0533205A00AF7FE PDBMOVE\r\n\r\nSQL> show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\n         3 PDBDG                          READ WRITE NO\r\n         4 PDBMOVE                        MOUNTED\r\nSQL> alter pluggable database PDBMOVE open;\r\n\r\nPluggable database altered.\r\n\r\nSQL> select DB_UNIQ_NAME, NAME, VALUE$, PDB_UID from PDB_SPFILE$ where PDB_UID = 3364812106;\r\n\r\nDB_UNIQ_NAME                   NAME                           VALUE$                                      PDB_UID\r\n------------------------------ ------------------------------ ---------------------------------------- ----------\r\n*                              cursor_sharing                 'FORCE'                                  3364812106\r\n*                              open_cursors                   300                                      3364812106\r\n*                              sessions                       100                                      3364812106\r\n\r\nSQL><\/pre>\n
DATAGUARD<\/h2>\n
As you can imagine, using the db_unique_name for an alter system can affect the dataguard environments. If you know, the db_unique_name is different between primary and standby. So, if you define some parameter, depending on the way that you made, after you, switchover\/failover can occur that parameter returns to the default value.<\/p>\n
It is not the case that this is wrong, maybe you need to set some parameters for one server\/side in specific. Maybe because of less memory, less CPU power, or whatever the reason.<\/p>\n
In this example, I have gold19c as primary<\/strong>, and golds19c as standby<\/strong>. And I have the GOLD19P as used PDB here:<\/p>\n
[oracle@goldpn1 ~]$ dgmgrl sys\/oracle@gold19c\r\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon Jun 1 19:13:39 2020\r\nVersion 19.7.0.0.0\r\n\r\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nWelcome to DGMGRL, type \"help\" for information.\r\nConnected to \"GOLD19C\"\r\nConnected as SYSDBA.\r\nDGMGRL> show configuration;\r\n\r\nConfiguration - gold19c\r\n\r\n  Protection Mode: MaxAvailability\r\n  Members:\r\n  gold19c  - Primary database\r\n    golds19c - Physical standby database\r\n\r\nFast-Start Failover:  Disabled\r\n\r\nConfiguration Status:\r\nSUCCESS   (status updated 72 seconds ago)\r\n\r\nDGMGRL> exit\r\n[oracle@goldpn1 ~]$\r\n[oracle@goldpn1 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 1 19:16:50 2020\r\nVersion 19.7.0.0.0\r\n\r\nCopyright (c) 1982, 2020, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.7.0.0.0\r\n\r\nSQL> show parameter db_name\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndb_name                              string      gold19c\r\nSQL> show parameter db_unique_name\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndb_unique_name                       string      GOLD19C\r\nSQL>\r\nSQL> show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\n         3 GOLD19P                        READ WRITE NO\r\nSQL> col name format a30\r\nSQL> col VALUE$ format a40\r\nSQL> set linesize 250\r\nSQL> select CON_ID,DBID,CON_UID,GUID,NAME from v$pdbs;\r\n\r\n    CON_ID       DBID    CON_UID GUID                             NAME\r\n---------- ---------- ---------- -------------------------------- ------------------------------\r\n         2 2661745537 2661745537 A6B13C68753F63D3E0530A07A00A6303 PDB$SEED\r\n         3 2141275600 2141275600 A6B19FBF38306073E0530C07A00ACE20 GOLD19P\r\n\r\nSQL> \r\n<\/pre>\n
And to set the parameters I used the same than before, with and without db_unique_name:<\/p>\n
SQL> alter session set container = GOLD19P;\r\n\r\nSession altered.\r\n\r\nSQL> alter system set open_cursors = 300 scope = spfile;\r\n\r\nSystem altered.\r\n\r\nSQL> alter system set cursor_sharing = FORCE scope = spfile db_unique_name = 'GOLD19C';\r\n\r\nSystem altered.\r\n\r\nSQL><\/pre>\n
And as you can see, the parameter was stored.<\/p>\n
SQL> alter session set container = cdb$root;\r\n\r\nSession altered.\r\n\r\nSQL> select DB_UNIQ_NAME, NAME, VALUE$, PDB_UID from PDB_SPFILE$ where PDB_UID = 2141275600;\r\n\r\nDB_UNIQ_NAME                   NAME                           VALUE$                                      PDB_UID\r\n------------------------------ ------------------------------ ---------------------------------------- ----------\r\n*                              open_cursors                   300                                      2141275600\r\nGOLD19C                        cursor_sharing                 'FORCE'                                  2141275600\r\n\r\nSQL><\/pre>\n
But if I made the switchover:<\/p>\n
[oracle@goldpn1 ~]$ dgmgrl sys\/oracle@gold19c\r\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon Jun 1 19:24:15 2020\r\nVersion 19.7.0.0.0\r\n\r\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nWelcome to DGMGRL, type \"help\" for information.\r\nConnected to \"GOLD19C\"\r\nConnected as SYSDBA.\r\nDGMGRL> switchover to golds19c;\r\nPerforming switchover NOW, please wait...\r\nOperation requires a connection to database \"golds19c\"\r\nConnecting ...\r\nConnected to \"GOLDS19C\"\r\nConnected as SYSDBA.\r\nNew primary database \"golds19c\" is opening...\r\nOracle Clusterware is restarting database \"gold19c\" ...\r\nConnected to \"GOLD19C\"\r\nConnected to \"GOLD19C\"\r\nSwitchover succeeded, new primary is \"golds19c\"\r\nDGMGRL>\r\n<\/pre>\n
You can see that now, the value for the parameter cursor_sharing now have the default value because the db_unique_name does not hit what was defined:<\/p>\n
[oracle@goldsn1 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 1 19:35:01 2020\r\nVersion 19.7.0.0.0\r\n\r\nCopyright (c) 1982, 2020, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.7.0.0.0\r\n\r\nSQL> show parameter db_name\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndb_name                              string      gold19c\r\nSQL> show parameter db_unique_name\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndb_unique_name                       string      GOLDS19C\r\nSQL>\r\nSQL> alter session set container = GOLD19P;\r\n\r\nSession altered.\r\n\r\nSQL> show parameter cursor_sharing;\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\ncursor_sharing                       string      EXACT\r\nSQL> show parameter open_cursors;\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\nopen_cursors                         integer     300\r\nSQL><\/pre>\n
But you can see that the parameter is defined at PDB_SPFILE$:<\/p>\n
SQL> alter session set container = cdb$root;\r\n\r\nSession altered.\r\n\r\nSQL>\r\nSQL> col name format a30\r\nSQL> col VALUE$ format a40\r\nSQL> set linesize 250\r\nSQL> select CON_ID,DBID,CON_UID,GUID,NAME from v$pdbs;\r\n\r\n    CON_ID       DBID    CON_UID GUID                             NAME\r\n---------- ---------- ---------- -------------------------------- ------------------------------\r\n         2 2661745537 2661745537 A6B13C68753F63D3E0530A07A00A6303 PDB$SEED\r\n         3 2141275600 2141275600 A6B19FBF38306073E0530C07A00ACE20 GOLD19P\r\n\r\nSQL> select DB_UNIQ_NAME, NAME, VALUE$, PDB_UID from PDB_SPFILE$ where PDB_UID = 2141275600;\r\n\r\nDB_UNIQ_NAME                   NAME                           VALUE$                                      PDB_UID\r\n------------------------------ ------------------------------ ---------------------------------------- ----------\r\n*                              open_cursors                   300                                      2141275600\r\nGOLD19C                        cursor_sharing                 'FORCE'                                  2141275600\r\n\r\nSQL><\/pre>\n
As showed, the value at standby is not defied, but as told before this can be expected behavior. Or no. If you want to set the parameter and it became a value in both, primary and standby, you don\u2019t need to specify the db_unique_name, otherwise when the switchover\/failover occurs the value will not be there. And, this can lead to some unexpected behaviors (at application side as an example) and need to troubleshoot (and until finding this about set parameter, can be a long path).<\/p>\n
Others points<\/h2>\n
The db_unique_name option does not check what you specify, so, take care to set the correct value. As you can see below I defined it as SIMON, and was accepted and saved:<\/p>\n
SQL> alter session set container = GOLD19P;\r\n\r\nSession altered.\r\n\r\nSQL> alter system set cursor_sharing = FORCE scope = spfile db_unique_name = 'SIMON';\r\n\r\nSystem altered.\r\n\r\nSQL> alter session set container = cdb$root;\r\n\r\nSession altered.\r\n\r\nSQL> select DB_UNIQ_NAME, NAME, VALUE$, PDB_UID from PDB_SPFILE$ where PDB_UID = 2141275600;\r\n\r\nDB_UNIQ_NAME                   NAME                           VALUE$                                      PDB_UID\r\n------------------------------ ------------------------------ ---------------------------------------- ----------\r\n*                              open_cursors                   300                                      2141275600\r\nGOLD19C                        cursor_sharing                 'FORCE'                                  2141275600\r\nSIMON                          cursor_sharing                 'FORCE'                                  2141275600\r\n\r\nSQL><\/pre>\n
And to reset, the process is similar. As you see below, you can specify the db_unique_name to delete specific. But if you specify nothing, the reset will be done for all.<\/p>\n
SQL> alter system reset cursor_sharing scope = spfile db_unique_name = 'GOLD19C';\r\n\r\nSystem altered.\r\n\r\nSQL> alter system reset cursor_sharing scope = spfile db_unique_name = 'GOLD19C';\r\nalter system reset cursor_sharing scope = spfile db_unique_name = 'GOLD19C'\r\n*\r\nERROR at line 1:\r\nORA-32010: cannot find entry to delete in SPFILE\r\n\r\n\r\nSQL> alter system set cursor_sharing = FORCE scope = spfile db_unique_name = 'GOLD19C';\r\n\r\nSystem altered.\r\n\r\nSQL> alter system reset cursor_sharing scope = spfile;\r\n\r\nSystem altered.\r\n\r\nSQL> alter system reset cursor_sharing scope = spfile db_unique_name = 'GOLD19C';\r\nalter system reset cursor_sharing scope = spfile db_unique_name = 'GOLD19C'\r\n*\r\nERROR at line 1:\r\nORA-32010: cannot find entry to delete in SPFILE\r\n\r\n\r\nSQL><\/pre>\n
Conclusion<\/h2>\n
Sometimes a simple definition can lead to some strange behaviors. Think that your application is running ok and after a switchover change completely the way how it works (cursor_sharing as above). And until you dig the solution can take time.<\/p>\n
Db_unique_name for set parameter<\/em> needs to be used carefully to avoid these cases. It is not the case that you never need to use it, sometimes this definition needs to be used. You can use it to prepare everything BEFORE the switchover to avoid some error or to tune the database since the beginning.<\/p>\n
References<\/h3>\n
Initialization parameters in a Multitenant database – FAQ and Examples (Doc ID 2101638.1)<\/a><\/p>\n
Initialization parameters in a Multitenant database – Facts and additional information (Doc ID 2101596.1)<\/a><\/p>\n
2.7 <\/span>Managing Initialization Parameters Using a Server Parameter File<\/a><\/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":"
When you change the parameters for the database is possible to specify the db_unique_name and allow more control where you want to apply\/use it. This is very useful to limit the scope, but you need to be aware of some collateral effects. Even not present at the official doc, you can use it. But check […]<\/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":[41,29,5],"tags":[67,66,65],"class_list":["post-733","post","type-post","status-publish","format-standard","hentry","category-data-guard","category-database","category-oracle","tag-data-guard","tag-database","tag-oracle"],"yoast_head":"\nDB_UNIQUE_NAME, PDB, and Data Guard - Fernando Simon<\/title>\n<meta name=\"description\" content=\"Check how db_unique_name used during the "alter system" at parameter definition can maybe lead to unexpected ways for PDB and 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:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DB_UNIQUE_NAME, PDB, and Data Guard - Fernando Simon\" \/>\n<meta property=\"og:description\" content=\"Check how db_unique_name used during the "alter system" at parameter definition can maybe lead to unexpected ways for PDB and Data Guard.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/\" \/>\n<meta property=\"og:site_name\" content=\"Fernando Simon\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-01T23:39:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-19T22:08:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/06\/set_parameter_clause.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=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/db_unique_name-pdb-and-data-guard\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/db_unique_name-pdb-and-data-guard\\\/\"},\"author\":{\"name\":\"Simon\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#\\\/schema\\\/person\\\/386da956604bca0d5be5dd52210c1dd9\"},\"headline\":\"DB_UNIQUE_NAME, PDB, and Data Guard\",\"datePublished\":\"2020-06-01T23:39:20+00:00\",\"dateModified\":\"2020-07-19T22:08:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/db_unique_name-pdb-and-data-guard\\\/\"},\"wordCount\":830,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/db_unique_name-pdb-and-data-guard\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/set_parameter_clause.png\",\"keywords\":[\"Data Guard\",\"Database\",\"Oracle\"],\"articleSection\":[\"Data Guard\",\"Database\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/db_unique_name-pdb-and-data-guard\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/db_unique_name-pdb-and-data-guard\\\/\",\"url\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/db_unique_name-pdb-and-data-guard\\\/\",\"name\":\"DB_UNIQUE_NAME, PDB, and Data Guard - Fernando Simon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/db_unique_name-pdb-and-data-guard\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/db_unique_name-pdb-and-data-guard\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/set_parameter_clause.png\",\"datePublished\":\"2020-06-01T23:39:20+00:00\",\"dateModified\":\"2020-07-19T22:08:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#\\\/schema\\\/person\\\/386da956604bca0d5be5dd52210c1dd9\"},\"description\":\"Check how db_unique_name used during the \\\"alter system\\\" at parameter definition can maybe lead to unexpected ways for PDB and Data Guard.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/db_unique_name-pdb-and-data-guard\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/db_unique_name-pdb-and-data-guard\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/db_unique_name-pdb-and-data-guard\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/set_parameter_clause.png\",\"contentUrl\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/set_parameter_clause.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/db_unique_name-pdb-and-data-guard\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DB_UNIQUE_NAME, PDB, and 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":"DB_UNIQUE_NAME, PDB, and Data Guard - Fernando Simon","description":"Check how db_unique_name used during the \"alter system\" at parameter definition can maybe lead to unexpected ways for PDB and 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:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/","og_locale":"en_US","og_type":"article","og_title":"DB_UNIQUE_NAME, PDB, and Data Guard - Fernando Simon","og_description":"Check how db_unique_name used during the \"alter system\" at parameter definition can maybe lead to unexpected ways for PDB and Data Guard.","og_url":"https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/","og_site_name":"Fernando Simon","article_published_time":"2020-06-01T23:39:20+00:00","article_modified_time":"2020-07-19T22:08:38+00:00","og_image":[{"url":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/06\/set_parameter_clause.png","type":"","width":"","height":""}],"author":"Simon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Simon","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/#article","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/"},"author":{"name":"Simon","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"headline":"DB_UNIQUE_NAME, PDB, and Data Guard","datePublished":"2020-06-01T23:39:20+00:00","dateModified":"2020-07-19T22:08:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/"},"wordCount":830,"commentCount":0,"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/06\/set_parameter_clause.png","keywords":["Data Guard","Database","Oracle"],"articleSection":["Data Guard","Database","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/","url":"https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/","name":"DB_UNIQUE_NAME, PDB, and Data Guard - Fernando Simon","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/#primaryimage"},"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/06\/set_parameter_clause.png","datePublished":"2020-06-01T23:39:20+00:00","dateModified":"2020-07-19T22:08:38+00:00","author":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"description":"Check how db_unique_name used during the \"alter system\" at parameter definition can maybe lead to unexpected ways for PDB and Data Guard.","breadcrumb":{"@id":"https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/#primaryimage","url":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/06\/set_parameter_clause.png","contentUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/06\/set_parameter_clause.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.fernandosimon.com\/blog\/db_unique_name-pdb-and-data-guard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fernandosimon.com\/blog\/"},{"@type":"ListItem","position":2,"name":"DB_UNIQUE_NAME, PDB, and 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-bP","_links":{"self":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/733","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=733"}],"version-history":[{"count":0,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/733\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/media?parent=733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/categories?post=733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/tags?post=733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}