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 update the configuration of an existing MySQL DB system to use another MySQL configuration (MyConfig3) from the OCI console
Prerequisites:
Limitations:
1. Sign in to the OCI Console
2. Open the navigation menu and navigate to “Databases -> DB Systems“
3. Choose your compartment. The list of MySQL DB systems is displayed. Click your DB system name
4. In the DB system details page and under the DB system configuration section, click Edit next to the Configuration option
5. In the “Edit DB system” window and under the Configuration section, click the “Change configuration” button
6. In the Browse Configurations window, select MyConfig3 from the list
Note: in my example selecting MyConfig2 is not an option because it attempts to change the initialization variables of the DB system.
7. Once you select the new config, the Edit DB system window will show the name of the new config and a compare configurations table that shows variables compared. Click the “save changes” buttons
8. DB system status will be UPDATING, but the database will NOT restart because all changed variables are dynamic.
9. Once the update finishes, the configuration name will be changed to the new config
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