{"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":"

12 Days of #Cloud: Day 10<\/h2>\n

In a previous post, I talked about enabling 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>\n

From the dashboard, choose Storage Cloud Service.\u00a0And note down the REST Endpoint URL.<\/p>\n

\"\"<\/p>\n

The page also shows the data center. Mine is us2<\/span>. Go to the Storage Console to create a new storage container to store the backups. The storage console URL is\u00a0https:\/\/storageconsole.us2<\/span>.oraclecloud.com where you need to substitute the correct data center instead of us2<\/span>. Thanks to Gokhan for the help<\/a><\/em>.<\/p>\n

Login prompt appears:<\/p>\n

\"\"<\/p>\n

Input the Storage Cloud REST Endpoint URL and your Cloud account username\/password to get to the Storage Console. Choose “Create Container”<\/p>\n

\"\"<\/p>\n

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>\n

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:\/\/<identity-domain><\/span>.storage.oraclecloud.com\/v1\/Storage-<identity-domain><\/span>\/<backup-container><\/span><\/p>\n

If\u00a0the backup container is in the same identify domain as your database, then the URL may be shortened to Storage-<identity-domain><\/span>\/<backup-container>\u00a0<\/span>Thanks to Scott Spendolini <\/a>for this info<\/em>.<\/p>\n

Now, to Cloud Database console to create an instance. Everything is pretty similar to the first Instance I created<\/a>, except for the backup configuration.<\/p>\n

\"\"<\/p>\n

Backup destination is “Both Cloud Storage and Local Storage”. The Cloud Storage Container is the REST URL for my Storage Cloud + Container Name. If you check on the “Create Cloud Storage Container”, 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:\/\/usatomtrial<\/span>.storage.oraclecloud.com\/v1\/Storage-usatomtrial<\/span>\/Backup001<\/span>.<\/p>\n

After about a day of running database, I can see using RMAN that the backups are happening successfully.<\/p>\n

\"\"<\/p>\n

Here are the default RMAN configurations.<\/p>\n

\"\"<\/p>\n

Notice
\nCONFIGURE CHANNEL DEVICE TYPE ‘SBT_TAPE’ MAXPIECESIZE 2 G PARMS ‘SBT_LIBRARY=libopc.so, ENV=(OPC_PFILE=\/u01\/ app\/oracle\/product\/12.2.0\/dbhome_1\/dbs\/opcDBBKCL1.ora)’;
\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>\n

Though backups are scheduled, an\u00a0on-demand backup can be performed from the Database Cloud Console.<\/p>\n

\"\"<\/p>\n

You may also initiate a recovery from the Database Cloud Console.<\/p>\n

\"\"<\/p>\n

The options are to recover using the latest backup (full + archivelog backups available), or specified datetime,\u00a0or specified SCN.<\/p>\n

\"\"<\/p>\n

Click Recover, and hopefully, you will have a recovered database without DBA intervention.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

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, … 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_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[55],"class_list":["post-1972","post","type-post","status-publish","format-standard","hentry","category-cloud-autonomous","tag-oracle-cloud"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_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}]}}