{"id":211,"date":"2011-12-01T06:44:16","date_gmt":"2011-12-01T05:44:16","guid":{"rendered":"https:\/\/oracle-in-zen.de\/?p=211"},"modified":"2018-06-01T16:47:45","modified_gmt":"2018-06-01T15:47:45","slug":"ora-01113-nach-backup-crash-recovery-unnotig","status":"publish","type":"post","link":"https:\/\/oracle-in-zen.de\/?p=211","title":{"rendered":"ORA-01113 nach Backup Crash \/\/ Recovery unn\u00f6tig?!"},"content":{"rendered":"<p><span class=\"dropcap2\">S<\/span>ollte bei einem &#8218;User Managed Backup&#8220; \u00a0oder auch &#8222;Classic Backup&#8220; ein Datenbank Crash auftreten, muss nicht zwingend ein File Recovery durchgef\u00fchrt werden. Doch was passiert?<\/p>\n<p><!--more--><\/p>\n<pre>alter database begin backup;<\/pre>\n<p>Alle Datendateien werden in den Backup Modus gesetzt und k\u00f6nnen mit OS Befehlen kopiert bzw. gesichert werden. Sollte w\u00e4hrend des Backups nun ein Fehler auftreten, Server reboot oder ein DB Instanz Crash, kann es beim Neustart zu folgendem Fehler kommen:<\/p>\n<pre>startup\r\n...\r\nORA-01113: file 7 needs media recovery\r\nORA-01110: data file 7: &#039;d:\\oracle\\oradata\\orcl\\userdata01.dbf&#039;<\/pre>\n<p>&nbsp;<\/p>\n<p>Ein File Recovery k\u00f6nnte nun unn\u00f6tig sein. Die Datenbank ist nun im &#8222;mount&#8220; Zustand. Die Datendateien befinden sich noch im Backup Modus. Dies l\u00e4sst sich leicht pr\u00fcfen:<\/p>\n<pre>select * from v$backup;\r\n\r\n     FILE# STATUS                CHANGE# TIME\r\n---------- ------------------ ---------- --------\r\n         1 ACTIVE             8,3404E+12 01.09.09\r\n         2 ACTIVE             8,3404E+12 01.09.09\r\n         3 ACTIVE             8,3404E+12 01.09.09\r\n         4 ACTIVE             8,3404E+12 01.09.09\r\n         5 ACTIVE             8,3404E+12 01.09.09\r\n         6 ACTIVE             8,3404E+12 01.09.09\r\n         7 ACTIVE             8,3404E+12 01.09.09\r\n         8 ACTIVE             8,3404E+12 01.09.09\r\n         9 ACTIVE             8,3404E+12 01.09.09\r\n        10 ACTIVE             8,3404E+12 01.09.09<\/pre>\n<pre>alter database end backup;<\/pre>\n<pre>select * from v$backup;\r\n\r\n     FILE# STATUS                CHANGE# TIME\r\n---------- ------------------ ---------- --------\r\n         1 NOT ACTIVE         8,3404E+12 01.09.09\r\n         2 NOT ACTIVE         8,3404E+12 01.09.09\r\n         3 NOT ACTIVE         8,3404E+12 01.09.09\r\n         4 NOT ACTIVE         8,3404E+12 01.09.09\r\n         5 NOT ACTIVE         8,3404E+12 01.09.09\r\n         6 NOT ACTIVE         8,3404E+12 01.09.09\r\n         7 NOT ACTIVE         8,3404E+12 01.09.09\r\n         8 NOT ACTIVE         8,3404E+12 01.09.09\r\n         9 NOT ACTIVE         8,3404E+12 01.09.09\r\n        10 NOT ACTIVE         8,3404E+12 01.09.09<\/pre>\n<pre>alter database open<\/pre>\n<div><\/div>\n<p>Tada! Die Datenbank ist ge\u00f6ffnet und ein aufw\u00e4ndiges Recovery ist nicht notwendig.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sollte bei einem &#8218;User Managed Backup&#8220; \u00a0oder auch &#8222;Classic Backup&#8220; ein Datenbank Crash auftreten, muss nicht zwingend ein File Recovery durchgef\u00fchrt werden. Doch was passiert?<\/p>\n","protected":false},"author":1,"featured_media":1081,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"zakra_page_container_layout":"customizer","zakra_page_sidebar_layout":"customizer","zakra_remove_content_margin":false,"zakra_sidebar":"customizer","zakra_transparent_header":"customizer","zakra_logo":0,"zakra_main_header_style":"default","zakra_menu_item_color":"","zakra_menu_item_hover_color":"","zakra_menu_item_active_color":"","zakra_menu_active_style":"","zakra_page_header":true,"footnotes":""},"categories":[11,36],"tags":[25,13,37,26,18],"class_list":["post-211","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-2","category-ora","tag-backup","tag-database","tag-ora-2","tag-recovery","tag-script"],"_links":{"self":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts\/211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=211"}],"version-history":[{"count":34,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts\/211\/revisions"}],"predecessor-version":[{"id":1083,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts\/211\/revisions\/1083"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/media\/1081"}],"wp:attachment":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}