{"id":1972,"date":"2016-12-29T23:10:37","date_gmt":"2016-12-30T05:10:37","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1972"},"modified":"2026-02-07T15:27:12","modified_gmt":"2026-02-07T21:27:12","slug":"12-days-of-cloud-backup-dbaas-to-cloud-container","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2016\/1972\/","title":{"rendered":"12 Days of #Cloud: Backup #DBaaS to Cloud Container"},"content":{"rendered":"<h2>12 Days of #Cloud: Day 10<\/h2>\n<p>In a previous post, I talked about enabling <a href=\"https:\/\/bijoos.com\/oraclenotes\/2016\/1889\" target=\"_blank\">backups on a #DBaaS instance <\/a>where backups were disabled when the instance was created. Today I show you how to create a database with Cloud Backup enabled at the time of creating the instance. To store backups on the Oracle Cloud, we need to first create a storage container.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-1974  alignright\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_58657e609db0d.png?resize=296%2C51&#038;ssl=1\" alt=\"\" width=\"296\" height=\"51\" \/><\/p>\n<p>From the dashboard, choose Storage Cloud Service.\u00a0And note down the REST Endpoint URL.<\/p>\n<p id=\"xZauBBB\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-1975  alignright\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_586585f308d18.png?resize=203%2C30&#038;ssl=1\" alt=\"\" width=\"203\" height=\"30\" \/><\/p>\n<p>The page also shows the data center. Mine is <span style=\"color: #ff0000;\">us2<\/span>. Go to the Storage Console to create a new storage container to store the backups. The storage console URL is\u00a0https:\/\/storageconsole.<span style=\"color: #ff0000;\">us2<\/span>.oraclecloud.com where you need to substitute the correct data center instead of <span style=\"color: #ff0000;\">us2<\/span>. <em>Thanks to<a href=\"https:\/\/community.oracle.com\/thread\/4003029\" target=\"_blank\"> Gokhan for the help<\/a><\/em>.<\/p>\n<p>Login prompt appears:<\/p>\n<p id=\"iTKzJAv\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-1976  aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5865873cea1bd.png?resize=434%2C324&#038;ssl=1\" alt=\"\" width=\"434\" height=\"324\" \/><\/p>\n<p>Input the Storage Cloud REST Endpoint URL and your Cloud account username\/password to get to the Storage Console. Choose &#8220;Create Container&#8221;<\/p>\n<p id=\"cUOJiZx\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-1977  aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5865885ba5da7.png?resize=478%2C182&#038;ssl=1\" alt=\"\" width=\"478\" height=\"182\" \/><\/p>\n<p>For regular backups and file storage needs, choose Standard. For archive backups, choose Archive.\u00a0Archive Storage Service is ideally suited for infrequently accessed large-scale data sets.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-1978  alignright\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_586589884ea60.png?resize=347%2C216&#038;ssl=1\" alt=\"\" width=\"347\" height=\"216\" \/><\/p>\n<p>I created two containers. When using these containers for backup or for storage, Oracle DBaaS expects a URL that includes the domain name and container name. The format of \u00a0the URL is https:\/\/<span style=\"color: #ff0000;\">&lt;identity-domain&gt;<\/span>.storage.oraclecloud.com\/v1\/Storage-<span style=\"color: #ff0000;\">&lt;identity-domain&gt;<\/span>\/<span style=\"color: #ff0000;\">&lt;backup-container&gt;<\/span><\/p>\n<p>If\u00a0the backup container is in the same identify domain as your database, then the URL may be shortened to Storage-<span style=\"color: #ff0000;\">&lt;identity-domain&gt;<\/span>\/<span style=\"color: #ff0000;\">&lt;backup-container&gt;\u00a0<\/span><em>Thanks to <a href=\"https:\/\/twitter.com\/btspendo\" target=\"_blank\">Scott Spendolini <\/a>for this info<\/em>.<\/p>\n<p>Now, to Cloud Database console to create an instance. Everything is pretty similar to the <a href=\"https:\/\/bijoos.com\/oraclenotes\/2016\/1782\" target=\"_blank\">first Instance I created<\/a>, except for the backup configuration.<\/p>\n<p id=\"KJpvYUq\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"size-full wp-image-1981  aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5865a26b596e2.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Backup destination is &#8220;Both Cloud Storage and Local Storage&#8221;. The Cloud Storage Container is the REST URL for my Storage Cloud + Container Name. If you check on the &#8220;Create Cloud Storage Container&#8221;, you can specify the name of a non-existing storage container. I provided the name of an existing container (Backup001) and my domain name is usatomtrial. The Complete URL is\u00a0https:\/\/<span style=\"color: #ff0000;\">usatomtrial<\/span>.storage.oraclecloud.com\/v1\/Storage-<span style=\"color: #ff0000;\">usatomtrial<\/span>\/<span style=\"color: #ff0000;\">Backup001<\/span>.<\/p>\n<p>After about a day of running database, I can see using RMAN that the backups are happening successfully.<\/p>\n<p id=\"pnhwsPn\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1982 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5865ab351cc8b.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Here are the default RMAN configurations.<\/p>\n<p id=\"iJbullZ\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1984 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5865aba2dc62b.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Notice<br \/>\nCONFIGURE CHANNEL DEVICE TYPE &#8216;SBT_TAPE&#8217; MAXPIECESIZE 2 G PARMS &#8216;SBT_LIBRARY=libopc.so, ENV=(OPC_PFILE=\/u01\/ app\/oracle\/product\/12.2.0\/dbhome_1\/dbs\/opcDBBKCL1.ora)&#8217;;<br \/>\nThe backups are scheduled through root cron. Database backup is scheduled once a day, and archive log backups are done every 30 minutes. You may adjust the frequency\u00a0if needed.<\/p>\n<p id=\"NKmNHXT\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1985 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5865adeb99e76.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Though backups are scheduled, an\u00a0on-demand backup can be performed from the Database Cloud Console.<\/p>\n<p id=\"rAEmiMw\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1986 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5865b57a15a1e.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>You may also initiate a recovery from the Database Cloud Console.<\/p>\n<p id=\"WTFfHSY\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1987 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5865b5f42e8cf.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>The options are to recover using the latest backup (full + archivelog backups available), or specified datetime,\u00a0or specified SCN.<\/p>\n<p id=\"nLMovVz\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1989 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5865eb5f1e5f0.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Click Recover, and hopefully, you will have a recovered database without DBA intervention.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>12 Days of #Cloud: Day 10 In a previous post, I talked about enabling backups on a #DBaaS instance where backups were disabled when the instance was created. Today I show you how to create a database with Cloud Backup enabled at the time of creating the instance. To store backups on the Oracle Cloud, &#8230; <a title=\"12 Days of #Cloud: Backup #DBaaS to Cloud Container\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2016\/1972\/\" aria-label=\"Read more about 12 Days of #Cloud: Backup #DBaaS to Cloud Container\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[4],"tags":[55],"class_list":["post-1972","post","type-post","status-publish","format-standard","hentry","category-cloud-autonomous","tag-oracle-cloud"],"acf":[],"jetpack-related-posts":[{"id":2022,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/2022\/","url_meta":{"origin":1972,"position":0},"title":"12th Day of #Cloud: Thoughts","author":"Biju","date":"December 31, 2016","format":false,"excerpt":"12 Days of #Cloud: Day 12 After playing with Oracle Database Cloud Service (DBaaS) for past several days, I have mixed feeling. I like quite a lot of features and the amount of automation went into the product. For example, creating an RAC instance and creating a Data Guard instance\u2026","rel":"","context":"In &quot;Cloud &amp; Autonomous Database&quot;","block_context":{"text":"Cloud &amp; Autonomous Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/cloud-autonomous\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1879,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1879\/","url_meta":{"origin":1972,"position":1},"title":"12 Days of #Cloud: PDB Management Using #DBaaS Monitor Console","author":"Biju","date":"December 17, 2016","format":false,"excerpt":"12 Days of #Cloud: Day 4 DBaaS Monitor Console is part of the Oracle Database Cloud Service.\u00a0DBaaS Monitor Console provides information on the\u00a0database and operating system status and resource usage. If you are managing the database with Oracle Enterprise Manager Cloud Control or if you are familiar with Linux commands,\u2026","rel":"","context":"In &quot;Cloud &amp; Autonomous Database&quot;","block_context":{"text":"Cloud &amp; Autonomous Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/cloud-autonomous\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/image22.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1742,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1742\/","url_meta":{"origin":1972,"position":2},"title":"Oracle Tidbits &#8211; August 2016","author":"Biju","date":"September 4, 2016","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published at\u00a0https:\/\/www.facebook.com\/oraclenotes\u00a0on weekdays\u00a0in August\u00a02016. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well\u2026 Hope you find these helpful to learn something new or to remind you of its existence and use\u2026\u2026","rel":"","context":"In &quot;TidBits &amp; Quick Tips&quot;","block_context":{"text":"TidBits &amp; Quick Tips","link":"https:\/\/bijoos.com\/oraclenotes\/category\/tidbits\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1889,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1889\/","url_meta":{"origin":1972,"position":3},"title":"12 Days of #Cloud: Enabling #DBaaS Backups","author":"Biju","date":"December 19, 2016","format":false,"excerpt":"12 Days of #Cloud: Day 6 When I created the #DBaaS instance, did not create a backup policy. I chose the backups as \"None\". Now that some work has been done on the database, would like to create an adhoc\u00a0backup as well as want to schedule regular local disk backups.\u2026","rel":"","context":"In &quot;Cloud &amp; Autonomous Database&quot;","block_context":{"text":"Cloud &amp; Autonomous Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/cloud-autonomous\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1905,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1905\/","url_meta":{"origin":1972,"position":4},"title":"12 Days of #Cloud: Adding Storage to #DBaaS Node","author":"Biju","date":"December 20, 2016","format":false,"excerpt":"12 Days of #Cloud: Day 7 There are three types of storage expansion possible on Oracle #DBaaS instance. 1. Increase Default File Systems Increasing the default file systems that hold data files (\/u02), FRA and backup (\/u03) is easy. \u00a0These file systems can be increased by using the menu item\u2026","rel":"","context":"In &quot;Cloud &amp; Autonomous Database&quot;","block_context":{"text":"Cloud &amp; Autonomous Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/cloud-autonomous\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1897,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1897\/","url_meta":{"origin":1972,"position":5},"title":"12 Days of #Cloud: Exploring #DBaaS File System","author":"Biju","date":"December 18, 2016","format":false,"excerpt":"12 Days of #Cloud: Day 5 When you create a new Cloud DBaaS instance, Oracle Cloud Service provision a VM and required file systems. These are the file systems: \u00a0 [oracle@CLDB4ACED ~]$ df -h Filesystem Size Used Avail Use% Mounted on \/dev\/xvdb3 25G 14G 11G 57% \/ tmpfs 7.3G 0\u2026","rel":"","context":"In &quot;Cloud &amp; Autonomous Database&quot;","block_context":{"text":"Cloud &amp; Autonomous Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/cloud-autonomous\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/image22.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1972","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=1972"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1972\/revisions"}],"predecessor-version":[{"id":2986,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1972\/revisions\/2986"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1972"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1972"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1972"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}