{"id":183,"date":"2011-07-03T05:43:09","date_gmt":"2011-07-03T03:43:09","guid":{"rendered":"http:\/\/jal-bs.de\/blog\/?p=183"},"modified":"2012-10-19T07:15:45","modified_gmt":"2012-10-19T05:15:45","slug":"verifikation-der-rman-backups-ohne-physikalische-restauration-der-daten","status":"publish","type":"post","link":"https:\/\/jal-bs.de\/blog\/?p=183","title":{"rendered":"Verifikation der RMAN-Backups ohne physikalische Restauration der Daten"},"content":{"rendered":"

Oracle Datenbanken werden meist mit dem RMAN gesichert. Ob dieser Backup <\/span><\/span>auch sicher wiederverwendbar ist um die Datenbank wiederherzustellen zu k\u00f6nnen <\/span><\/span>kann in der Praxis entweder durch einen Restore\/Recover auf einem Testsystem <\/span><\/span>gepr\u00fcft werden oder durch das „validate!-RMAN Kommando.<\/span><\/span>\u00a0<\/span><\/p>\n

Wie folgt k\u00f6nnte vorgegangen werden:<\/span><\/span>\u00a0<\/span><\/p>\n

1) Ermitteln, welche Backups f\u00fcr den Restore\/Recover ben\u00f6tigt werden.
\n\u00a0\u00a0\u00a0 <\/span><\/span>(Sinnvollerweise sollte ein RMAN-Repository vorhanden sein.)<\/span><\/span><\/p>\n

run\u00a0{
\n<\/span><\/span>set until time „to_date(‚01.12.2011-21:54:00′,’dd.mm.yyyy-hh24:mi:ss‘)“;
\n<\/span><\/span>restore database preview;
\n<\/span><\/span>}\u00a0<\/span><\/span>\u00a0<\/span><\/p>\n

2) \u00dcberpr\u00fcfung, ob die Backup Sets\/Pieces\/Copies vorhanden sind.<\/span><\/span>\u00a0<\/span><\/p>\n

run <\/span><\/span>{
\n<\/span><\/span>allocate channel …
\n<\/span><\/span>set until time „to_date(‚01.12.2011-21:54:00′,’dd.mm.yyyy-hh24:mi:ss‘)“;
\n<\/span><\/span>restore database validate;
\n<\/span><\/span>} <\/span><\/span><\/p>\n

\u00a0<\/span>3) \u00dcberpr\u00fcfung, ob die erforderlichen Archivelogs vorhanden sind.<\/span><\/span>\u00a0<\/span><\/p>\n

run <\/span><\/span>{
\n<\/span><\/span>allocate channel …
\n<\/span><\/span>set until time „to_date(‚01.12.2011-21:54:00′,’dd.mm.yyyy-hh24:mi:ss‘)“;
\n<\/span><\/span>restore archivelog from sequence xxx_start\u00a0 until sequence xxx_end\u00a0 validate;
\n<\/span><\/span>} <\/span><\/span><\/p>\n

Wobei xxx_start und xxx_end der Archivelogs-Sequenzen aus 1) zu entnehmen ist.<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle Datenbanken werden meist mit dem RMAN gesichert. Ob dieser Backup auch sicher wiederverwendbar ist um die Datenbank wiederherzustellen zu k\u00f6nnen kann in der Praxis entweder durch einen Restore\/Recover auf einem Testsystem gepr\u00fcft werden oder durch das „validate!-RMAN Kommando.\u00a0 Wie … 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":[],"_links":{"self":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/183"}],"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=183"}],"version-history":[{"count":8,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/183\/revisions"}],"predecessor-version":[{"id":311,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/183\/revisions\/311"}],"wp:attachment":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}