{"id":14,"date":"2015-07-16T08:50:03","date_gmt":"2015-07-16T07:50:03","guid":{"rendered":"http:\/\/hslomka.de\/techno\/?p=14"},"modified":"2015-07-16T08:50:03","modified_gmt":"2015-07-16T07:50:03","slug":"beenden-des-backup-mode-von-datendateien-tablespaces","status":"publish","type":"post","link":"https:\/\/techno.slomka.biz\/?p=14","title":{"rendered":"Beenden des Backup Mode von Datendateien \/ Tablespaces"},"content":{"rendered":"<p>Ist ein Tablespace im Backup Mode verblieben, obwohl das Backup nicht mehr l\u00e4uft, so muss der Modus manuell umgesetzt werden. Zuerst gilt es herauszufinden, welcher Tablespace oder welche Datendatei im Backup Modus ist. Dazu kann wie im Artikel <a href=\"http:\/\/hslomka.de\/techno\/?p=4\">Oracle Backup Mode auflisten<\/a> beschrieben vorgegangen werden.<\/p>\n<p>Meist m\u00f6chte man nur die Tablespaces wissen, da brbackup und andere Tools nicht einzelne Datendateien in den Backup Modus setzen, sondern den gesamten Tablespace.<br \/>\n<br \/>\n<em><span style=\"background-color:darkred;color:white\">Achtung: Bitte unbedingt pr\u00fcfen, ob wirklich kein Backup l\u00e4uft!<\/span><\/em><\/p>\n<p class=\"kasten\">\n> SELECT d.tablespace_name, b.time, b.status FROM dba_data_files d, v$backup b WHERE d.file_id = b.FILE# AND b.STATUS = &#8216;ACTIVE&#8217;;`TABLESPACE_NAME  TIME            STATUS<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;<br \/>\nPSAPSR3731       15-JUL-15       ACTIVE<br \/>\nPSAPSR3731       15-JUL-15       ACTIVE<br \/>\nPSAPSR3731       15-JUL-15       ACTIVE<br \/>\nPSAPSR3731       15-JUL-15       ACTIVE<br \/>\nPSAPSR3731       15-JUL-15       ACTIVE<br \/>\nPSAPSR3731       15-JUL-15       ACTIVE<br \/>\nPSAPSR3731       15-JUL-15       ACTIVE<br \/>\nPSAPSR3731       15-JUL-15       ACTIVE<br \/>\nPSAPSR3731       15-JUL-15       ACTIVE<br \/>\nPSAPSR3731       15-JUL-15       ACTIVE<br \/>\nPSAPSR3731       15-JUL-15       ACTIVE<br \/>\nPSAPSR3731       15-JUL-15       ACTIVE<br \/>\nPSAPSR3731       15-JUL-15       ACTIVE<br \/>\nPSAPSR3731       15-JUL-15       ACTIVE<br \/>\n14 rows selected.`<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ist ein Tablespace im Backup Mode verblieben, obwohl das Backup nicht mehr l\u00e4uft, so muss der Modus manuell umgesetzt werden. Zuerst gilt es herauszufinden, welcher Tablespace oder welche Datendatei im Backup Modus ist. Dazu kann wie im Artikel Oracle Backup Mode auflisten beschrieben vorgegangen werden. Meist m\u00f6chte man nur die Tablespaces wissen, da brbackup und andere Tools nicht einzelne Datendateien in den Backup Modus setzen, sondern den gesamten Tablespace. Achtung: Bitte unbedingt pr\u00fcfen, ob wirklich kein Backup l\u00e4uft! > SELECT d.tablespace_name, b.time, b.status FROM dba_data_files d, v$backup b WHERE d.file_id = b.FILE# AND b.STATUS = &#8216;ACTIVE&#8217;;`TABLESPACE_NAME TIME STATUS &#8212;&#8212;&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212; PSAPSR3731 15-JUL-15 ACTIVE PSAPSR3731 15-JUL-15 ACTIVE PSAPSR3731 15-JUL-15 ACTIVE PSAPSR3731 15-JUL-15 ACTIVE PSAPSR3731 15-JUL-15 ACTIVE PSAPSR3731 15-JUL-15 ACTIVE PSAPSR3731 15-JUL-15 ACTIVE PSAPSR3731 15-JUL-15 ACTIVE PSAPSR3731 15-JUL-15 ACTIVE PSAPSR3731 15-JUL-15 ACTIVE PSAPSR3731 15-JUL-15 ACTIVE PSAPSR3731 15-JUL-15 ACTIVE PSAPSR3731 15-JUL-15 ACTIVE PSAPSR3731 15-JUL-15 ACTIVE 14 rows selected.`<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,13,22],"tags":[43,45,76,77,99],"class_list":["post-14","post","type-post","status-publish","format-standard","hentry","category-oracle","category-oracle-datenbank","category-tablespaces","tag-backup-mode","tag-backupmodus","tag-oracle","tag-oracle-db-administration","tag-tablespace"],"_links":{"self":[{"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=\/wp\/v2\/posts\/14","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=14"}],"version-history":[{"count":0,"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=\/wp\/v2\/posts\/14\/revisions"}],"wp:attachment":[{"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}