{"id":7401,"date":"2020-02-05T12:39:53","date_gmt":"2020-02-05T12:39:53","guid":{"rendered":"https:\/\/rax-stg-wp-aws.com\/blogs\/introduction-to-oracle-secure-backup-in-aws\/"},"modified":"2026-11-03T19:28:39","modified_gmt":"2026-11-03T19:28:39","slug":"introduction-to-oracle-secure-backup-in-aws","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/en-gb\/blogs\/introduction-to-oracle-secure-backup-in-aws\/","title":{"rendered":"Introduction to Oracle Secure Backup in AWS"},"content":{"rendered":"<p><strong>Introduction<\/strong><\/p>\n<p>Starting with Oracle Database 9i Release 2 or later, you can take a Recovery Manager (RMAN) backup by using OSB on Amazon S3. However, you cannot take the backup of the operating system (OS) files by using this module. The Amazon S3 storage is disk-based; it is inherently more reliable than tape media. Internet storage service providers keep multiple, redundant copies of your data for availability and scalability purposes. Your organization benefits from this practice by having more reliable data.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26410-body-Picture1_25.png\" alt=\"oracle aws pic 1\" \/><\/p>\n<p><a href=\"https:\/\/www.oracle.com\/technetwork\/database\/features\/availability\/twp-oracledbcloudbackup-130129.pdf\">Image Source<\/a><\/p>\n<p><strong>Requirements<\/strong><\/p>\n<p>To follow along with this post, make sure you consider the following requirements.<\/p>\n<p><strong>Access keys and the secret access key, or IAM role, to log in to S3<\/strong><\/p>\n<p>You need an AWS account and an Identity and Access Management (IAM) user with&nbsp;full access to AWS S3.&nbsp;The setup process uses the IAM role, or access keys, and the secret access key&nbsp;of the IAM user.<\/p>\n<p><strong>OSB module for AWS<\/strong><br \/>\n<a href=\"https:\/\/www.oracle.com\/database\/technologies\/secure-backup-s3.html\">Download the OSB module for AWS<\/a><\/p>\n<p><strong>&nbsp;Oracle Technology Network (OTN) account<\/strong><\/p>\n<p>During installation, you need to provide an OTN username and a password.<\/p>\n<p><strong>Java 1.7 or higher<\/strong><\/p>\n<p>You must install Java\u00ae 1.7 or later on your server before you can proceed.<\/p>\n<p>Run the following command to check the Java version:<\/p>\n<p><em>$java -version<\/em><\/p>\n<p><strong>Supported platforms<\/strong><\/p>\n<ul>\n<li class=\"text-align-justify\"><strong>Linux<\/strong>\u00ae<strong>; x86-64<\/strong><\/li>\n<li class=\"text-align-justify\"><strong>Microsoft<\/strong>\u00ae<strong>; Windows<\/strong>\u00ae<strong> (64-bit)<\/strong><\/li>\n<li class=\"text-align-justify\"><strong>Oracle Solaris on SPARC (64\u2013bit)<\/strong>\u00ae<strong> IA64<\/strong><\/li>\n<li class=\"text-align-justify\"><strong>Oracle Solaris X64<\/strong><\/li>\n<li class=\"text-align-justify\"><strong>ZLinux-64<\/strong><\/li>\n<li class=\"text-align-justify\"><strong>AIX (PPC64)<\/strong><\/li>\n<li class=\"text-align-justify\"><strong>HP-UX<\/strong><\/li>\n<\/ul>\n<p><strong>Note: <\/strong>OBS does not support HP-UX PA-RISC 64\u2013bit.<\/p>\n<p><strong>Install Oracle 12cR2<\/strong><\/p>\n<p>Use the following steps to install Oracle 12cR2:<\/p>\n<p>1) Create the <strong>wallet<\/strong>&nbsp;directory to store the AWS access keys and secret access key or IAM role.<\/p>\n<p>2) Unzip the &nbsp;<strong>osbws_installer.zip<\/strong> file that you downloaded from the link&nbsp;provided in the <em>Requirements<\/em>&nbsp;section.<\/p>\n<p>3) Install the OSB cloud module for Amazon S3 into your <strong>ORACLE_HOME<\/strong>&nbsp;directory by running the following commands, and substituting the appropriate details for your environment:<\/p>\n<p>For Microsoft Windows:<\/p>\n<p><em>&nbsp; &nbsp; &nbsp;set ORACLE_HOME=C:\\oracle\\product\\12.2.0\\Oracle12cR2<br \/>\n&nbsp; &nbsp; &nbsp;set ORACLE_SID=TEST<\/em><\/p>\n<p>For Linux:<\/p>\n<p><em>&nbsp; &nbsp; export ORACLE_HOME=C:\\oracle\\product\\12.2.0\\Oracle12cR2<br \/>\n&nbsp; &nbsp; export ORACLE_SID=TEST<\/em><\/p>\n<p><em>&nbsp; &nbsp; $ java -jar osbws_install.jar -AWSID XxXxX -AWSKey XxXxX -walletDir<br \/>\n&nbsp; &nbsp; $ORACLE_HOME\/osbws_wallet -libDir $ORACLE_HOME\/lib -location eu-west-2<br \/>\n&nbsp; &nbsp; -awsEndPoint s3-eu-west-2.amazonaws.com -otnUser mmahajan@test.com -otnPass xxxxx<\/em><\/p>\n<p>\n<em>or<\/em><\/p>\n<p><em>&nbsp; &nbsp; $ java -jar osbws_install.jar -IAMRole xxxxx -walletDir &#8220;$ORACLE_HOME\\osbws_wallet&#8221;<br \/>\n&nbsp; &nbsp; -libDir &#8220;$ORACLE_HOME\\lib&#8221; -otnUser mmahajan@test.com -otnPass xxxx<\/em><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Install OSB by using RMAN<\/strong><\/p>\n<p>The installation process creates a file in <strong>$ORACLE_HOME\/dbs<\/strong>, often named&nbsp;<strong>osb\\&lt;SID&gt;.ora<\/strong>, for allocating the channel command in RMAN. When referencing&nbsp;this file, you should use the full path.<\/p>\n<p>The examples in this post use a sample SID.<\/p>\n<p>The following examples show the parameters of <strong>OSBTEST.ora<\/strong>:<\/p>\n<p>&nbsp; &nbsp; ++++++++++++++++++++++++++++++++++++++++++++++<br \/>\n&nbsp; &nbsp; OSB_WS_HOST=https:\/\/s3.amazonaws.com<br \/>\n&nbsp; &nbsp; OSB_WS_IAM_ROLE=iops-test-dev-ec2-role-policy<br \/>\n&nbsp; &nbsp; OSB_WS_BUCKET=test-ec2-backups<br \/>\n&nbsp; &nbsp; OSB_WS_WALLET=&#8217;location=file:E:\\oracle\\product\\12.2.0\\Oracle12cR2\\osbws_wallet CREDENTIAL_ALIAS=aws-itco_aws&#8217;<br \/>\n&nbsp; &nbsp; +++++++++++++++++++++++++++++++++++++++++++++++<\/p>\n<p>or<\/p>\n<p>&nbsp; &nbsp; ++++++++++++++++++++++++++++++++++++++++++++++<br \/>\n&nbsp; &nbsp; OSB_WS_HOST=https:\/\/s3-eu-west-1.amazonaws.com<br \/>\n&nbsp; &nbsp; OSB_WS_LOCATION=eu-west-1<br \/>\n&nbsp; &nbsp; OSB_WS_BUCKET=test-ec2-backups<br \/>\n&nbsp; &nbsp; OSB_WS_WALLET=&#8217;location=file:E:\\oracle\\product\\12.2.0\\Oracle12cR2\\osbws_wallet CREDENTIAL_ALIAS=aws-itco_aws&#8217;<br \/>\n&nbsp; &nbsp; +++++++++++++++++++++++++++++++++++++++++++++++<\/p>\n<p>The following example takes a backup of <strong>controlfile<\/strong>&nbsp;and <strong>datafile 1<\/strong>&nbsp;after&nbsp;allocating the channel for <em>SBT_TAPE<\/em>:<\/p>\n<p><em>&nbsp; &nbsp; allocate channel c1 device type sbt &nbsp; &nbsp;parms=&#8217;SBT_LIBRARY=E:\\oracle\\product\\12.2.0\\Oracle12cR2\\lib\\oraosbws.dll,SBT_PARMS=(OSB_WS_PFILE=E:\\oracle\\product\\12.2.0\\Oracle12cR2\\database\\osbwsSDMS.ora)&#8217;;<\/em><\/p>\n<p><em>&nbsp; &nbsp; D:\\OSB&gt;rman target \/<\/em><\/p>\n<p><em>&nbsp; &nbsp; Recovery Manager: Release 12.2.0.1.0 &#8211; Production on Thu Dec 17 13:38:07 2019<br \/>\n&nbsp; &nbsp; Copyright (c) 1982, 2017, Oracle and\/or its affiliates. All rights reserved.<br \/>\n&nbsp; &nbsp; connected to target database: TEST (DBID=2717091126)<\/em><\/p>\n<p>&nbsp;<\/p>\n<p><em>&nbsp;RMAN&gt; run<br \/>\n&nbsp; &nbsp; 2&gt; {<br \/>\n&nbsp; &nbsp; 3&gt; allocate channel c1 device type sbt &nbsp; &nbsp; parms=&#8217;SBT_LIBRARY=E:\\oracle\\product\\12.2.0\\Oracle12cR2\\lib\\oraosbws.dll,SBT_PARMS=(OSB_WS_PFILE=E:\\oracle\\product\\12.2.0\\Oracle12cR2\\database\\osbwsSDMS.ora)&#8217;;<br \/>\n&nbsp; &nbsp; 4&gt; backup current controlfile;<br \/>\n&nbsp; &nbsp; 5&gt; }<\/em><\/p>\n<p><em>&nbsp; &nbsp; allocated channel: c1<br \/>\n&nbsp; &nbsp; channel c1: SID=50 device type=SBT_TAPE<br \/>\n&nbsp; &nbsp; channel c1: Oracle Secure Backup Web Services Library VER=3.17.4.21<\/em><\/p>\n<p><em>&nbsp; &nbsp; Starting backup at 17-DEC-19<br \/>\n&nbsp; &nbsp; channel c1: starting full datafile backup set<br \/>\n&nbsp; &nbsp; channel c1: specifying datafile(s) in backup set<br \/>\n&nbsp; &nbsp; including current control file in backup set<br \/>\n&nbsp; &nbsp; channel c1: starting piece 1 at 17-DEC-19<br \/>\n&nbsp; &nbsp; channel c1: finished piece 1 at 17-DEC-19<br \/>\n&nbsp; &nbsp; piece handle=3iujli8o_1_1 tag=TAG20191217T144544 comment=API &nbsp; &nbsp; Version 2.0,MMS Version 3.17.4.21<br \/>\n&nbsp; &nbsp; channel c1: backup set complete, elapsed time: 00:00:07<br \/>\n&nbsp; &nbsp; Finished backup at 17-DEC-19<\/em><\/p>\n<p><em>&nbsp; &nbsp; Starting Control File and SPFILE Autobackup on 17-DEC-19<br \/>\n&nbsp; &nbsp; piece handle=c-2467059049-20191217-00 comment=API Version 2.0,MMS Version 3.17.4.21<br \/>\n&nbsp; &nbsp; Finished Control File and SPFILE Autobackup on 17-DEC-19<br \/>\n&nbsp; &nbsp; released channel: c1<\/em><\/p>\n<p><em>&nbsp; &nbsp; RMAN&gt; run<br \/>\n&nbsp; &nbsp; 2&gt; {<br \/>\n&nbsp; &nbsp; 3&gt; allocate channel c1 device type sbt parms=&#8217;SBT_LIBRARY=E:\\oracle\\product\\12.2.0\\Oracle12cR2\\lib\\oraosbws.dll,SBT_PARMS=(OSB_WS_PFILE=E:\\oracle\\product\\12.2.0\\Oracle12cR2\\database\\osbwsSDMS.ora)&#8217;;<br \/>\n&nbsp; &nbsp; 4&gt; backup datafile 1;<br \/>\n&nbsp; &nbsp; 5&gt; }<\/em><\/p>\n<p><em>&nbsp; &nbsp; allocated channel: c1<br \/>\n&nbsp; &nbsp; channel c1: SID=50 device type=SBT_TAPE<br \/>\n&nbsp; &nbsp; channel c1: Oracle Secure Backup Web Services Library VER=3.17.4.21<\/em><\/p>\n<p><em>&nbsp; &nbsp; Starting backup on 17-DEC-19<br \/>\n&nbsp; &nbsp; channel c1: starting full datafile backup set<br \/>\n&nbsp; &nbsp; channel c1: specifying datafile(s) in backup set<br \/>\n&nbsp; &nbsp; input datafile file number=00001 &nbsp; &nbsp; &nbsp; &nbsp; name=F:\\ORADATA\\SDMS\\SYSTEM01.DBF<br \/>\n&nbsp; &nbsp; channel c1: starting piece 1 on 17-DEC-19<br \/>\n&nbsp; &nbsp; channel c1: finished piece 1 at 17-DEC-19<br \/>\n&nbsp; &nbsp; piece handle=3kujlia1_1_1 tag=TAG20191217T144625 comment=API &nbsp; &nbsp; Version 2.0,MMS Version 3.17.4.21<br \/>\n&nbsp; &nbsp; channel c1: backup set complete, elapsed time: 00:03:15<br \/>\n&nbsp; &nbsp; Finished backup on 17-DEC-19<\/em><\/p>\n<p><em>&nbsp; &nbsp; Starting Control File and SPFILE Autobackup on 17-DEC-19<br \/>\n&nbsp; &nbsp; piece handle=c-2467059049-20191217-01 comment=API Version &nbsp; &nbsp;2.0,MMS Version 3.17.4.21<br \/>\n&nbsp; &nbsp; Finished Control File and SPFILE Autobackup on 17-DEC-19<br \/>\n&nbsp; &nbsp; released channel: c1<\/em><br \/>\n&nbsp;<\/p>\n<p><strong>List of the backup sets<\/strong><\/p>\n<p>Run the following commands to get a list of the backup sets for the <strong>controlfile<\/strong>&nbsp;and <strong>datafile 1<\/strong>:<\/p>\n<p>&nbsp;RMAN&gt; list backup of controlfile;<\/p>\n<p>&nbsp; &nbsp; BS Key Type LV Size &nbsp; &nbsp; &nbsp;Device Type Elapsed Time Completion Time<br \/>\n&nbsp; &nbsp; &#8212;&#8212;- &#8212;- &#8212; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n&nbsp; &nbsp; 113 &nbsp; &nbsp;Full &nbsp; 18.75M &nbsp; &nbsp;SBT_TAPE &nbsp; 00:00:01 &nbsp; &nbsp;17-DEC-19<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp;BP Key: 113 &nbsp;Status: AVAILABLE Compressed: NO Tag: &nbsp; &nbsp; TAG20191217T144940<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp;Handle: c-2467059049-20191217-01 &nbsp;Media: &nbsp; &nbsp;s3.amazonaws.com\/sdms-ec2-backups<br \/>\n&nbsp; &nbsp; &nbsp;Control File Included: Ckp SCN: 64476065 &nbsp; &nbsp;Ckp time: 17-DEC-19<\/p>\n<p>&nbsp; &nbsp; RMAN&gt; list backup of datafile 1;<\/p>\n<p>&nbsp; &nbsp; BS Key Type LV Size &nbsp; &nbsp; &nbsp;Device Type Elapsed Time Completion Time<br \/>\n&nbsp; &nbsp; &#8212;&#8212;- &#8212;- &#8212; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n&nbsp; &nbsp; 112 &nbsp; &nbsp;Full &nbsp; 733.25M &nbsp; SBT_TAPE &nbsp; 00:02:46 &nbsp; &nbsp;17-DEC-19<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp;BP Key: 112 &nbsp;Status: AVAILABLE Compressed: NO Tag: &nbsp; &nbsp;TAG20191217T144625<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp;Handle: 3kujlia1_1_1 &nbsp;Media: s3.amazonaws.com\/sdms-ec2-backups<\/p>\n<p>List of datafiles in backup set 112:<\/p>\n<p>&nbsp; &nbsp; &nbsp;File LV Type Ckp SCN &nbsp; Ckp Time Abs Fuz SCN Sparse Name<br \/>\n&nbsp; &nbsp; &nbsp;&#8212;- &#8212; &#8212;- &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212; &#8212;-<br \/>\n&nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp;Full 64474680 &nbsp;17-DEC-19 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NO &nbsp; &nbsp; &nbsp; F:\\ORADATA\\SDMS\\SYSTEM01.DBF<\/p>\n<p><strong>Possible installation error<\/strong><\/p>\n<p>During the backup, you might get an **ORA-03113** error, with the following<br \/>\nMetalink note 2396267.1 to help resolve the issue:<\/p>\n<p>&nbsp; &nbsp; PSDRPC returns significant error 3113.<br \/>\n&nbsp; &nbsp; RMAN-00571: ===========================================================<br \/>\n&nbsp; &nbsp; RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br \/>\n&nbsp; &nbsp; RMAN-00571: ===========================================================<br \/>\n&nbsp; &nbsp; RMAN-03009: failure of allocate command on c1 channel at 12\/16\/2019 15:49:58<br \/>\n&nbsp; &nbsp; ORA-03113: end-of-file on communication channel<\/p>\n<p>The following error is reported in the alert log:<\/p>\n<p><em>&nbsp; &nbsp; ORA-07445: exception encountered: core dump [PC:0x7FEDDB54FBC] [ACCESS_VIOLATION] [ADDR:0x0] [PC:0x7FEDDB54FBC] [UNABLE_TO_READ] []<br \/>\n&nbsp; &nbsp; Incident details in: &lt;path&gt;\\incident\\incdir_249332\\&lt;oracle_sid&gt;_ora_30776_i249332.trc<br \/>\n&nbsp; &nbsp; Use ADRCI or Support Workbench to package the incident.<br \/>\n&nbsp; &nbsp; See Note 411.1 at My Oracle Support for error and packaging details.<br \/>\n&nbsp; &nbsp; Fri Apr 13 10:01:59 2018<br \/>\n&nbsp; &nbsp; Dumping diagnostic data in directory=[cdmp_20180413100159], requested by (instance=1, osid=30776), summary=[incident=249332].<\/em><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Error cause<\/strong><\/p>\n<p>The installation error occurs because the running database service locks the&nbsp;Serial Backup Tape (SBT) library.<\/p>\n<p>To solve this, perform the following steps:<\/p>\n<ol>\n<li>Shut down the database.<\/li>\n<li>Reinstall the Oracle Cloud Backup module by using the steps given previously.<br \/>\n\t&nbsp;<\/li>\n<\/ol>\n<p><strong>Conclusion<\/strong><\/p>\n<p>The blog describes the steps to take an RMAN database backup on Amazon S3. The&nbsp;OSB cloud module backups stored on Amazon S3 storage are always accessible. The&nbsp;availability of cloud storage services and the access model help your organization streamline recovery operations. For instance, you don&#8217;t need to&nbsp;ship or load tapes before you perform a restore operation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can backup Oracle\u00ae databases in Amazon\u00ae Web Services (AWS) starting with Oracle Database 9i Release 2 or later. You use the Oracle Secure Backup (OSB) cloud module to do the backup, but remember that OSB does not back up operating system files.<\/p>\n","protected":false},"author":2,"featured_media":7403,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26410","content_type":"blog","created_by":"10130","authored_on":"2023-12-21T12:39:53+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Rackspace Technology Staff","seo_description":"Comprehensive guide to memory tuning for Oracle databases. Boost performance and troubleshoot common issues.\r\n","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26410-insights_image-aws-technical-blog-1-insights.png","field_partners":"","rxt_platforms":"Oracle, Amazon Web Services (AWS)","product":"","publisheddate":"2020-02-05T12:39:53","rxt_solutions":"Multicloud","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"Oracle Secure Backup in AWS | Rackspace Technology","field_topics":"","field_slug":"introduction-to-oracle-secure-backup-in-aws","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-7401","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/comments?post=7401"}],"version-history":[{"count":3,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7401\/revisions"}],"predecessor-version":[{"id":9436,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7401\/revisions\/9436"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media\/7403"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media?parent=7401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/categories?post=7401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/tags?post=7401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}