{"id":135,"date":"2011-02-07T17:33:11","date_gmt":"2011-02-07T16:33:11","guid":{"rendered":"http:\/\/jal-bs.de\/blog\/?p=135"},"modified":"2013-07-05T12:57:36","modified_gmt":"2013-07-05T10:57:36","slug":"oracle-flashback-data-archive","status":"publish","type":"post","link":"https:\/\/jal-bs.de\/blog\/?p=135","title":{"rendered":"Oracle Flashback Data Archive"},"content":{"rendered":"

Aufbewahrungsvorschriften und Gesetze beinhalten oft strikte Vorgaben Datens\u00e4tze vor L\u00f6schung und Manipulation zu sch\u00fctzen.
\nOracle 11g besitzt in der Enterprise Edition die kostenpflichtige Option \u201eTotal Recall\u201c,<\/strong> die es erlaubt, Dateninhalte \u00fcber einen \u201elangen\u201c Zeitraum versioniert aufzubewahren.
\nAber Vorsicht, nicht f\u00fcr alle Tabellen (z. B. external, tempor\u00e4r, \u2026) ist diese Funktionalit\u00e4t gegeben.<\/p>\n

Arbeitshinweise (Beispiele):<\/strong><\/p>\n

    \n
  1. \n
    Daten Archive anlegen.
    \nCREATE FLASHBACK ARCHIVE\u00a0 mein_archive\u00a0 TABLESPACE\u00a0 ts_name RETENTION 10\u00a0 YEAR<\/h5>\n<\/li>\n
  2. \n
    Tabellen (create, alter)
    \nCREATE TABLE\u00a0\u00a0 \u00a0\u00a0arc_table1\u00a0\u00a0\u00a0 (col1 …) FLASHBACK ARCHIVE mein_archive
    \nALTER TABLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 arc_table2\u00a0\u00a0\u00a0 FLASHBACK ARCHIVE mein_archive
    \nALTER TABLE\u00a0 arc_table1\u00a0 NO FLASHBACK ARCHIVE<\/h5>\n<\/li>\n
  3. \n
    Datenzugriff
    \nSELECT * FROM arc_table2\u00a0\u00a0 AS OF TIMESTAMP TO_TIMESTAMP(‚31.12.2010 23:59:59‘, ‚dd.mm.yyyy hh24:mi:ss‘)<\/h5>\n<\/li>\n
  4. \n
    Archive Verwaltung
    \nDROP FLASHBACK ARCHIVE\u00a0 mein_archive
    \nALTER FLASHBACK ARCHIVE\u00a0\u00a0 mein_archive\u00a0\u00a0 PURGE ALL
    \nALTER FLASHBACK ARCHIVE\u00a0\u00a0 mein_archive\u00a0\u00a0 PURGE BEFORE TIMESTAMP (SYSTIMESTAMP \u2013 INTERVAL \u20191\u2032 DAY)<\/h5>\n<\/li>\n<\/ol>\n

    Einschr\u00e4nkungen:<\/strong><\/p>\n

    Struktur\u00e4nderungen bei den Tabellen sind nur bedingt m\u00f6glich (au\u00dfer hinzuf\u00fcgen von Spalten). DROP, TRUNCATE und RENAME auf archivierte Tabellen f\u00fchren zu Fehlermeldungen.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Aufbewahrungsvorschriften und Gesetze beinhalten oft strikte Vorgaben Datens\u00e4tze vor L\u00f6schung und Manipulation zu sch\u00fctzen. Oracle 11g besitzt in der Enterprise Edition die kostenpflichtige Option \u201eTotal Recall\u201c, die es erlaubt, Dateninhalte \u00fcber einen \u201elangen\u201c Zeitraum versioniert aufzubewahren. Aber Vorsicht, nicht f\u00fcr … Weiterlesen →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[13],"_links":{"self":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/135"}],"collection":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=135"}],"version-history":[{"count":8,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/135\/revisions"}],"predecessor-version":[{"id":334,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/135\/revisions\/334"}],"wp:attachment":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}