{"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: ob2rman&#64;oracle.domain.lan \"\" 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":3514,"url":"https:\/\/www.data-protector.org\/wordpress\/de\/2017\/09\/data-protector-10-patch-bundle-a-10-01-build-307\/","url_meta":{"origin":4083,"position":1},"title":"Data Protector 10 \u2013 Patch Bundle A.10.01 (Build 307)","date":"28. September 2017","format":false,"excerpt":"{:en}The Patch Bundle A.10.01 (Build 307) for Data Protector 10 has been released on September 28, 2017. This first cumulative patch can be installed on top of A.10.00. It is recommended to install it on all Installation Servers (IS) and the Cell Managers (CM). Then push the new packages from\u2026","rel":"","context":"In &quot;DP A.10.00&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":903,"url":"https:\/\/www.data-protector.org\/wordpress\/de\/2012\/06\/backup-exec-no-longer-for-the-enterprise\/","url_meta":{"origin":4083,"position":3},"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":1710,"url":"https:\/\/www.data-protector.org\/wordpress\/de\/2014\/01\/data-protector-8-10-whats-new\/","url_meta":{"origin":4083,"position":4},"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":[]},{"id":2426,"url":"https:\/\/www.data-protector.org\/wordpress\/de\/2015\/12\/hpe-data-protector-patch-bundle-9-05-features\/","url_meta":{"origin":4083,"position":5},"title":"Data Protector 9 &#8211; Patch Bundle 9.05 (Build 105)","date":"4. Dezember 2015","format":false,"excerpt":"{:en}On 2015\/12\/04 Hewlett Packard Enterprise released patch bundle 9.05 for Linux, HP-UX and Windows, it includes important changes and new features. For a complete list see patch description. Some new features: Re-branding to Hewlett Packard Enterprise Recovery Manager Central integration into Data Protector Federated Catalyst and CoFC for Solaris and\u2026","rel":"","context":"In &quot;DP A.09.00&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}]}}