{"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_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-1905","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\/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}]}}