{"id":4083,"date":"2018-05-28T12:00:48","date_gmt":"2018-05-28T11:00:48","guid":{"rendered":"https:\/\/www.data-protector.org\/wordpress\/?p=4083"},"modified":"2018-06-16T10:09:55","modified_gmt":"2018-06-16T09:09:55","slug":"sysbackup-oracle-12c","status":"publish","type":"post","link":"https:\/\/www.data-protector.org\/wordpress\/de\/2018\/05\/sysbackup-oracle-12c\/","title":{"rendered":"SYSBACKUP auf Oracle 12c"},"content":{"rendered":"<p>Oracle 12c verf\u00fcgt \u00fcber drei neue administrative Rollen und Benutzer. Diese k\u00f6nnen genutzt werden um die notwendigen Zugangsrechte f\u00fcr wichtige Aktivit\u00e4ten auf ein Minimum zu beschr\u00e4nken. Die Benutzer und Rollen Namens SYSBACKUP, SYSDG und SYSKM werden mit der Datenbank im Status expired und locked erstellt. Die SYSBACKUP wird zum Durchf\u00fchren von Sicherungs- und Wiederherstellungsvorg\u00e4ngen von Oracle Recovery Manager (RMAN) und\/oder SQL*Plus verwendet. Weiterf\u00fchrende Details zu Oracle Berechtigungen finden sich in der <a href=\"https:\/\/docs.oracle.com\/database\/121\/DBSEG\/authorization.htm#DBSEG785\">Oracle-Dokumentation<\/a>.<\/p>\n<p>Wenn Oracle 12c auf dem Clientsystem erkannt wird, verwendet Data Protector A.10.01 oder sp\u00e4ter automatisch <em>sqlplus user\/password@SID AS SYSBACKUP<\/em> f\u00fcr die Datenbankverbindung. Daher kann das folgende Sicherungsproblem nach einem Data Protector-Client oder einem Oracle-Datenbankupgrade auftreten.<\/p>\n<pre>ORA-01031: insufficient privileges\r\nCONNECT: sys\/*****@SID\r\n[Major] From: &#x6f;b&#x32;&#x72;m&#x61;&#110;&#64;&#x6f;&#114;a&#x63;&#108;e&#x2e;&#100;o&#x6d;a&#x69;&#x6e;.&#x6c;&#x61;n \"\" Time: 05\/15\/18 18:15:21\r\nBackup of target database failed.<\/pre>\n<p>\u00c4ltere Oracle-Datenbanken (10g, 11i) erfordern keine \u00c4nderungen. Diese verwenden weiterhin die SYSDBA Rolle.<!--more--><\/p>\n<p>Das urspr\u00fcngliche Verhalten kann mit der omnirc Variable <em>OB2_ORACLE_USE_SYSDBA=1<\/em> auf dem Datenbankserver wiederhergestellt werden, sofern die \u00c4nderungen nicht sofort implementiert werden k\u00f6nnen. Data Protector A.10.03 erm\u00f6glicht es diesen Parameter mit folgendem Kommando auf das Clientsystem zu verteilen. Ein Neustart der Dienste ist nicht notwendig.<\/p>\n<pre>omnicc -update_omnirc OB2_ORACLE_USE_SYSDBA -value 1 ClientFQDN\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Starting with Oracle 12c three new administrative roles and users have been introduced to conform the principle of access to the least privilege. The users and roles named SYSBACKUP, SYSDG and SYSKM will be created when the database is created with their account in expired and locked status.\u00a0SYSBACKUP is used to perform backup and recovery [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"spay_email":""},"categories":[11],"tags":[211,60,210],"translation":{"provider":"WPGlobus","version":"2.8.8","language":"de","enabled_languages":["en","de"],"languages":{"en":{"title":true,"content":true,"excerpt":false},"de":{"title":true,"content":true,"excerpt":false}}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p28cjj-13R","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":121,"url":"https:\/\/www.data-protector.org\/wordpress\/de\/2010\/08\/external-utility-reported-error\/","url_meta":{"origin":4083,"position":0},"title":"External utility reported error","date":"2. August 2010","format":false,"excerpt":"{:en}If you receive the error below during a backup of a Oracle Instance, a faulty Perl module on the client is the source of the problem... The problem is difficult to debug, so just ask support for QCIM2A24591_TM3. With the fix the module DPoracle.pm will be changed, this should resolve\u2026","rel":"","context":"In &quot;Bugs&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":903,"url":"https:\/\/www.data-protector.org\/wordpress\/de\/2012\/06\/backup-exec-no-longer-for-the-enterprise\/","url_meta":{"origin":4083,"position":1},"title":"Backup Exec no longer for the Enterprise","date":"7. Juni 2012","format":false,"excerpt":"{:de}Kurz und Knapp: Symantec hat in einem Artikel f\u00fcr Backup Exec 2012 einige seiner Komponenten auf EOL - end of life - gesetzt und verliert aus meiner Sicht die F\u00e4higkeit im Enterprise Backup & Recovery L\u00f6sungen anzubieten. Der Einsatz im Mittelstand ist fragw\u00fcrdig, da auch in diesem Bereich Anwendungen wie\u2026","rel":"","context":"In &quot;Common&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3209,"url":"https:\/\/www.data-protector.org\/wordpress\/de\/2016\/10\/hpe-data-protector-patch-bundle-9-08\/","url_meta":{"origin":4083,"position":2},"title":"Data Protector 9 &#8211; Patch Bundle 9.08 (Build 112)","date":"14. Oktober 2016","format":false,"excerpt":"{:en}On 2016\/10\/13 Hewlett Packard Enterprise released patch bundle 9.08 for Linux, HP-UX and Windows, it includes important changes and new features. For a complete list, please refer to the patch description. The focus for this release was stability, so only two new features were introduced: Microsoft Azure support and support\u2026","rel":"","context":"In &quot;DP A.09.00&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":897,"url":"https:\/\/www.data-protector.org\/wordpress\/de\/2012\/06\/current-patches-dp-6-21\/","url_meta":{"origin":4083,"position":3},"title":"Current Patches DP 6.21","date":"25. Juni 2012","format":false,"excerpt":"{:de}Wenn Sie einen g\u00fcltigen Wartungsvertrag haben, so k\u00f6nnen Sie die Patches unter http:\/\/support.openview.hp.com\/selfsolve\/patches herunterladen, die Anmeldung erfolgt mit dem HP Passport Account. \u00c4ltere Meldungen zu den Patches werden nach unten verschoben. Update 2012\/06\/22:\u00a0HP hat f\u00fcr DP 6.21 am 07.06.2012 und 22.06.2012 neue Patches herausgegeben, das Patch Bundle DPXXXBDL_00621 ist aber\u2026","rel":"","context":"In &quot;DP A.06.00&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1412,"url":"https:\/\/www.data-protector.org\/wordpress\/de\/2013\/06\/basics-installation-order-patches\/","url_meta":{"origin":4083,"position":4},"title":"Installation order of Patches","date":"3. Juni 2013","format":false,"excerpt":"{:de}Immer wieder stellt sich die Frage in welcher Reihenfolge die Patches f\u00fcr Data Protector installiert werden. Zwischen den einzelnen Patches ergeben sich Abh\u00e4ngigkeiten, welche man in den Beschreibungsdateien zum Patch nachlesen kann; diese m\u00fcssen bei der Installation eingehalten werden. Generell gilt folgende Reihenfolge f\u00fcr die Installation: sofern vorhanden: Patchbundle, Core,\u2026","rel":"","context":"In &quot;History&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1710,"url":"https:\/\/www.data-protector.org\/wordpress\/de\/2014\/01\/data-protector-8-10-whats-new\/","url_meta":{"origin":4083,"position":5},"title":"Data Protector 8.10 available &#8211; whats new?","date":"7. Januar 2014","format":false,"excerpt":"{:en}Data Protector 8.10 has been released. The new version delivers some new features, my favorites are the new advanced scheduler and the file-system backup, which can be resumed. For customers with a valid support contract, the new version can be downloaded here: http:\/\/support.openview.hp.com. With Data Protector 8.1 new licenses are\u2026","rel":"","context":"In &quot;Common&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.data-protector.org\/wordpress\/de\/wp-json\/wp\/v2\/posts\/4083"}],"collection":[{"href":"https:\/\/www.data-protector.org\/wordpress\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.data-protector.org\/wordpress\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.data-protector.org\/wordpress\/de\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.data-protector.org\/wordpress\/de\/wp-json\/wp\/v2\/comments?post=4083"}],"version-history":[{"count":15,"href":"https:\/\/www.data-protector.org\/wordpress\/de\/wp-json\/wp\/v2\/posts\/4083\/revisions"}],"predecessor-version":[{"id":4232,"href":"https:\/\/www.data-protector.org\/wordpress\/de\/wp-json\/wp\/v2\/posts\/4083\/revisions\/4232"}],"wp:attachment":[{"href":"https:\/\/www.data-protector.org\/wordpress\/de\/wp-json\/wp\/v2\/media?parent=4083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.data-protector.org\/wordpress\/de\/wp-json\/wp\/v2\/categories?post=4083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.data-protector.org\/wordpress\/de\/wp-json\/wp\/v2\/tags?post=4083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}