{"id":15643,"date":"2020-07-01T07:39:03","date_gmt":"2020-07-01T07:39:03","guid":{"rendered":"https:\/\/dbtut.com\/?p=15643"},"modified":"2020-07-03T12:57:55","modified_gmt":"2020-07-03T12:57:55","slug":"sql-apply-filtering-on-logical-standby-database","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/","title":{"rendered":"SQL Apply Filtering on Logical Standby Database"},"content":{"rendered":"<p>Sometimes, we may not want to reflect the operations performed on the Primary database to the Logical Standby database. It can be ensured that DML operations performed in Primary are not applied in Logical Standby Database as follows;<\/p>\n<h3>Step1:<\/h3>\n<h3>Stop SQL Apply in Logical Standby<\/h3>\n<p>First we should stop applying sql in logical standby.<\/p>\n<pre class=\"lang:default decode:true\">[Logical-1]\nSQL&gt; alter database stop logical standby apply;\n\nDatabase altered.<\/pre>\n<h3>Step2:<\/h3>\n<h3 class=\"LC20lb DKV0Md\">Oracle Logical Standby Skip Schema<\/h3>\n<p>To skip applying DMLs performed in a specific schema to the Logical Standby<\/p>\n<pre class=\"lang:default decode:true\">[Logical-1]\nSQL&gt; EXECUTE DBMS_LOGSTDBY.SKIP(STMT =&gt; 'DML', schema_name =&gt; 'TEST', object_name =&gt; '%');\n\nPL\/SQL procedure successfully completed.<\/pre>\n<h3>Step3:<\/h3>\n<h3>Start SQL Apply in Logical Standby<\/h3>\n<pre class=\"lang:default decode:true \">[Logical-1]\nSQL&gt; ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;\n\nDatabase altered.<\/pre>\n<h3>Step4:<\/h3>\n<h3>Make sure archives are transported to Logical Standby and Applied<\/h3>\n<pre class=\"lang:default decode:true \">[Primary-1]\nSQL&gt; select max(sequence#),thread# from v$archived_log group by thread#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n           359          1\n           222          2<\/pre>\n<pre class=\"lang:default decode:true \">[Logical-1]\nSQL&gt; SELECT sequence#, first_time, next_time, dict_begin, dict_end, applied FROM dba_logstdby_log ORDER BY sequence#;\n\n SEQUENCE# FIRST_TIM NEXT_TIME DIC DIC APPLIED\n---------- --------- --------- --- --- --------\n       186 10-JAN-17 10-JAN-17 NO  NO  YES\n       187 10-JAN-17 10-JAN-17 NO  NO  YES\n       188 10-JAN-17 10-JAN-17 NO  NO  YES\n       189 10-JAN-17 10-JAN-17 NO  NO  YES\n       190 10-JAN-17 10-JAN-17 NO  NO  YES\n       191 10-JAN-17 10-JAN-17 NO  NO  YES\n       192 10-JAN-17 10-JAN-17 YES NO  YES\n       193 10-JAN-17 10-JAN-17 NO  YES YES\n       194 10-JAN-17 10-JAN-17 NO  NO  YES\n       195 10-JAN-17 10-JAN-17 NO  NO  YES\n       196 10-JAN-17 10-JAN-17 NO  NO  YES\n\n SEQUENCE# FIRST_TIM NEXT_TIME DIC DIC APPLIED\n---------- --------- --------- --- --- --------\n       197 10-JAN-17 10-JAN-17 NO  NO  YES\n       198 10-JAN-17 10-JAN-17 NO  NO  YES\n       199 10-JAN-17 10-JAN-17 NO  NO  YES\n       200 10-JAN-17 10-JAN-17 NO  NO  YES\n       201 10-JAN-17 10-JAN-17 NO  NO  YES\n       202 10-JAN-17 10-JAN-17 NO  NO  YES\n       203 10-JAN-17 10-JAN-17 NO  NO  YES\n       204 10-JAN-17 10-JAN-17 NO  NO  YES\n       205 10-JAN-17 10-JAN-17 NO  NO  YES\n       206 10-JAN-17 10-JAN-17 NO  NO  YES\n       207 10-JAN-17 10-JAN-17 NO  NO  YES\n\n SEQUENCE# FIRST_TIM NEXT_TIME DIC DIC APPLIED\n---------- --------- --------- --- --- --------\n       208 10-JAN-17 10-JAN-17 NO  NO  YES\n       209 10-JAN-17 10-JAN-17 NO  NO  YES\n       210 10-JAN-17 10-JAN-17 NO  NO  YES\n       211 10-JAN-17 10-JAN-17 NO  NO  YES\n       212 10-JAN-17 10-JAN-17 NO  NO  YES\n       213 10-JAN-17 10-JAN-17 NO  NO  YES\n       214 10-JAN-17 10-JAN-17 NO  NO  YES\n       215 10-JAN-17 10-JAN-17 NO  NO  YES\n       216 10-JAN-17 10-JAN-17 NO  NO  YES\n       217 10-JAN-17 10-JAN-17 NO  NO  YES\n       218 10-JAN-17 10-JAN-17 NO  NO  YES\n\n SEQUENCE# FIRST_TIM NEXT_TIME DIC DIC APPLIED\n---------- --------- --------- --- --- --------\n       219 10-JAN-17 10-JAN-17 NO  NO  YES\n       220 10-JAN-17 10-JAN-17 NO  NO  YES\n       221 10-JAN-17 11-JAN-17 NO  NO  YES\n       222 11-JAN-17 11-JAN-17 NO  NO  YES\n       324 10-JAN-17 10-JAN-17 YES NO  YES\n       325 10-JAN-17 10-JAN-17 NO  YES YES\n       326 10-JAN-17 10-JAN-17 NO  NO  YES\n       327 10-JAN-17 10-JAN-17 NO  NO  YES\n       328 10-JAN-17 10-JAN-17 NO  NO  YES\n       329 10-JAN-17 10-JAN-17 NO  NO  YES\n       330 10-JAN-17 10-JAN-17 NO  NO  YES\n\n SEQUENCE# FIRST_TIM NEXT_TIME DIC DIC APPLIED\n---------- --------- --------- --- --- --------\n       331 10-JAN-17 10-JAN-17 NO  NO  YES\n       332 10-JAN-17 10-JAN-17 NO  NO  YES\n       333 10-JAN-17 10-JAN-17 NO  NO  YES\n       334 10-JAN-17 10-JAN-17 NO  NO  YES\n       335 10-JAN-17 10-JAN-17 NO  NO  YES\n       336 10-JAN-17 10-JAN-17 NO  NO  YES\n       337 10-JAN-17 10-JAN-17 NO  NO  YES\n       338 10-JAN-17 10-JAN-17 NO  NO  YES\n       339 10-JAN-17 10-JAN-17 NO  NO  YES\n       340 10-JAN-17 10-JAN-17 NO  NO  YES\n       341 10-JAN-17 10-JAN-17 NO  NO  YES\n\n SEQUENCE# FIRST_TIM NEXT_TIME DIC DIC APPLIED\n---------- --------- --------- --- --- --------\n       342 10-JAN-17 10-JAN-17 NO  NO  YES\n       343 10-JAN-17 10-JAN-17 NO  NO  YES\n       344 10-JAN-17 10-JAN-17 NO  NO  YES\n       345 10-JAN-17 10-JAN-17 NO  NO  YES\n       346 10-JAN-17 10-JAN-17 NO  NO  YES\n       347 10-JAN-17 10-JAN-17 NO  NO  YES\n       348 10-JAN-17 10-JAN-17 NO  NO  YES\n       349 10-JAN-17 10-JAN-17 NO  NO  YES\n       350 10-JAN-17 10-JAN-17 NO  NO  YES\n       351 10-JAN-17 10-JAN-17 NO  NO  YES\n       352 10-JAN-17 10-JAN-17 NO  NO  YES\n\n SEQUENCE# FIRST_TIM NEXT_TIME DIC DIC APPLIED\n---------- --------- --------- --- --- --------\n       353 10-JAN-17 10-JAN-17 NO  NO  YES\n       354 10-JAN-17 10-JAN-17 NO  NO  YES\n       355 10-JAN-17 10-JAN-17 NO  NO  YES\n       356 10-JAN-17 10-JAN-17 NO  NO  YES\n       357 10-JAN-17 10-JAN-17 NO  NO  YES\n       358 10-JAN-17 11-JAN-17 NO  NO  YES\n       359 11-JAN-17 11-JAN-17 NO  NO  YES\n\n73 rows selected.<\/pre>\n<h3>Step5:<\/h3>\n<h3>Check if DML changes in Schema are Applied to Logical Standby.<\/h3>\n<p>Perform a deletion on a table of the related schema in Primary and check if it has been deleted from Logical Standby.<\/p>\n<pre class=\"lang:default decode:true \">[Primary-1]\nSQL&gt; select * from test.regions_yedek;\n\n REGION_ID REGION_NAME\n---------- -------------------------\n         1 Europe\n         2 Americas\n         4 Middle East and Africa\n\nSQL&gt; delete test.regions_yedek where region_id=4;\n\n1 row deleted.\n\nSQL&gt; commit;\n\nCommit complete.\n\nSQL&gt; select * from test.regions_yedek;\n\n REGION_ID REGION_NAME\n---------- -------------------------\n         1 Europe\n         2 Americas<\/pre>\n<h3>Step6:<\/h3>\n<h3>Check a table without DML Filtering<\/h3>\n<p>Query the data of a table without DML Filtering from Primary and Logical Standby.<\/p>\n<pre class=\"lang:default decode:true \">[Primary-1]\nSQL&gt; select * from hr.countries;\n\nCO COUNTRY_NAME                              REGION_ID\n-- ---------------------------------------- ----------\nAR Argentina                                         2\nAU Australia                                         3\nBE Belgium                                           1\nBR Brazil                                            2\nCA Canada                                            2\nCH Switzerland                                       1\nCN China                                             3\nDE Germany                                           1\nDK Denmark                                           1\nEG Egypt                                             4\nFR France                                            1\n\nCO COUNTRY_NAME                              REGION_ID\n-- ---------------------------------------- ----------\nIL Israel                                            4\nIN India                                             3\nIT Italy                                             1\nJP Japan                                             3\nKW Kuwait                                            4\nML Malaysia                                          3\nMX Mexico                                            2\nNG Nigeria                                           4\nNL Netherlands                                       1\nSG Singapore                                         3\nUK United Kingdom                                    1\n\nCO COUNTRY_NAME                              REGION_ID\n-- ---------------------------------------- ----------\nUS United States of America                          2\nZM Zambia                                            4\nZW Zimbabwe                                          4\n\n25 rows selected.<\/pre>\n<pre class=\"lang:default decode:true \">[Logical-1]\nSQL&gt; select * from hr.countries;\n\nCO COUNTRY_NAME                              REGION_ID\n-- ---------------------------------------- ----------\nAR Argentina                                         2\nAU Australia                                         3\nBE Belgium                                           1\nBR Brazil                                            2\nCA Canada                                            2\nCH Switzerland                                       1\nCN China                                             3\nDE Germany                                           1\nDK Denmark                                           1\nEG Egypt                                             4\nFR France                                            1\n\nCO COUNTRY_NAME                              REGION_ID\n-- ---------------------------------------- ----------\nIL Israel                                            4\nIN India                                             3\nIT Italy                                             1\nJP Japan                                             3\nKW Kuwait                                            4\nML Malaysia                                          3\nMX Mexico                                            2\nNG Nigeria                                           4\nNL Netherlands                                       1\nSG Singapore                                         3\nUK United Kingdom                                    1\n\nCO COUNTRY_NAME                              REGION_ID\n-- ---------------------------------------- ----------\nUS United States of America                          2\nZM Zambia                                            4\nZW Zimbabwe                                          4\n\n25 rows selected.<\/pre>\n<h3>Step7:<\/h3>\n<h3>Check again by deleting from Primary<\/h3>\n<pre class=\"lang:default decode:true \">[Primary-1]\nSQL&gt; delete hr.countries where country_name='Zimbabwe';\n\n1 row deleted.\n\nSQL&gt; commit;\n\nCommit complete.\n\nSQL&gt; select * from hr.countries;\n\nCO COUNTRY_NAME                              REGION_ID\n-- ---------------------------------------- ----------\nAR Argentina                                         2\nAU Australia                                         3\nBE Belgium                                           1\nBR Brazil                                            2\nCA Canada                                            2\nCH Switzerland                                       1\nCN China                                             3\nDE Germany                                           1\nDK Denmark                                           1\nEG Egypt                                             4\nFR France                                            1\n\nCO COUNTRY_NAME                              REGION_ID\n-- ---------------------------------------- ----------\nIL Israel                                            4\nIN India                                             3\nIT Italy                                             1\nJP Japan                                             3\nKW Kuwait                                            4\nML Malaysia                                          3\nMX Mexico                                            2\nNG Nigeria                                           4\nNL Netherlands                                       1\nSG Singapore                                         3\nUK United Kingdom                                    1\n\nCO COUNTRY_NAME                              REGION_ID\n-- ---------------------------------------- ----------\nUS United States of America                          2\nZM Zambia                                            4\n\n24 rows selected.<\/pre>\n<pre class=\"lang:default decode:true \">[Logical-1]\nSQL&gt; select * from hr.countries;\n\nCO COUNTRY_NAME                              REGION_ID\n-- ---------------------------------------- ----------\nAR Argentina                                         2\nAU Australia                                         3\nBE Belgium                                           1\nBR Brazil                                            2\nCA Canada                                            2\nCH Switzerland                                       1\nCN China                                             3\nDE Germany                                           1\nDK Denmark                                           1\nEG Egypt                                             4\nFR France                                            1\n\nCO COUNTRY_NAME                              REGION_ID\n-- ---------------------------------------- ----------\nIL Israel                                            4\nIN India                                             3\nIT Italy                                             1\nJP Japan                                             3\nKW Kuwait                                            4\nML Malaysia                                          3\nMX Mexico                                            2\nNG Nigeria                                           4\nNL Netherlands                                       1\nSG Singapore                                         3\nUK United Kingdom                                    1\n\nCO COUNTRY_NAME                              REGION_ID\n-- ---------------------------------------- ----------\nUS United States of America                          2\nZM Zambia                                            4\n\n24 rows selected.<\/pre>\n<h3>Step8:<\/h3>\n<h3>Error and Transaction Filtering in Logical Standby<\/h3>\n<p>Apart from DML, Filtering can also be applied for errors and transaction specifics.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; EXECUTE DBMS_LOGSTDBY.SKIP_ERROR('GRANT');\n\nSQL&gt; EXECUTE DBMS LOGSTDBY SKIP TRANSACTION (XIDUSN =&gt; 1, XIDSLT =&gt; 13, XIDSQN =&gt; 1726);<\/pre>\n<p><strong>XIDUSN:<\/strong> Specifies the Undo Segment Number of Transaction.<br \/>\n<strong>XIDSLT:<\/strong> Specifies the Slot Number of Transaction.<br \/>\n<strong>XIDSQN:<\/strong> Specifies the Sequence Number of Transaction.<\/p>\n<h3>Step9:<\/h3>\n<h3>Check the existing SQL Apply Filtering<\/h3>\n<pre class=\"lang:default decode:true \">SQL&gt; DESC dba_logstdby_skip;\n Name                                      Null?    Type\n ----------------------------------------- -------- ----------------------------\n ERROR                                              VARCHAR2(1)\n STATEMENT_OPT                                      VARCHAR2(30)\n OWNER                                              VARCHAR2(30)\n NAME                                               VARCHAR2(65)\n USE_LIKE                                           VARCHAR2(1)\n ESC                                                VARCHAR2(1)\n PROC                                               VARCHAR2(98)\n\nSQL&gt; select max(length(STATEMENT_OPT)) from dba_logstdby_skip;\n\nMAX(LENGTH(STATEMENT_OPT))\n--------------------------\n                        15\n\nSQL&gt; column STATEMENT_OPT format a15\nSQL&gt; select max(length(OWNER)) from dba_logstdby_skip;\n\nMAX(LENGTH(OWNER))\n------------------\n                18\n\nSQL&gt; column OWNER format a18\nSQL&gt; select max(length(NAME)) from dba_logstdby_skip;\n\nMAX(LENGTH(NAME))\n-----------------\n                1\n\nSQL&gt; column name format a10\nSQL&gt; select max(length(PROC)) from dba_logstdby_skip;\n\nMAX(LENGTH(PROC))\n-----------------\n\n\nSQL&gt; set linesize 500\nSQL&gt; column error format a5\nSQL&gt; column proc format a10\nSQL&gt; column use_like format a10\nSQL&gt; column esc format a5\nSQL&gt; select * from dba_logstdby_skip;\n\nERROR STATEMENT_OPT   OWNER              NAME       USE_LIKE   ESC   PROC\n----- --------------- ------------------ ---------- ---------- ----- ----------\nN     DML             TEST               %          Y\nN     INTERNAL SCHEMA SYSTEM             %          N\nN     INTERNAL SCHEMA SYS                %          N\nN     INTERNAL SCHEMA OLAPSYS            %          N\nN     INTERNAL SCHEMA BI                 %          N\nN     INTERNAL SCHEMA SI_INFORMTN_SCHEMA %          N\nN     INTERNAL SCHEMA MGMT_VIEW          %          N\nN     INTERNAL SCHEMA OWBSYS             %          N\nN     INTERNAL SCHEMA APEX_030200        %          N\nN     INTERNAL SCHEMA XS$NULL            %          N\nN     INTERNAL SCHEMA ORDPLUGINS         %          N\n\nERROR STATEMENT_OPT   OWNER              NAME       USE_LIKE   ESC   PROC\n----- --------------- ------------------ ---------- ---------- ----- ----------\nN     INTERNAL SCHEMA APPQOSSYS          %          N\nN     INTERNAL SCHEMA ORACLE_OCM         %          N\nN     INTERNAL SCHEMA XDB                %          N\nN     INTERNAL SCHEMA SYSMAN             %          N\nN     INTERNAL SCHEMA WMSYS              %          N\nN     INTERNAL SCHEMA DBSNMP             %          N\nN     INTERNAL SCHEMA DIP                %          N\nN     INTERNAL SCHEMA OUTLN              %          N\nN     INTERNAL SCHEMA EXFSYS             %          N\nN     INTERNAL SCHEMA ANONYMOUS          %          N\nN     INTERNAL SCHEMA CTXSYS             %          N\n\nERROR STATEMENT_OPT   OWNER              NAME       USE_LIKE   ESC   PROC\n----- --------------- ------------------ ---------- ---------- ----- ----------\nN     INTERNAL SCHEMA ORDSYS             %          N\nN     INTERNAL SCHEMA ORDDATA            %          N\nN     INTERNAL SCHEMA MDSYS              %          N\n\n25 rows selected.<\/pre>\n<p><strong>Note:<\/strong> Note that there are also INTERNAL SCHEMAs above. We have already mentioned that INTERNAL SCHEMAs will not be transferred.<\/p>\n<h3>Step10:<\/h3>\n<h3>Delete SQL Apply Filtering<\/h3>\n<p>Stop SQL Apply.<\/p>\n<pre class=\"lang:default decode:true \">[Logical-1]\nSQL&gt; alter database stop logical standby apply;\n\nDatabase altered.<\/pre>\n<p>Delete SQL Apply Filter.<\/p>\n<pre class=\"lang:default decode:true \">[Logical-1]\nSQL&gt; EXECUTE DBMS_LOGSTDBY.UNSKIP(STMT =&gt; 'DML', schema_name =&gt; 'TEST', object_name =&gt; '%');\n\nPL\/SQL procedure successfully completed.<\/pre>\n<p>Start SQL Apply.<\/p>\n<pre class=\"lang:default decode:true \">[Logical-1]\nSQL&gt; alter database start logical standby apply immediate;\n\nDatabase altered.<\/pre>\n<p>Query the data of the table of the deleted filter from both sides.<\/p>\n<pre class=\"lang:default decode:true \">[Primary-1]\nSQL&gt; select * from test.regions_yedek;\n\n REGION_ID REGION_NAME\n---------- -------------------------\n         1 Europe\n         2 Americas<\/pre>\n<pre class=\"lang:default decode:true \">[Logical-1]\nSQL&gt; select * from test.regions_yedek;\n\n REGION_ID REGION_NAME\n---------- -------------------------\n         2 Americas\n         3 Asia\n         4 Middle East and Africa<\/pre>\n<p>Delete data from the table and check it from the Logical Standby side.<\/p>\n<pre class=\"lang:default decode:true \">[Primary-1]\nSQL&gt; delete test.regions_yedek where region_id=2;\n\n1 row deleted.\n\nSQL&gt; commit;\n\nCommit complete.\n\nSQL&gt; select * from test.regions_yedek;\n\n REGION_ID REGION_NAME\n---------- -------------------------\n         1 Europe<\/pre>\n<pre class=\"lang:default decode:true\">[Logical-1]\nSQL&gt; select * from test.regions_yedek;\n\n REGION_ID REGION_NAME\n---------- -------------------------\n         3 Asia\n         4 Middle East and Africa<\/pre>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_15643\" class=\"pvc_stats all  \" data-element-id=\"15643\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes, we may not want to reflect the operations performed on the Primary database to the Logical Standby database. It can be ensured that DML operations performed in Primary are not applied in Logical Standby Database as follows; Step1: Stop SQL Apply in Logical Standby First we should stop applying sql in logical standby. [Logical-1] &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_15643\" class=\"pvc_stats all  \" data-element-id=\"15643\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":484,"featured_media":15925,"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":[9710,9708,9709,9707,9706,9696,9695,9711,9713,9697,9703,9702,9701,9704,9694,9705,9712,9699,9700,9698],"class_list":["post-15643","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-check-filtering-on-logical-standby","tag-check-sql-apply-filter","tag-check-sql-apply-filters","tag-delete-sql-apply-filter","tag-delete-sql-apply-filtering","tag-dml-filtering-in-logical-standby","tag-error-and-transaction-filtering-in-logical-standby","tag-error-filtering-in-logical-standby","tag-filters-for-a-logical-standby-database","tag-how-to-skip-delete-operations-with-data-guard","tag-standby-skip-dml","tag-standby-skip-error","tag-standby-skip-transaction","tag-start-sql-apply-on-logical-standby","tag-stop-sql-apply-in-logical-standby","tag-stop-sql-apply-on-logical-standby","tag-transaction-filtering-in-logical-standby","tag-xidslt","tag-xidsqn","tag-xidusn"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Apply Filtering on Logical Standby Database - Database Tutorials<\/title>\n<meta name=\"description\" content=\"SQL Apply Filtering on Logical Standby Database\" \/>\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\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Apply Filtering on Logical Standby Database - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"SQL Apply Filtering on Logical Standby Database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-01T07:39:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-03T12:57:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/07\/Ads\u0131z-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"495\" \/>\n\t<meta property=\"og:image:height\" content=\"325\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"SQL Apply Filtering on Logical Standby Database\",\"datePublished\":\"2020-07-01T07:39:03+00:00\",\"dateModified\":\"2020-07-03T12:57:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/\"},\"wordCount\":271,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/07\/Ads\u0131z-1.jpg\",\"keywords\":[\"Check Filtering on logical standby\",\"Check SQL Apply Filter\",\"Check SQL Apply Filters\",\"Delete SQL Apply Filter\",\"Delete SQL Apply Filtering\",\"DML Filtering in logical standby\",\"Error and Transaction Filtering in Logical Standby\",\"Error Filtering in Logical Standby\",\"filters for a logical standby database\",\"How to skip delete operations with data guard\",\"standby skip dml\",\"standby skip error\",\"standby skip transaction\",\"Start SQL Apply on logical standby\",\"Stop SQL Apply in Logical Standby\",\"stop SQL Apply on logical standby\",\"Transaction Filtering in Logical Standby\",\"XIDSLT\",\"XIDSQN\",\"XIDUSN\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/\",\"name\":\"SQL Apply Filtering on Logical Standby Database - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/07\/Ads\u0131z-1.jpg\",\"datePublished\":\"2020-07-01T07:39:03+00:00\",\"dateModified\":\"2020-07-03T12:57:55+00:00\",\"description\":\"SQL Apply Filtering on Logical Standby Database\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/07\/Ads\u0131z-1.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/07\/Ads\u0131z-1.jpg\",\"width\":495,\"height\":325},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Apply Filtering on Logical Standby Database\"}]},{\"@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":"SQL Apply Filtering on Logical Standby Database - Database Tutorials","description":"SQL Apply Filtering on Logical Standby Database","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\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/","og_locale":"en_US","og_type":"article","og_title":"SQL Apply Filtering on Logical Standby Database - Database Tutorials","og_description":"SQL Apply Filtering on Logical Standby Database","og_url":"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/","og_site_name":"Database Tutorials","article_published_time":"2020-07-01T07:39:03+00:00","article_modified_time":"2020-07-03T12:57:55+00:00","og_image":[{"width":495,"height":325,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/07\/Ads\u0131z-1.jpg","type":"image\/jpeg"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"SQL Apply Filtering on Logical Standby Database","datePublished":"2020-07-01T07:39:03+00:00","dateModified":"2020-07-03T12:57:55+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/"},"wordCount":271,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/07\/Ads\u0131z-1.jpg","keywords":["Check Filtering on logical standby","Check SQL Apply Filter","Check SQL Apply Filters","Delete SQL Apply Filter","Delete SQL Apply Filtering","DML Filtering in logical standby","Error and Transaction Filtering in Logical Standby","Error Filtering in Logical Standby","filters for a logical standby database","How to skip delete operations with data guard","standby skip dml","standby skip error","standby skip transaction","Start SQL Apply on logical standby","Stop SQL Apply in Logical Standby","stop SQL Apply on logical standby","Transaction Filtering in Logical Standby","XIDSLT","XIDSQN","XIDUSN"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/","url":"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/","name":"SQL Apply Filtering on Logical Standby Database - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/07\/Ads\u0131z-1.jpg","datePublished":"2020-07-01T07:39:03+00:00","dateModified":"2020-07-03T12:57:55+00:00","description":"SQL Apply Filtering on Logical Standby Database","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/07\/Ads\u0131z-1.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/07\/Ads\u0131z-1.jpg","width":495,"height":325},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/07\/01\/sql-apply-filtering-on-logical-standby-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"SQL Apply Filtering on Logical Standby Database"}]},{"@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\/15643","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=15643"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/15643\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/15925"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=15643"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=15643"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=15643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}