Sometimes I ask myself why some bugs are not solved. When looking for DBT-16071 we find a blog post from Frank Pachot from more than 7 years ago. He shows that with Oracle 12.2 you can “create” standby databases directly with dbca. But that the script does only a duplicate for standby and nothing more.<\/p>\n\n\n\n
I decided to try with 19.22 to see how the situation evolved. It didn’t. <\/p>\n\n\n\n
The first thing I got was a DBT-16051 error:<\/p>\n\n\n
\n$ dbca -createDuplicateDB -gdbName anjodb01 -primaryDBConnectionString "anjovm01.local.wsl\/anjodb01_s1.local.wsl" -sid anjodb01 -createAsStandby -dbUniqueName anjodb01_s2 -silent\nEnter SYS user password:\n*****\n[FATAL] [DBT-16051] Archive log mode is not enabled in the primary database.\n ACTION: Primary database should be configured with archive log mode for creating a duplicate or standby database.\n\n<\/pre><\/div>\n\n\nQuick check shows the primary is correctly in archivelog mode. The problem is the Easy Connect string. The string I gave “anjovm1.local.wsl\/anjodb1_s1.local.wsl” works well on sqlplus, but not with dbca. There you need to specify the port, also when you are just using the default one:<\/p>\n\n\n
\n$ dbca -createDuplicateDB -gdbName anjodb01 -primaryDBConnectionString "anjovm01.local.wsl:1521\/anjodb01_s1.local.wsl" -sid anjodb01 -createAsStandby -dbUniqueName anjodb01_s2 -silent\nEnter SYS user password:\n*****\n[WARNING] [DBT-10331] Specified SID Name (anjodb01) may have a potential conflict with an already existing database on the system.\n CAUSE: The specified SID Name without the trailing numeric characters ({2}) may have a potential conflict with an already existing database on the system.\n ACTION: Specify a different SID Name that does not conflict with existing databases on the system.\nPrepare for db operation\n22% complete\nListener config step\n44% complete\nAuxiliary instance creation\n67% complete\nRMAN duplicate\n89% complete\nPost duplicate database operations\n100% complete\n<\/pre><\/div>\n\n\nThe warning DBT-10331 appears because I’ve a “anjodb02” in the same VM, and this could create a problem, as they share the prefix “anjodb”. I don’t expect on a single instance environment that to be a problem though.<\/p>\n\n\n\n
And it starts the new standby in ‘read only’ mode, which requires adequate licenses. <\/p>\n\n\n
\nSQL> select name, db_unique_name, database_role, open_mode, dataguard_broker from v$database;\n\nNAME DB_UNIQUE_NAME DATABASE_ROLE OPEN_MODE DATAGUAR\n--------- ------------------------------ ---------------- -------------------- --------\nANJODB01 ANJODB02_S2 PHYSICAL STANDBY READ ONLY DISABLED\n<\/pre><\/div>\n\n\nFor the moment, I’ll stay with my set of scripts which do the operations in the right way.<\/p>\n","protected":false},"excerpt":{"rendered":"
Sometimes I ask myself why some bugs are not solved. When looking for DBT-16071 we find a blog post from Frank Pachot from more than 7 years ago. He shows that with Oracle 12.2 you can “create” standby databases directly with dbca. But that the script does only a duplicate for standby and nothing more. […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,6,39],"tags":[],"class_list":{"0":"post-917","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-dataguard","7":"category-oracle","8":"category-oracle-19c","9":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/917","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=917"}],"version-history":[{"count":2,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/917\/revisions"}],"predecessor-version":[{"id":919,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/917\/revisions\/919"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}