Join David Yahalom for an in-depth discussion in this video Advanced database configuration, part of Oracle 12c Release 2 New Features & The Oracle Cloud.
- The final set of options you can configure for your Oracle database in the cloud includes backup properties of your database, as well as some advanced configuration options. Let's start by discussing database backups. As you probably know, it's super important to keep your Oracle databases on a regular backup schedule. You know, just in case. When creating an Oracle database in the Oracle cloud, you can specify where you want your database backups to be stored.
You actually got three options to choose from. One, store the database backups both locally on the database server itself and also on external Oracle cloud storage. It makes sense to have your database backups also stored outside your actual database server so that if something happens to your database server, the backups, you know, the files you will use to recover your database from are still accessible. Oracle uses cloud storage containers to safely store your database backups outside of your database server.
Think of these as external storage volumes. Ones you can easily create and manage. When selecting both cloud storage and local storage as your backup destination, you even have the option to create a new cloud storage container as part of the database creation process. Another option you have is to choose cloud storage only. Choosing this option will not store the database backups both locally and in the cloud storage, but only in cloud storage.
This options can help you save local storage space on your database server but might also add another step when it comes to recover your database as you will probably have to copy the database backup files from the cloud storage container to your local database storage before you will restore your database. The last option is to select none. This configures your database without a backup destination. For the sake of our demo, let's choose this option as it makes things simpler for us to focus on showing the new features of Oracle 12c release II and not spending much time on Oracle database backup configuration.
Of course, and I guess this goes without saying, for production Oracle cloud databases, you should never choose this option and properly configure your Oracle database backups. Oracle will even display a warning message on the webpage if you select none as your backup destination. That is because your database will be configured without a default destination to which backups will be stored. This is risky. After selecting your backup destination, you can choose if you want to create a new database based on a backup of an existing database.
That is restore this database from an existing Oracle database backup. This is great for creating new databases based on existing databases. For our demo, we should choose no as we want to create a brand new Oracle database. Finally, scrolling down, let's expand the advanced setting section. Here, under advanced settings, you can choose your database listener port, timezone, character set, national character set, choose if you want to enable Oracle GoldenGate, which is a real-time data replication technology for Oracle, and choose if you want to deploy the demo PDB as part of the database creation.
Let's keep the default options for now. Once everything is done and configured, we can scroll up and click on the next button. Here, we will be presented with a summary screen presenting all of the configuration options we have specified. By clicking on the create button, we will actually create our database so let's click on create. Note that this process may take a while. After we have clicked on create, we are brought back to the Oracle database cloud service console and scrolling down, we see that we have a newly configured Oracle database called DemoDB with the current status of creating service because the database is still being crated but not ready and an Oracle version of 12 dot two dot zero dot one.
This is Oracle 12c Release II.
- Registering for a new Oracle Cloud free trial account
- Creating an Oracle 12c R2 database in the Oracle Cloud
- Configuring SSH access to the database
- Advanced database configuration
- Connecting to your Oracle Cloud database
- PDB resource management
- PDB cloning
- PDB flashback
- Read-only partitions
- Transforming non-partitioned tables to partitioned tables automatically
- Creating a table for Exchange automatically
- Automatic list partitioning