{"id":9454,"date":"2016-11-30T13:03:56","date_gmt":"2016-11-30T12:03:56","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/"},"modified":"2016-11-30T13:03:56","modified_gmt":"2016-11-30T12:03:56","slug":"oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/","title":{"rendered":"Oracle 12c DataGuard – Insufficient SRLs reported by DGMGRL VALIDATE DATABASE VERBOSE"},"content":{"rendered":"

By William Sescu<\/h2>\n

I have setup a DataGuard environment and followed the instructions from Oracle to create the Standby Redo Logs. The Standby Redo Logs have to be the same size as the Online Redo Logs. If not, the RFS process won’t attach Standby Redo Logs, and you should have at least one more of the Standby Redo Log Group as you have for your Online Redo Log Group per Thread.<\/p>\n

For my single instance, this should be quite straight forward, and so I issued the following commands on the primary and standby.<\/p>\n

alter database add standby logfile group 4 size 1073741824;\nalter database add standby logfile group 5 size 1073741824;\nalter database add standby logfile group 6 size 1073741824;\nalter database add standby logfile group 7 size 1073741824;<\/pre>\n
After setting all up, I started the new cool Broker command “DGMGRL> VALIDATE DATABASE VERBOSE ‘<DB>’;” and surprisingly found, that the validation complains that I do have insufficient Standby Redo Logs.<\/p>\n
  Current Log File Groups Configuration:\n    Thread #  Online Redo Log Groups  Standby Redo Log Groups Status\n              (OCM12C_SITE2)          (OCM12C_SITE1)\n    1         3                       3                       Insufficient SRLs\n\n  Future Log File Groups Configuration:\n    Thread #  Online Redo Log Groups  Standby Redo Log Groups Status\n              (OCM12C_SITE1)          (OCM12C_SITE2)\n    1         3                       3                       Insufficient SRLs<\/pre>\n
After looking everything up on Primary and Standby, the number of Log Groups and the sizes looked ok. I do have 3 Online Redo Log Groups with 1G each, and I have 4 Standby Redo Log Groups with 1G each.<\/p>\n
-- Standby\n\nSQL> select thread#, group#, sequence#, status, bytes from v$log;\n\n   THREAD#     GROUP#  SEQUENCE# STATUS                BYTES\n---------- ---------- ---------- ---------------- ----------\n         1          1          0 UNUSED           1073741824\n         1          3          0 UNUSED           1073741824\n         1          2          0 UNUSED           1073741824\n\nSQL> select thread#, group#, sequence#, status, bytes from v$standby_log;\n\n   THREAD#     GROUP#  SEQUENCE# STATUS          BYTES\n---------- ---------- ---------- ---------- ----------\n         1          4          0 UNASSIGNED 1073741824\n         1          5        552 ACTIVE     1073741824\n         1          6          0 UNASSIGNED 1073741824\n         0          7          0 UNASSIGNED 1073741824\n\n-- Primary\n\nSQL> select thread#, group#, sequence#, status, bytes from v$log;\n\n   THREAD#     GROUP#  SEQUENCE# STATUS                BYTES\n---------- ---------- ---------- ---------------- ----------\n         1          1        550 INACTIVE         1073741824\n         1          2        551 INACTIVE         1073741824\n         1          3        552 CURRENT          1073741824\n\nSQL> select thread#, group#, sequence#, status, bytes from v$standby_log;\n\n   THREAD#     GROUP#  SEQUENCE# STATUS          BYTES\n---------- ---------- ---------- ---------- ----------\n         1          4          0 UNASSIGNED 1073741824\n         1          5          0 UNASSIGNED 1073741824\n         1          6          0 UNASSIGNED 1073741824\n         0          7          0 UNASSIGNED 1073741824<\/pre>\n
 <\/p>\n
The only strange thing, is that the Standby Redo Log Group 7, shows up with Thread 0, instead of Thread 1.
\nDid not even know, that a thread 0 exists. It always starts with 1, and in case of RAC, you might see Thread 2, 3 or more. But if you want to, you can perfectly create thread 0 without any issues. For what reasons, I don’t know.<\/p>\n
SQL> alter database add standby logfile thread 0 group 8 size 1073741824;\n\nDatabase altered.<\/pre>\n
Ok. Lets correct the Thread 0 thing, and then lets see want the “DGMGRL> VALIDATE DATABASE VERBOSE ‘<DB>’;” shows.<\/p>\n
-- On Standby\n\t\t \nDGMGRL> EDIT DATABASE 'OCM12C_SITE1' SET STATE = 'APPLY-OFF';\nSucceeded.\n\nSQL> alter database drop standby logfile group 7;\n\nDatabase altered.\n\nSQL> alter database add standby logfile thread 1 group 7 size 1073741824;\n\nDatabase altered.\n\nSQL> select thread#, group#, sequence#, status, bytes from v$standby_log;\n\n   THREAD#     GROUP#  SEQUENCE# STATUS          BYTES\n---------- ---------- ---------- ---------- ----------\n         1          4        553 ACTIVE     1073741824\n         1          5          0 UNASSIGNED 1073741824\n         1          6          0 UNASSIGNED 1073741824\n         1          7          0 UNASSIGNED 1073741824\n\t\t \nDGMGRL> EDIT DATABASE 'OCM12C_SITE1' SET STATE = 'APPLY-ON';\nSucceeded.\n\t\t \n-- On Primary\n\nSQL> alter database drop standby logfile group 7;\n\nDatabase altered.\n\nSQL> alter database add standby logfile thread 1 group 7 size 1073741824;\n\nDatabase altered.<\/pre>\n
And here we go. Now I have sufficient Standby Redo Logs.<\/p>\n
  Current Log File Groups Configuration:\n    Thread #  Online Redo Log Groups  Standby Redo Log Groups Status\n              (OCM12C_SITE2)          (OCM12C_SITE1)\n    1         3                       4                       Sufficient SRLs\n\n  Future Log File Groups Configuration:\n    Thread #  Online Redo Log Groups  Standby Redo Log Groups Status\n              (OCM12C_SITE1)          (OCM12C_SITE2)\n    1         3                       4                       Sufficient SRLs<\/pre>\n
 <\/p>\n
Conclusion<\/h3>\n
Even on a single instance, use the thread number in your create Standby Redo Log statement.<\/p>\n
alter database add standby logfile thread 1 group 4 size 1073741824;\nalter database add standby logfile thread 1 group 5 size 1073741824;\nalter database add standby logfile thread 1 group 6 size 1073741824;\nalter database add standby logfile thread 1 group 7 size 1073741824;<\/pre>\n
Cheers,
\nWilliam<\/p>\n","protected":false},"excerpt":{"rendered":"
By William Sescu I have setup a DataGuard environment and followed the instructions from Oracle to create the Standby Redo Logs. The Standby Redo Logs have to be the same size as the Online Redo Logs. If not, the RFS process won’t attach Standby Redo Logs, and you should have at least one more of […]<\/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":[999,209],"type_dbi":[],"class_list":["post-9454","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-dataguard","tag-oracle-12c"],"acf":[],"yoast_head":"\nOracle 12c DataGuard - Insufficient SRLs reported by DGMGRL VALIDATE DATABASE VERBOSE - dbi Blog<\/title>\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-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 12c DataGuard - Insufficient SRLs reported by DGMGRL VALIDATE DATABASE VERBOSE\" \/>\n<meta property=\"og:description\" content=\"By William Sescu I have setup a DataGuard environment and followed the instructions from Oracle to create the Standby Redo Logs. The Standby Redo Logs have to be the same size as the Online Redo Logs. If not, the RFS process won’t attach Standby Redo Logs, and you should have at least one more of […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-30T12:03:56+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=\"3 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-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 12c DataGuard – Insufficient SRLs reported by DGMGRL VALIDATE DATABASE VERBOSE\",\"datePublished\":\"2016-11-30T12:03:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/\"},\"wordCount\":292,\"commentCount\":0,\"keywords\":[\"DataGuard\",\"Oracle 12c\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/\",\"name\":\"Oracle 12c DataGuard - Insufficient SRLs reported by DGMGRL VALIDATE DATABASE VERBOSE - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2016-11-30T12:03:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 12c DataGuard – Insufficient SRLs reported by DGMGRL VALIDATE DATABASE VERBOSE\"}]},{\"@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 12c DataGuard - Insufficient SRLs reported by DGMGRL VALIDATE DATABASE VERBOSE - dbi Blog","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-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 12c DataGuard - Insufficient SRLs reported by DGMGRL VALIDATE DATABASE VERBOSE","og_description":"By William Sescu I have setup a DataGuard environment and followed the instructions from Oracle to create the Standby Redo Logs. The Standby Redo Logs have to be the same size as the Online Redo Logs. If not, the RFS process won’t attach Standby Redo Logs, and you should have at least one more of […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/","og_site_name":"dbi Blog","article_published_time":"2016-11-30T12:03:56+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 12c DataGuard – Insufficient SRLs reported by DGMGRL VALIDATE DATABASE VERBOSE","datePublished":"2016-11-30T12:03:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/"},"wordCount":292,"commentCount":0,"keywords":["DataGuard","Oracle 12c"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/","name":"Oracle 12c DataGuard - Insufficient SRLs reported by DGMGRL VALIDATE DATABASE VERBOSE - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-11-30T12:03:56+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-dataguard-insufficient-srls-reported-by-dgmgrl-validate-database-verbose\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 12c DataGuard – Insufficient SRLs reported by DGMGRL VALIDATE DATABASE VERBOSE"}]},{"@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\/9454","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=9454"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9454\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9454"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9454"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9454"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}