{"id":1905,"date":"2016-12-20T00:01:20","date_gmt":"2016-12-20T06:01:20","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1905"},"modified":"2026-02-07T15:27:13","modified_gmt":"2026-02-07T21:27:13","slug":"12-days-of-cloud-adding-storage-to-dbaas-node","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2016\/1905\/","title":{"rendered":"12 Days of #Cloud: Adding Storage to #DBaaS Node"},"content":{"rendered":"<h2>12 Days of #Cloud: Day 7<\/h2>\n<p>There are three types of storage expansion possible on Oracle #DBaaS instance.<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>1. Increase Default File Systems<\/strong><\/span><\/p>\n<p>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 &#8220;Scale Up \/ Down Service&#8221; and choosing the appropriate file system to extend. Below example shows extending the backup file system.<\/p>\n<p id=\"IRWLXrB\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1906 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5858c5db2da96.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>No other file systems can be increased easily. To increase a storage volume, you need to create a\u00a0new volume, copy contents from old to new, and remove the old.<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>2. Creating New\u00a0Storage Volume<\/strong><\/span><\/p>\n<p>In the above screen (Scale up \/ down Service), you can choose the first option of &#8220;Create New Storage Volume&#8221;. Specify a size in GB and click the confirm (Yes, Scale Up\/Down Service) button.<\/p>\n<p id=\"JvHZefF\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1917 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5858d13b75fae.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>The DBaaS Monitor Console (OS Storage) shows the storage is available on the node.<\/p>\n<p id=\"vJvMvym\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1919 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5859b6e2aa669.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Also, view details in the Oracle Compute Cloud Services, Storage section.<\/p>\n<p id=\"qJxnLLO\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1922 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5859bc8426bc0.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>#DBaaS service assigns the next available device and volume number.<\/p>\n<p id=\"KcaQKrp\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1920 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5859b81a42e48.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>File system is updated in \/etc\/fstab\u00a0as well, so when VM is rebooted, the storage you just added is automatically mounted.<\/p>\n<p id=\"gXUQoNw\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1921 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5859baa9aa052.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Notice that, though we added a new storage volume that has nothing to do with the running database, DBaaS service did take an outage on the environment and rebooted the node.<\/p>\n<p>A note from <a href=\"https:\/\/docs.oracle.com\/en\/cloud\/paas\/database-dbaas-cloud\/csdbi\/scale.html\" target=\"_blank\">Oracle documentation<\/a>: Looks like an unnecessary limitation.<\/p>\n<p id=\"RzkrCrn\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1923 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5859cdf4be156.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p><span style=\"text-decoration: underline;\"><strong>3. Attaching New Storage Volume from Compute Cloud<\/strong><\/span><\/p>\n<p>This is similar to #2, but more manual steps. Used <a href=\"https:\/\/docs.oracle.com\/en\/cloud\/paas\/database-dbaas-cloud\/csdbi\/add-temporary-storage.html#CSDBI-GUID-90E792E1-EC2D-42B4-976E-375485C2A44A\" target=\"_blank\">Oracle documentation<\/a> as a\u00a0reference to do these steps.<\/p>\n<p>Choose Oracle Compute Cloud Service and click on the &#8220;Create Storage Volume&#8221; button.<\/p>\n<p id=\"pWcKPqA\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1907 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5858ca4fa3e38.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Pick a name and size for the storage volume, and the type of storage.<\/p>\n<p id=\"ZrqUfpL\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1908 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5858ca78c8604.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Once the storage volume is created, attach the storage to a DBaaS VM.<\/p>\n<p id=\"mNaPbRY\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1909 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5858caf7d56af.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Choose the instance where the volume need to be attached to.<\/p>\n<p id=\"fPIwczq\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1910 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5858cb26685d8.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Storage is attached to the DBaaS host.<\/p>\n<p id=\"GynCScM\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1911 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5858cb3e82a9c.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>But the storage is not visible on the Linux VM as it is not mounted. Before mounting the storage, there are few steps to complete. The new storage added is \/dev\/xvdg.<\/p>\n<p id=\"wzRXmCT\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1912 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5858cbc0e47e9.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p id=\"oQFpxxS\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1913 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5858cbd382941.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p id=\"IbSjABg\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1914 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5858cbe15439c.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>A note from <a href=\"https:\/\/docs.oracle.com\/en\/cloud\/paas\/database-dbaas-cloud\/csdbi\/add-temporary-storage.html#CSDBI-GUID-90E792E1-EC2D-42B4-976E-375485C2A44A\">Oracle Documentation<\/a>.<\/p>\n<p id=\"kIRkIGN\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1924 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5859cf70620d3.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &#8220;Scale Up \/ Down Service&#8221; &#8230; <a title=\"12 Days of #Cloud: Adding Storage to #DBaaS Node\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2016\/1905\/\" aria-label=\"Read more about 12 Days of #Cloud: Adding Storage to #DBaaS Node\">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-1905","post","type-post","status-publish","format-standard","hentry","category-cloud-autonomous","tag-oracle-cloud"],"acf":[],"jetpack-related-posts":[{"id":1897,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1897\/","url_meta":{"origin":1905,"position":0},"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":[]},{"id":1889,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1889\/","url_meta":{"origin":1905,"position":1},"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":1972,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1972\/","url_meta":{"origin":1905,"position":2},"title":"12 Days of #Cloud: Backup #DBaaS to Cloud Container","author":"Biju","date":"December 29, 2016","format":false,"excerpt":"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\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\/img_58657e609db0d.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2022,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/2022\/","url_meta":{"origin":1905,"position":3},"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":1927,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1927\/","url_meta":{"origin":1905,"position":4},"title":"12 Days of #Cloud: Cloning #DBaaS Instance","author":"Biju","date":"December 22, 2016","format":false,"excerpt":"12 Days of #Cloud: Day 8 It is very easy to stand up a new DBaaS instance as a replica or clone of an existing instance. In this demo, I am going to create a new instance as a copy of CLDB4ACED DBaaS instance. First, need to create a snapshot\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":1905,"position":5},"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":[]}],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1905","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=1905"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1905\/revisions"}],"predecessor-version":[{"id":2990,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1905\/revisions\/2990"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}