Oracle 23c: Managing Flashback Database Logs Outside the Fast Recovery Area
Overview: In previous Database releases, you could store flashback database logs only in the fast recovery area Oracle 23c Database introduces the ... Read More
Learn more about why Eclipsys has been certified as a Great Place to Work in Canada, Best Workplaces in Ontario and Technology, and named Canada’s Top SME Employer for 3 years!
Learn more!In this blog, I’ll demonstrate the steps to scale up the usable Exadata storage using the OCI console.
1. Note the current total size and free size by running “asmcmd lsdg” command on any node of the VM cluster.
2. Sign in to your OCI tenancy where your Exadata Database Service on Cloud @ Customer system is deployed
3. Navigate to “Oracle Database” > “Oracle Exadata Database Service on Cloud@Customer” > “Exadata VM Clusters“
4. Click on your VM Cluster Name
5. On the VM cluster details home page, click the “Scale VM Resources” button.
6. On the “Scale VM Cluster” screen, under the “Configure the Exadata storage” section, specify the usable Exadata storage new size then click the “Save Changes” button. The new size will be distributed based on the DATA: RECO ratio, which is 80:20 in our example.
The cluster state will switch to “UPDATING”, but all resources will be UP on both nodes.
You can track scaling progress and activities from the “Work Requests” page under the Resources section in the VM cluster details home page.
Once scaling is completed, the cluster’s state will be changed back to “AVAILABLE”. Under the “Resource allocation” section, Exadata Storage (TB) will show the new total usable storage.
7. Connect to any of the VM clusters and run “asmcmd lsdg” command to check the ASM disk groups’ new size.
Overview: In previous Database releases, you could store flashback database logs only in the fast recovery area Oracle 23c Database introduces the ... Read More
Overview: Oracle 23c Database introduces a new feature to control whether a user or session is enabled for read-write operations, irrespective of the ... Read More