{"id":51502,"date":"2022-07-08T15:43:50","date_gmt":"2022-07-08T15:43:50","guid":{"rendered":"https:\/\/dbtut.com\/?p=51502"},"modified":"2022-07-08T15:45:06","modified_gmt":"2022-07-08T15:45:06","slug":"insufficient-srls","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/","title":{"rendered":"Insufficient SRLs"},"content":{"rendered":"

In today’s article I will describe Resolving Insufficient SRLs Warning in Pre-Switchover Validate Command.<\/p>\n

When we run the Validate command on the Standby database that will be Primary before Swtichover,<\/p>\n

we get the Insufficient SRLs warning in the Current Log File Groups and Future Log File Groups sections.<\/p>\n

Here’s how we fix this warning.<\/p>\n

1. We are learning configuration.<\/p>\n

DGMGRL> show configuration\r\n\r\nConfiguration - DRSolution\r\n\r\n  Protection Mode: MaxPerformance\r\n  Members:\r\n  primary  - Primary database\r\n    prmyFS   - Far sync instance \r\n      physical - Physical standby database \r\n      snapshot - Snapshot standby database \r\n      logical  - Logical standby database \r\n      logical2 - Physical standby database \r\n\r\n  Members Not Receiving Redo:\r\n  physclFS - Far sync instance \r\n\r\nFast-Start Failover: DISABLED\r\n\r\nConfiguration Status:\r\nSUCCESS   (status updated 49 seconds ago)<\/pre>\n
2. We are questioning whether the standby database to be primary is suitable for Switchover.<\/p>\n
DGMGRL> validate database physical;\r\n\r\n  Database Role:     Physical standby database\r\n  Primary Database:  primary\r\n\r\n  Ready for Switchover:  Yes\r\n  Ready for Failover:    Yes (Primary Running)\r\n\r\n  Flashback Database Status:\r\n    primary:   On\r\n    physical:  Off\r\n\r\n  Current Log File Groups Configuration:\r\n    Thread #  Online Redo Log Groups  Standby Redo Log Groups Status       \r\n              (primary)               (physical)                           \r\n    1         3                       3                       Insufficient SRLs\r\n\r\n  Future Log File Groups Configuration:\r\n    Thread #  Online Redo Log Groups  Standby Redo Log Groups Status       \r\n              (physical)              (primary)                            \r\n    1         3                       3                       Insufficient SRLs\r\n\r\n  Transport-Related Property Settings:\r\n    Property                        primary Value            physical Value\r\n    RedoRoutes                      (LOCAL:prmyFS SYNC)      (LOCAL:physclFS SYNC)<\/pre>\n
3. We are querying Online and Standby Redo Logs in Primary and Standby database.<\/p>\n
[Primary - 07-04-2017 14:06:24] SQL> select thread#, group#, sequence#, status, bytes from v$log;\r\n\r\n   THREAD#     GROUP#  SEQUENCE# STATUS                BYTES\r\n---------- ---------- ---------- ---------------- ----------\r\n         1          1        812 CURRENT            52428800\r\n         1          2        810 INACTIVE           52428800\r\n         1          3        811 INACTIVE           52428800\r\n\r\n[Primary - 07-04-2017 14:15:47] SQL> select thread#, group#, sequence#, status, bytes from v$standby_log;\r\n\r\n   THREAD#     GROUP#  SEQUENCE# STATUS          BYTES\r\n---------- ---------- ---------- ---------- ----------\r\n         1          4          0 UNASSIGNED   52428800\r\n         1          5          0 UNASSIGNED   52428800\r\n         1          6          0 UNASSIGNED   52428800\r\n         0          7          0 UNASSIGNED   52428800\r\n<\/pre>\n
[Physical - 07-04-2017 14:06:24] SQL> select thread#, group#, sequence#, status, bytes from v$log;\r\n\r\n   THREAD#     GROUP#  SEQUENCE# STATUS                BYTES\r\n---------- ---------- ---------- ---------------- ----------\r\n         1          1          0 UNUSED             52428800\r\n         1          2          0 UNUSED             52428800\r\n         1          3          0 UNUSED             52428800\r\n\r\n[Physical - 07-04-2017 14:15:15] SQL> select thread#, group#, sequence#, status, bytes from v$standby_log;\r\n\r\n   THREAD#     GROUP#  SEQUENCE# STATUS          BYTES\r\n---------- ---------- ---------- ---------- ----------\r\n         1          4        812 ACTIVE       52428800\r\n         1          5          0 UNASSIGNED   52428800\r\n         1          6          0 UNASSIGNED   52428800\r\n         0          7          0 UNASSIGNED   52428800\r\n<\/pre>\n
As we have seen above, a Redo Log is created as Thread# 0 in Standby Redo Logs.<\/p>\n
In fact, while working to establish the Primary database Standby, Standby Redo Logs were created as an extra to the number of Online Redo Logs in the Primary.<\/p>\n
But Oracle created one of the created as Thread# 0, which I can’t understand why.<\/p>\n
In this case, Oracle’s best recommendation is not followed. That’s why we’re getting a warning.<\/p>\n
4. We create a new Standby Log File with thread# 0 in the same size in the Primary.<\/p>\n
This is because if Oracle is using it for a special reason, this is not to interfere with the process.<\/p>\n
[Primary - 07-04-2017 14:15:55] SQL> alter database add standby logfile thread 0 group 8 size 52428800;\r\n\r\nDatabase altered.\r\n\r\n[Primary - 07-04-2017 14:19:27] SQL> select thread#, group#, sequence#, status, bytes from v$standby_log;\r\n\r\n   THREAD#     GROUP#  SEQUENCE# STATUS          BYTES\r\n---------- ---------- ---------- ---------- ----------\r\n         1          4          0 UNASSIGNED   52428800\r\n         1          5          0 UNASSIGNED   52428800\r\n         1          6          0 UNASSIGNED   52428800\r\n         0          7          0 UNASSIGNED   52428800\r\n         0          8          0 UNASSIGNED   52428800\r\n<\/pre>\n
5. We create as thread #1 by DROPing the Standby Log File number 7 in Primary.<\/p>\n
[Primary - 07-04-2017 14:19:31] SQL> alter database drop standby logfile group 7;\r\n\r\nDatabase altered.\r\n\r\n[Primary - 07-04-2017 14:22:19] SQL> alter database add standby logfile thread 1 group 7 size 52428800;\r\n\r\nDatabase altered.\r\n<\/pre>\n
6. We perform the same operations in the standby database. First we stop Redo Apply, otherwise we will get an error as below.<\/p>\n
[Physical - 07-04-2017 14:19:47] SQL> alter database recover managed standby database cancel;\r\n\r\nDatabase altered.\r\n<\/pre>\n
ERROR at line 1:<\/p>\n
ORA-01156: recovery or flashback in progress may need access to files<\/code><\/p>\n
7. We create a new Standby Redo Log group with thread# 0 in the Standby database, DROP the Standby Redo Log group with the current thread# 0, and create the Standby Redo Log file with the same group as thread# 1.<\/p>\n
[Physical - 07-04-2017 14:20:26] SQL> alter database add standby logfile thread 0 group 8 size 52428800;\r\n\r\nDatabase altered.\r\n\r\n[Physical - 07-04-2017 14:20:29] SQL> alter database recover managed standby database disconnect;\r\n\r\nDatabase altered.\r\n\r\n[Physical - 07-04-2017 14:20:43] SQL> alter database drop standby logfile group 7;\r\n\r\nDatabase altered.\r\n\r\n[Physical - 07-04-2017 14:21:24] SQL> alter database add standby logfile thread 1 group 7 size 52428800;\r\n\r\nDatabase altered.\r\n<\/pre>\n
8. We check the Standby Redo Log files on the Primary and Standby sides.<\/p>\n
[Primary - 07-04-2017 14:22:29] SQL> select thread#, group#, sequence#, status, bytes from v$standby_log;\r\n\r\n   THREAD#     GROUP#  SEQUENCE# STATUS          BYTES\r\n---------- ---------- ---------- ---------- ----------\r\n         1          4          0 UNASSIGNED   52428800\r\n         1          5          0 UNASSIGNED   52428800\r\n         1          6          0 UNASSIGNED   52428800\r\n         1          7          0 UNASSIGNED   52428800\r\n         0          8          0 UNASSIGNED   52428800\r\n<\/pre>\n
[Physical - 07-04-2017 14:21:34] SQL> select thread#, group#, sequence#, status, bytes from v$standby_log;\r\n\r\n   THREAD#     GROUP#  SEQUENCE# STATUS          BYTES\r\n---------- ---------- ---------- ---------- ----------\r\n         1          4        812 ACTIVE       52428800\r\n         1          5          0 UNASSIGNED   52428800\r\n         1          6          0 UNASSIGNED   52428800\r\n         1          7          0 UNASSIGNED   52428800\r\n         0          8          0 UNASSIGNED   52428800\r\n<\/pre>\n
9. By running the Validate command again, we check if the error has occurred.<\/p>\n
DGMGRL> validate database physical;\r\n\r\n  Database Role:     Physical standby database\r\n  Primary Database:  primary\r\n\r\n  Ready for Switchover:  Yes\r\n  Ready for Failover:    Yes (Primary Running)\r\n\r\n  Flashback Database Status:\r\n    primary:   On\r\n    physical:  Off\r\n\r\n  Transport-Related Property Settings:\r\n    Property                        primary Value            physical Value\r\n    RedoRoutes                      (LOCAL:prmyFS SYNC)      (LOCAL:physclFS SYNC)\r\n<\/pre>\n
 <\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article I will describe Resolving Insufficient SRLs Warning in Pre-Switchover Validate Command. When we run the Validate command on the Standby database that will be Primary before Swtichover, we get the Insufficient SRLs warning in the Current Log File Groups and Future Log File Groups sections. Here’s how we fix this warning. 1. …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":51506,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-51502","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":630,"today_views":0},"yoast_head":"\nInsufficient SRLs - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article I will describe Resolving Insufficient SRLs Warning in Pre-Switchover Validate Command. When we run the Validate command\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Insufficient SRLs - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article I will describe Resolving Insufficient SRLs Warning in Pre-Switchover Validate Command. When we run the Validate command\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-08T15:43:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-08T15:45:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/07\/Ekran-goruntusu-2022-07-08-184132.png\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\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:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Insufficient SRLs\",\"datePublished\":\"2022-07-08T15:43:50+00:00\",\"dateModified\":\"2022-07-08T15:45:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/\"},\"wordCount\":298,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/07\/Ekran-goruntusu-2022-07-08-184132.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/\",\"name\":\"Insufficient SRLs - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/07\/Ekran-goruntusu-2022-07-08-184132.png\",\"datePublished\":\"2022-07-08T15:43:50+00:00\",\"dateModified\":\"2022-07-08T15:45:06+00:00\",\"description\":\"In today's article I will describe Resolving Insufficient SRLs Warning in Pre-Switchover Validate Command. When we run the Validate command\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/07\/Ekran-goruntusu-2022-07-08-184132.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/07\/Ekran-goruntusu-2022-07-08-184132.png\",\"width\":768,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Insufficient SRLs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Insufficient SRLs - Database Tutorials","description":"In today's article I will describe Resolving Insufficient SRLs Warning in Pre-Switchover Validate Command. When we run the Validate command","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:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/","og_locale":"en_US","og_type":"article","og_title":"Insufficient SRLs - Database Tutorials","og_description":"In today's article I will describe Resolving Insufficient SRLs Warning in Pre-Switchover Validate Command. When we run the Validate command","og_url":"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/","og_site_name":"Database Tutorials","article_published_time":"2022-07-08T15:43:50+00:00","article_modified_time":"2022-07-08T15:45:06+00:00","og_image":[{"width":768,"height":400,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/07\/Ekran-goruntusu-2022-07-08-184132.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Insufficient SRLs","datePublished":"2022-07-08T15:43:50+00:00","dateModified":"2022-07-08T15:45:06+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/"},"wordCount":298,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/07\/Ekran-goruntusu-2022-07-08-184132.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/","url":"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/","name":"Insufficient SRLs - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/07\/Ekran-goruntusu-2022-07-08-184132.png","datePublished":"2022-07-08T15:43:50+00:00","dateModified":"2022-07-08T15:45:06+00:00","description":"In today's article I will describe Resolving Insufficient SRLs Warning in Pre-Switchover Validate Command. When we run the Validate command","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/07\/Ekran-goruntusu-2022-07-08-184132.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/07\/Ekran-goruntusu-2022-07-08-184132.png","width":768,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2022\/07\/08\/insufficient-srls\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Insufficient SRLs"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/51502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=51502"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/51502\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/51506"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=51502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=51502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=51502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}