{"id":1729,"date":"2015-09-03T10:45:21","date_gmt":"2015-09-03T07:45:21","guid":{"rendered":"https:\/\/zoharelkayam.me\/?p=1729"},"modified":"2016-11-09T15:35:20","modified_gmt":"2016-11-09T13:35:20","slug":"no-logging-and-data-guard","status":"publish","type":"post","link":"https:\/\/www.realdbamagic.com\/he\/no-logging-and-data-guard\/","title":{"rendered":"\u05d4\u05d4\u05e9\u05e4\u05e2\u05d4 \u05e9\u05dc no logging \u05e2\u05dc data guard"},"content":{"rendered":"<p>\u05db\u05d1\u05e8 \u05db\u05ea\u05d1\u05ea\u05d9 \u05d1\u05e2\u05d1\u05e8 \u05e2\u05dc \u05d4\u05e7\u05de\u05d4 \u05e9\u05dc data guard \u05d5\u05d0\u05d7\u05d3 \u05d4\u05d3\u05d1\u05e8\u05d9\u05dd \u05e9\u05e6\u05d9\u05d9\u05e0\u05d5 \u05d1\u05de\u05e4\u05d5\u05e8\u05e9 \u05d6\u05d4 \u05e9\u05e8\u05e6\u05d5\u05d9 \u05de\u05d0\u05d5\u05d3 \u05dc\u05d4\u05e9\u05ea\u05de\u05e9 \u05d1-force logging \u05db\u05d3\u05d9 \u05dc\u05d4\u05d9\u05de\u05e0\u05e2 \u05de\u05d1\u05e2\u05d9\u05d5\u05ea \u05e9\u05dc \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05e9\u05e0\u05d8\u05e2\u05e0\u05d5\u05ea \u05d1-no logging.<\/p>\n<p>\u05d4\u05e9\u05d1\u05d5\u05e2 \u05e0\u05d3\u05e8\u05e9\u05ea\u05d9 \u05e9\u05d5\u05d1 \u05dc\u05e0\u05d5\u05e9\u05d0 \u05e2\u05dc \u05d9\u05d3\u05d9 \u05dc\u05e7\u05d5\u05d7. \u05d4\u05d5\u05d0 \u05e8\u05e6\u05d4 \u05dc\u05d3\u05e2\u05ea \u05de\u05d4 \u05e7\u05d5\u05e8\u05d4 \u05d0\u05dd \u05d1\u05db\u05dc \u05d6\u05d0\u05ea \u05d0\u05e0\u05d7\u05e0\u05d5 \u05e8\u05d5\u05e6\u05d9\u05dd \u05dc\u05d4\u05e7\u05d9\u05dd \u05e1\u05d1\u05d9\u05d1\u05d4 \u05e9\u05dc data guard \u05d0\u05d1\u05dc \u05d0\u05ea \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05d4\u05d1\u05d9\u05e0\u05d9\u05d9\u05dd \u05e9\u05dc\u05d5, \u05d4\u05d5\u05d0 \u05dc\u05d0 \u05e8\u05d5\u05e6\u05d4 \u05dc\u05d2\u05d1\u05d5\u05ea \u05d5\u05dc\u05d0 \u05d0\u05db\u05e4\u05ea \u05dc\u05d0 \u05e9\u05dc\u05d0 \u05d9\u05e2\u05d1\u05e8\u05d5 \u05dc\u05e1\u05d1\u05d9\u05d1\u05ea \u05d4-DR.<\/p>\n<p><!--more--><\/p>\n<p>\u05db\u05d3\u05d9 \u05dc\u05d4\u05d3\u05d2\u05d9\u05dd \u05de\u05d4 \u05e7\u05d5\u05e8\u05d4, \u05d1\u05d5\u05d0\u05d5 \u05e0\u05d1\u05e6\u05e2 \u05d0\u05ea \u05d6\u05d4 \u05d1\u05e4\u05d5\u05e2\u05dc.<\/p>\n<p>\u05d1\u05e9\u05dc\u05d1 \u05d4\u05e8\u05d0\u05e9\u05d5\u05df, \u05dc\u05e7\u05d7\u05ea\u05d9 \u05e1\u05d1\u05d9\u05d1\u05ea Data Guard \u05e9\u05d4\u05d9\u05d9\u05ea\u05d4 \u05dc\u05d9 \u05d5\u05d4\u05d5\u05e8\u05d3\u05ea\u05d9 \u05de\u05de\u05e0\u05d4 \u05d0\u05ea \u05d4-Force Logging<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nSQL&gt; select database_role from v$database;\r\n\r\nDATABASE_ROLE\r\n----------------\r\nPRIMARY\r\n\r\nSQL&gt; alter database no force logging\r\n  2  \/\r\n\r\nDatabase altered.\r\n\r\n<\/pre>\n<p>\u05dc\u05d0\u05d7\u05e8 \u05de\u05db\u05df, \u05d9\u05e6\u05e8\u05ea\u05d9 \u05d8\u05d1\u05dc\u05d4 \u05d6\u05de\u05e0\u05d9\u05ea \u05d1\u05e9\u05dd TT \u05e2\u05dd no logging \u05d5\u05d4\u05db\u05e0\u05e1\u05ea\u05d9 \u05d0\u05dc\u05d9\u05d4 \u05e0\u05ea\u05d5\u05e0\u05d9\u05dd:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nSQL&gt; create table tt nologging as select * From dba_objects;\r\n\r\nTable created.\r\n<\/pre>\n<p>\u05d1\u05d9\u05e6\u05e2\u05ea\u05d9 switchover \u05dc\u05e9\u05e8\u05ea \u05d4\u05e9\u05e0\u05d9:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n&#x5B;oracle@lnx-ora-server2 trace]$ dgmgrl sys\/oracle@orcl\r\nDGMGRL for Linux: Version 11.2.0.2.0 - Production\r\n\r\nCopyright (c) 2000, 2009, Oracle. All rights reserved.\r\n\r\nWelcome to DGMGRL, type &quot;help&quot; for information.\r\nConnected.\r\nDGMGRL&gt; show configuration;\r\n\r\nConfiguration - my_dg\r\n\r\n  Protection Mode: MaxPerformance\r\n  Databases:\r\n    orcldg - Primary database\r\n    orcl   - Physical standby database\r\n\r\nFast-Start Failover: DISABLED\r\n\r\nConfiguration Status:\r\nSUCCESS\r\n\r\nDGMGRL&gt; switchover to orcl\r\nPerforming switchover NOW, please wait...\r\nNew primary database &quot;orcl&quot; is opening...\r\nOperation requires shutdown of instance &quot;orcldg&quot; on database &quot;orcldg&quot;\r\nShutting down instance &quot;orcldg&quot;...\r\nORACLE instance shut down.\r\nOperation requires startup of instance &quot;orcldg&quot; on database &quot;orcldg&quot;\r\nStarting instance &quot;orcldg&quot;...\r\nORACLE instance started.\r\nDatabase mounted.\r\nDatabase opened.\r\nSwitchover succeeded, new primary is &quot;orcl&quot;\r\nDGMGRL&gt; exit\r\n<\/pre>\n<p>\u05dc\u05d0\u05d7\u05e8 \u05de\u05db\u05df, \u05d4\u05ea\u05d7\u05d1\u05e8\u05ea\u05d9 \u05dc-primary \u05d4\u05d7\u05d3\u05e9 \u05d5\u05e9\u05dc\u05e4\u05ea\u05d9 \u05de\u05d4\u05d8\u05d1\u05dc\u05d4:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nSQL&gt; select database_role from v$database;\r\n\r\nDATABASE_ROLE\r\n----------------\r\nPRIMARY\r\n\r\nSQL&gt; conn zohar\/zohar\r\nConnected.\r\nSQL&gt; select * From tt;\r\nselect * From tt\r\n              *\r\nERROR at line 1:\r\nORA-01578: ORACLE data block corrupted (file # 4, block # 29651)\r\nORA-01110: data file 4: '\/home\/oracle\/app\/oracle\/oradata\/orcl\/users01.dbf'\r\nORA-26040: Data block was loaded using the NOLOGGING option\r\n<\/pre>\n<p>\u05e0\u05d5\u05e6\u05e8\u05d4 \u05d1\u05e2\u05d9\u05d4 \u2013 \u05d4\u05d8\u05d1\u05dc\u05d4 \u05d4\u05d9\u05d9\u05ea\u05d4 \u05d1-no logging \u05d0\u05d6 \u05d4\u05de\u05d9\u05d3\u05e2 \u05d1\u05d4 \u05dc\u05d0 \u05e0\u05db\u05e0\u05e1 \u05dc-archive logs \u05d5\u05dc\u05db\u05df \u05dc\u05d0 \u05e2\u05d1\u05e8 \u05dc-standby. \u05d6\u05d4 \u05d0\u05d5\u05de\u05e8 \u05e9\u05d4\u05de\u05d9\u05d3\u05e2 \u05e9\u05dc\u05d4 \u05dc\u05d0 \u05ea\u05e7\u05d9\u05df. \u05de\u05d1\u05d7\u05d9\u05e0\u05ea \u05d1\u05e1\u05d9\u05e1 \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05d4\u05d1\u05dc\u05d5\u05e7\u05d9\u05dd \u05e9\u05dc \u05d4\u05d8\u05d1\u05dc\u05d4 \u05d4\u05d6\u05d5 \u05d4\u05dd soft corrupted \u2013 \u05db\u05dc\u05d5\u05de\u05e8 \u05d9\u05e9 \u05e9\u05dd \u05de\u05d9\u05e0\u05d9 corruption \u05d0\u05d1\u05dc \u05db\u05d6\u05d4 \u05e9\u05e0\u05d9\u05ea\u05df \u05dc\u05ea\u05e7\u05df \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea truncate table &nbsp;\u05e4\u05e9\u05d5\u05d8:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nSQL&gt; truncate table tt;\r\n\r\nTable truncated.\r\n\r\nSQL&gt; select * from tt;\r\n\r\nno rows selected\r\n<\/pre>\n<p>\u05e9\u05d5\u05d5\u05d4 \u05dc\u05e6\u05d9\u05d9\u05df \u05e9\u05d2\u05dd \u05d1-alert log \u05d9\u05e6\u05d5\u05d9\u05d9\u05df \u05e9\u05d4\u05d9\u05d4 \u05dc\u05e0\u05d5 corruption (\u05d5\u05d6\u05d4 \u05d9\u05e8\u05e9\u05dd \u05d2\u05dd \u05d1-ADR):<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n&#x5B;oracle@lnx-ora-server1 trace]$ adrci\r\n\r\nADRCI: Release 11.2.0.2.0 - Production on Mon Feb 23 16:06:28 2015\r\n\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nADR base = &quot;\/home\/oracle\/app\/oracle&quot;\r\nadrci&gt; show homes\r\nADR Homes: \r\ndiag\/rdbms\/orcl\/orcl\r\nadrci&gt; set home diag\/rdbms\/orcl\/orcl\r\nadrci&gt; show incidents\r\n\r\nADR Home = \/home\/oracle\/app\/oracle\/diag\/rdbms\/orcl\/orcl:\r\n*************************************************************************\r\nINCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME                              \r\n-------------------- ----------------------------------------------------------- ---------------------------------------- \r\n219969               ORA 1578                                                    2015-02-23 15:44:11.243000 +02:00       \r\n219970               ORA 1578                                                    2015-02-23 15:44:13.294000 +02:00       \r\n2 rows fetched\r\n<\/pre>\n<h2>\u05e1\u05d9\u05db\u05d5\u05dd<\/h2>\n<p>\u05e8\u05d0\u05d9\u05e0\u05d5 \u05e9\u05d0\u05d9 \u05e9\u05d9\u05de\u05d5\u05e9 \u05d1-force logging \u05e2\u05dc\u05d5\u05dc \u05dc\u05d9\u05e6\u05d5\u05e8 \u05dc\u05e0\u05d5 \u05d1\u05e2\u05d9\u05d4 \u05e9\u05dc corruptions. \u05dc\u05d0 \u05de\u05d3\u05d5\u05d1\u05e8 \u05e4\u05d4 \u05d1\u05de\u05e9\u05d4\u05d5 \u05d9\u05d7\u05d5\u05d3\u05d9 \u05dc-data guard \u2013 \u05d2\u05dd \u05d2\u05d9\u05d1\u05d5\u05d9 \u05d0\u05d9\u05e0\u05e7\u05e8\u05de\u05e0\u05d8\u05dc\u05d9 \u05d0\u05d5 \u05db\u05dc \u05d2\u05dc\u05d2\u05d5\u05dc \u05e9\u05dc archive-\u05d9\u05dd \u05d9\u05e6\u05d5\u05e8 \u05dc\u05e0\u05d5 \u05d0\u05ea \u05d0\u05d5\u05ea\u05d4 \u05d4\u05d1\u05e2\u05d9\u05d4 \u05d5\u05dc\u05db\u05df \u05d7\u05e9\u05d5\u05d1 \u05de\u05d0\u05d5\u05d3 \u05e9\u05e0\u05d1\u05d9\u05df \u05de\u05d4 \u05d4\u05de\u05e9\u05de\u05e2\u05d5\u05ea \u05e9\u05dc \u05e9\u05d9\u05de\u05d5\u05e9 \u05d1-no logging.<\/p>\n<p>\u05d0\u05dd \u05d0\u05e0\u05d7\u05e0\u05d5 \u05de\u05d5\u05d3\u05e2\u05d9\u05dd \u05d1\u05d0\u05d5\u05e4\u05df \u05de\u05dc\u05d0 \u05dc\u05de\u05e9\u05de\u05e2\u05d5\u05ea \u05e9\u05dc \u05d4\u05e9\u05d9\u05de\u05d5\u05e9 \u05d1-no logging \u05d5\u05de\u05d5\u05db\u05e0\u05d9\u05dd \u05dc\u05d0\u05d1\u05d3 \u05d0\u05ea \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05d1\u05de\u05d9\u05d3\u05d4 \u05d5\u05e0\u05d1\u05e6\u05e2 \u05e9\u05d7\u05d6\u05d5\u05e8 (\u05d0\u05d5 \u05d1\u05de\u05e7\u05e8\u05d4 \u05e9\u05dc\u05e0\u05d5 switchover) \u05d0\u05d9\u05df \u05e9\u05d5\u05dd \u05d1\u05e2\u05d9\u05d4 \u05dc\u05d4\u05de\u05e9\u05d9\u05da \u05d5\u05dc\u05e2\u05d1\u05d5\u05d3 \u05db\u05db\u05d4. \u05de\u05d4 \u05e9\u05d7\u05e9\u05d5\u05d1 \u05d6\u05d4 \u05dc\u05d4\u05d1\u05d9\u05df \u05d0\u05ea \u05d4\u05de\u05e9\u05de\u05e2\u05d5\u05ea.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u05db\u05d1\u05e8 \u05db\u05ea\u05d1\u05ea\u05d9 \u05d1\u05e2\u05d1\u05e8 \u05e2\u05dc \u05d4\u05e7\u05de\u05d4 \u05e9\u05dc data guard \u05d5\u05d0\u05d7\u05d3 \u05d4\u05d3\u05d1\u05e8\u05d9\u05dd \u05e9\u05e6\u05d9\u05d9\u05e0\u05d5 \u05d1\u05de\u05e4\u05d5\u05e8\u05e9 \u05d6\u05d4 \u05e9\u05e8\u05e6\u05d5\u05d9 \u05de\u05d0\u05d5\u05d3 \u05dc\u05d4\u05e9\u05ea\u05de\u05e9 \u05d1-force logging \u05db\u05d3\u05d9 \u05dc\u05d4\u05d9\u05de\u05e0\u05e2 \u05de\u05d1\u05e2\u05d9\u05d5\u05ea \u05e9\u05dc \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05e9\u05e0\u05d8\u05e2\u05e0\u05d5\u05ea \u05d1-no logging. \u05d4\u05e9\u05d1\u05d5\u05e2 \u05e0\u05d3\u05e8\u05e9\u05ea\u05d9 \u05e9\u05d5\u05d1 \u05dc\u05e0\u05d5\u05e9\u05d0 \u05e2\u05dc \u05d9\u05d3\u05d9 \u05dc\u05e7\u05d5\u05d7. \u05d4\u05d5\u05d0 \u05e8\u05e6\u05d4 \u05dc\u05d3\u05e2\u05ea \u05de\u05d4 \u05e7\u05d5\u05e8\u05d4 \u05d0\u05dd \u05d1\u05db\u05dc \u05d6\u05d0\u05ea \u05d0\u05e0\u05d7\u05e0\u05d5 \u05e8\u05d5\u05e6\u05d9\u05dd \u05dc\u05d4\u05e7\u05d9\u05dd \u05e1\u05d1\u05d9\u05d1\u05d4 \u05e9\u05dc data guard \u05d0\u05d1\u05dc \u05d0\u05ea \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05d4\u05d1\u05d9\u05e0\u05d9\u05d9\u05dd \u05e9\u05dc\u05d5, \u05d4\u05d5\u05d0 \u05dc\u05d0 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"\u05e4\u05d5\u05e1\u05d8 \u05d7\u05d3\u05e9: \u05d4\u05d4\u05e9\u05e4\u05e2\u05d4 \u05e9\u05dc no logging \u05e2\u05dc data guard http:\/\/wp.me\/p5e40u-rT","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}},"categories":[15,6],"tags":[92,114],"class_list":["post-1729","post","type-post","status-publish","format-standard","hentry","category-dataguard","category-oracle","tag-oracle-data-guard","tag-redo-log"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u05d4\u05d4\u05e9\u05e4\u05e2\u05d4 \u05e9\u05dc no logging \u05e2\u05dc data guard - Real Time DBA Magic<\/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.realdbamagic.com\/he\/no-logging-and-data-guard\/\" \/>\n<meta property=\"og:locale\" content=\"he_IL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u05d4\u05d4\u05e9\u05e4\u05e2\u05d4 \u05e9\u05dc no logging \u05e2\u05dc data guard - Real Time DBA Magic\" \/>\n<meta property=\"og:description\" content=\"\u05db\u05d1\u05e8 \u05db\u05ea\u05d1\u05ea\u05d9 \u05d1\u05e2\u05d1\u05e8 \u05e2\u05dc \u05d4\u05e7\u05de\u05d4 \u05e9\u05dc data guard \u05d5\u05d0\u05d7\u05d3 \u05d4\u05d3\u05d1\u05e8\u05d9\u05dd \u05e9\u05e6\u05d9\u05d9\u05e0\u05d5 \u05d1\u05de\u05e4\u05d5\u05e8\u05e9 \u05d6\u05d4 \u05e9\u05e8\u05e6\u05d5\u05d9 \u05de\u05d0\u05d5\u05d3 \u05dc\u05d4\u05e9\u05ea\u05de\u05e9 \u05d1-force logging \u05db\u05d3\u05d9 \u05dc\u05d4\u05d9\u05de\u05e0\u05e2 \u05de\u05d1\u05e2\u05d9\u05d5\u05ea \u05e9\u05dc \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05e9\u05e0\u05d8\u05e2\u05e0\u05d5\u05ea \u05d1-no logging. \u05d4\u05e9\u05d1\u05d5\u05e2 \u05e0\u05d3\u05e8\u05e9\u05ea\u05d9 \u05e9\u05d5\u05d1 \u05dc\u05e0\u05d5\u05e9\u05d0 \u05e2\u05dc \u05d9\u05d3\u05d9 \u05dc\u05e7\u05d5\u05d7. \u05d4\u05d5\u05d0 \u05e8\u05e6\u05d4 \u05dc\u05d3\u05e2\u05ea \u05de\u05d4 \u05e7\u05d5\u05e8\u05d4 \u05d0\u05dd \u05d1\u05db\u05dc \u05d6\u05d0\u05ea \u05d0\u05e0\u05d7\u05e0\u05d5 \u05e8\u05d5\u05e6\u05d9\u05dd \u05dc\u05d4\u05e7\u05d9\u05dd \u05e1\u05d1\u05d9\u05d1\u05d4 \u05e9\u05dc data guard \u05d0\u05d1\u05dc \u05d0\u05ea \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05d4\u05d1\u05d9\u05e0\u05d9\u05d9\u05dd \u05e9\u05dc\u05d5, \u05d4\u05d5\u05d0 \u05dc\u05d0 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.realdbamagic.com\/he\/no-logging-and-data-guard\/\" \/>\n<meta property=\"og:site_name\" content=\"Real Time DBA Magic\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/zohare\" \/>\n<meta property=\"article:author\" content=\"https:\/\/facebook.com\/zohare\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-03T07:45:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-11-09T13:35:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.realdbamagic.com\/wp-content\/uploads\/2014\/12\/Facebook-Share-profile-photo-270-x-270_2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"270\" \/>\n\t<meta property=\"og:image:height\" content=\"270\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@realmgic\" \/>\n<meta name=\"twitter:site\" content=\"@realmgic\" \/>\n<meta name=\"twitter:label1\" content=\"\u05e0\u05db\u05ea\u05d1 \u05e2\u05dc \u05d9\u05d3\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u05d6\u05de\u05df \u05e7\u05e8\u05d9\u05d0\u05d4 \u05de\u05d5\u05e2\u05e8\u05da\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u05d3\u05e7\u05d5\u05ea\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/no-logging-and-data-guard\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/no-logging-and-data-guard\\\/\"},\"author\":{\"name\":\"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#\\\/schema\\\/person\\\/fef9c8983df7a5ec53d0e2c733148334\"},\"headline\":\"\u05d4\u05d4\u05e9\u05e4\u05e2\u05d4 \u05e9\u05dc no logging \u05e2\u05dc data guard\",\"datePublished\":\"2015-09-03T07:45:21+00:00\",\"dateModified\":\"2016-11-09T13:35:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/no-logging-and-data-guard\\\/\"},\"wordCount\":376,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#\\\/schema\\\/person\\\/13e6cf68689bd7ea5f6556f5246e6175\"},\"keywords\":[\"Oracle Data Guard\",\"redo log\"],\"articleSection\":[\"DataGuard\",\"Oracle\"],\"inLanguage\":\"he-IL\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/no-logging-and-data-guard\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/no-logging-and-data-guard\\\/\",\"url\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/no-logging-and-data-guard\\\/\",\"name\":\"\u05d4\u05d4\u05e9\u05e4\u05e2\u05d4 \u05e9\u05dc no logging \u05e2\u05dc data guard - Real Time DBA Magic\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#website\"},\"datePublished\":\"2015-09-03T07:45:21+00:00\",\"dateModified\":\"2016-11-09T13:35:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/no-logging-and-data-guard\\\/#breadcrumb\"},\"inLanguage\":\"he-IL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/no-logging-and-data-guard\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/no-logging-and-data-guard\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u05d4\u05d4\u05e9\u05e4\u05e2\u05d4 \u05e9\u05dc no logging \u05e2\u05dc data guard\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#website\",\"url\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/\",\"name\":\"Real Time DBA Magic\",\"description\":\"Doing Real Time DBA Magics\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#\\\/schema\\\/person\\\/13e6cf68689bd7ea5f6556f5246e6175\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"he-IL\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#\\\/schema\\\/person\\\/13e6cf68689bd7ea5f6556f5246e6175\",\"name\":\"Zohar Elkayam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"he-IL\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g\",\"caption\":\"Zohar Elkayam\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g\"},\"sameAs\":[\"https:\\\/\\\/zoharelkayam.me\",\"https:\\\/\\\/facebook.com\\\/zohare\",\"https:\\\/\\\/x.com\\\/realmgic\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#\\\/schema\\\/person\\\/fef9c8983df7a5ec53d0e2c733148334\",\"name\":\"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"he-IL\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g\",\"caption\":\"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd\"},\"sameAs\":[\"https:\\\/\\\/zoharelkayam.me\",\"https:\\\/\\\/facebook.com\\\/zohare\",\"https:\\\/\\\/x.com\\\/realmgic\"],\"url\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/author\\\/zohar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u05d4\u05d4\u05e9\u05e4\u05e2\u05d4 \u05e9\u05dc no logging \u05e2\u05dc data guard - Real Time DBA Magic","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.realdbamagic.com\/he\/no-logging-and-data-guard\/","og_locale":"he_IL","og_type":"article","og_title":"\u05d4\u05d4\u05e9\u05e4\u05e2\u05d4 \u05e9\u05dc no logging \u05e2\u05dc data guard - Real Time DBA Magic","og_description":"\u05db\u05d1\u05e8 \u05db\u05ea\u05d1\u05ea\u05d9 \u05d1\u05e2\u05d1\u05e8 \u05e2\u05dc \u05d4\u05e7\u05de\u05d4 \u05e9\u05dc data guard \u05d5\u05d0\u05d7\u05d3 \u05d4\u05d3\u05d1\u05e8\u05d9\u05dd \u05e9\u05e6\u05d9\u05d9\u05e0\u05d5 \u05d1\u05de\u05e4\u05d5\u05e8\u05e9 \u05d6\u05d4 \u05e9\u05e8\u05e6\u05d5\u05d9 \u05de\u05d0\u05d5\u05d3 \u05dc\u05d4\u05e9\u05ea\u05de\u05e9 \u05d1-force logging \u05db\u05d3\u05d9 \u05dc\u05d4\u05d9\u05de\u05e0\u05e2 \u05de\u05d1\u05e2\u05d9\u05d5\u05ea \u05e9\u05dc \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05e9\u05e0\u05d8\u05e2\u05e0\u05d5\u05ea \u05d1-no logging. \u05d4\u05e9\u05d1\u05d5\u05e2 \u05e0\u05d3\u05e8\u05e9\u05ea\u05d9 \u05e9\u05d5\u05d1 \u05dc\u05e0\u05d5\u05e9\u05d0 \u05e2\u05dc \u05d9\u05d3\u05d9 \u05dc\u05e7\u05d5\u05d7. \u05d4\u05d5\u05d0 \u05e8\u05e6\u05d4 \u05dc\u05d3\u05e2\u05ea \u05de\u05d4 \u05e7\u05d5\u05e8\u05d4 \u05d0\u05dd \u05d1\u05db\u05dc \u05d6\u05d0\u05ea \u05d0\u05e0\u05d7\u05e0\u05d5 \u05e8\u05d5\u05e6\u05d9\u05dd \u05dc\u05d4\u05e7\u05d9\u05dd \u05e1\u05d1\u05d9\u05d1\u05d4 \u05e9\u05dc data guard \u05d0\u05d1\u05dc \u05d0\u05ea \u05d8\u05d1\u05dc\u05d0\u05d5\u05ea \u05d4\u05d1\u05d9\u05e0\u05d9\u05d9\u05dd \u05e9\u05dc\u05d5, \u05d4\u05d5\u05d0 \u05dc\u05d0 [&hellip;]","og_url":"https:\/\/www.realdbamagic.com\/he\/no-logging-and-data-guard\/","og_site_name":"Real Time DBA Magic","article_publisher":"https:\/\/facebook.com\/zohare","article_author":"https:\/\/facebook.com\/zohare","article_published_time":"2015-09-03T07:45:21+00:00","article_modified_time":"2016-11-09T13:35:20+00:00","og_image":[{"width":270,"height":270,"url":"https:\/\/www.realdbamagic.com\/wp-content\/uploads\/2014\/12\/Facebook-Share-profile-photo-270-x-270_2.png","type":"image\/png"}],"author":"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd","twitter_card":"summary_large_image","twitter_creator":"@realmgic","twitter_site":"@realmgic","twitter_misc":{"\u05e0\u05db\u05ea\u05d1 \u05e2\u05dc \u05d9\u05d3":"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd","\u05d6\u05de\u05df \u05e7\u05e8\u05d9\u05d0\u05d4 \u05de\u05d5\u05e2\u05e8\u05da":"2 \u05d3\u05e7\u05d5\u05ea"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.realdbamagic.com\/he\/no-logging-and-data-guard\/#article","isPartOf":{"@id":"https:\/\/www.realdbamagic.com\/he\/no-logging-and-data-guard\/"},"author":{"name":"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd","@id":"https:\/\/www.realdbamagic.com\/he\/#\/schema\/person\/fef9c8983df7a5ec53d0e2c733148334"},"headline":"\u05d4\u05d4\u05e9\u05e4\u05e2\u05d4 \u05e9\u05dc no logging \u05e2\u05dc data guard","datePublished":"2015-09-03T07:45:21+00:00","dateModified":"2016-11-09T13:35:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.realdbamagic.com\/he\/no-logging-and-data-guard\/"},"wordCount":376,"commentCount":0,"publisher":{"@id":"https:\/\/www.realdbamagic.com\/he\/#\/schema\/person\/13e6cf68689bd7ea5f6556f5246e6175"},"keywords":["Oracle Data Guard","redo log"],"articleSection":["DataGuard","Oracle"],"inLanguage":"he-IL","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.realdbamagic.com\/he\/no-logging-and-data-guard\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.realdbamagic.com\/he\/no-logging-and-data-guard\/","url":"https:\/\/www.realdbamagic.com\/he\/no-logging-and-data-guard\/","name":"\u05d4\u05d4\u05e9\u05e4\u05e2\u05d4 \u05e9\u05dc no logging \u05e2\u05dc data guard - Real Time DBA Magic","isPartOf":{"@id":"https:\/\/www.realdbamagic.com\/he\/#website"},"datePublished":"2015-09-03T07:45:21+00:00","dateModified":"2016-11-09T13:35:20+00:00","breadcrumb":{"@id":"https:\/\/www.realdbamagic.com\/he\/no-logging-and-data-guard\/#breadcrumb"},"inLanguage":"he-IL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.realdbamagic.com\/he\/no-logging-and-data-guard\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.realdbamagic.com\/he\/no-logging-and-data-guard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.realdbamagic.com\/he\/"},{"@type":"ListItem","position":2,"name":"\u05d4\u05d4\u05e9\u05e4\u05e2\u05d4 \u05e9\u05dc no logging \u05e2\u05dc data guard"}]},{"@type":"WebSite","@id":"https:\/\/www.realdbamagic.com\/he\/#website","url":"https:\/\/www.realdbamagic.com\/he\/","name":"Real Time DBA Magic","description":"Doing Real Time DBA Magics","publisher":{"@id":"https:\/\/www.realdbamagic.com\/he\/#\/schema\/person\/13e6cf68689bd7ea5f6556f5246e6175"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.realdbamagic.com\/he\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"he-IL"},{"@type":["Person","Organization"],"@id":"https:\/\/www.realdbamagic.com\/he\/#\/schema\/person\/13e6cf68689bd7ea5f6556f5246e6175","name":"Zohar Elkayam","image":{"@type":"ImageObject","inLanguage":"he-IL","@id":"https:\/\/secure.gravatar.com\/avatar\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g","caption":"Zohar Elkayam"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g"},"sameAs":["https:\/\/zoharelkayam.me","https:\/\/facebook.com\/zohare","https:\/\/x.com\/realmgic"]},{"@type":"Person","@id":"https:\/\/www.realdbamagic.com\/he\/#\/schema\/person\/fef9c8983df7a5ec53d0e2c733148334","name":"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd","image":{"@type":"ImageObject","inLanguage":"he-IL","@id":"https:\/\/secure.gravatar.com\/avatar\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g","caption":"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd"},"sameAs":["https:\/\/zoharelkayam.me","https:\/\/facebook.com\/zohare","https:\/\/x.com\/realmgic"],"url":"https:\/\/www.realdbamagic.com\/he\/author\/zohar\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p5e40u-rT","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/posts\/1729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/comments?post=1729"}],"version-history":[{"count":5,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/posts\/1729\/revisions"}],"predecessor-version":[{"id":2202,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/posts\/1729\/revisions\/2202"}],"wp:attachment":[{"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/media?parent=1729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/categories?post=1729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/tags?post=1729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}