You can use the Commvault database application migration feature to move your database to the Oracle Database as a Service (DBaaS) cloud.
The Commvault software automates the following processes:
-
Capturing the application server physical configuration.
-
Protecting the application data
-
Creating the Oracle service and the database
-
Provisioning the storage
-
Installing the Commvault Oracle Agent software on the Oracle DBaaS so that you can run backups on the migrated database
-
Restoring the data
-
Validating the restore
About This Task
The following configurations are supported:
-
Oracle 11gR2, Oracle 12CR1, Oracle 12CR2
-
Oracle Standard or Enterprise Editions
-
Single instances
Before You Begin
-
Have the backup administrator configure the firewall for application migration.
-
Have the backup administrator configure the Oracle DBaaS VM lifecycle policy.
Note: Make sure that the backup administrator has the Oracld DBaaS SSH keys.
-
Make sure that you have the following information:
-
The Oracle Service name
-
The URL to the Oracle cloud storage
This is where Oracle stores the database datafiles
-
The Oracle VM lifecycle policy
-
Procedure
-
From the navigation pane, go to Solutions > Databases > DB Instances.
The Instances page appears.
-
On the Instances tab, from the View list next to Instances, select Oracle.
The Instances page for Oracle appears.
-
Click the instance.
The instance page appears.
-
On the upper-right corner of the page, click the menu icon
, and then click Migrate to cloud.
The Migrate to cloud page appears.
-
Specify the cloud destination information.
-
From the Cloud vendor list, select Oracle DBaaS.
-
From the Provisioning Policy list, select the lifecycle policy.
-
In the Service name box, type the Oracle DBaaS name.
The Commvault software creates a new service in the cloud.
-
-
Expand the Service configuration node, and then specify the service configuration.
-
From the Metering frequency list, select when the payment option, for example monthly.
-
From the Software release list, select the Oracle version.
-
From the Software edition list, select the Oracle edition.
-
From the Database type list, select Single instance.
The software creates the Oracle instance with the selected options.
-
-
Expand the Node configuration node, and then specify the database configuration.
-
In the Database name box, type the database name.
The database name can be the same as or different from the source database name.
-
In the SYS password box, type the password for the Oracle database.
-
In the Usable database storage box, type amount of storage that the database uses. You can enter a value between 15GB and 2048GB.
-
From the Compute shape list, select the database computing power.
-
In the Listener port box, type listener port number.
-
The Commvault software automatically configures a JSON rule that defines what hosts can access the database. To modify the rule,in the Access rule JSON box, type the new commands.
-
-
Specify the backup options.
-
From the Backup service list, select the backup service.
-
If you select Cloud storage only, then in the Cloud storage container box, type the URL to the Oracle cloud storage.
-
-
Expand the Firewall configuration node, and then specify the firewall options.
-
If the Oracle server cannot communicate with Commvault, then make the following selections:
-
Select the There is a firewall between the client machine check box.
-
Select CommServe can open a connection towards client machines.
-
Best Practice: In the CommServe HTTP/HTTPS tunnel port box, type 443 because it is the HTTPS port.
-
-
If the Oracle DBaaS has a proxy server, then make the following selections:
-
Select the There is a firewall between the client machine check box.
-
Select CommServe is reachable only through a proxy.
-
From the Proxy client list, select the Oracle Proxy client
-
-
-
Expand the Migration options node, and then specify the migration options.
-
From the Migrate using list, select the vendor that performs the backup.
Best Practice: Select Commvault so that you can take advantage of features such as data aging and scheduling.
If you want to use the Oracle backup as a service option, then verify The Oracle requirements. For more information, see Oracle Database Backup.
-
In the Migration area, select whether this operation is a one-time operation, or continuous.
-
To have this be a one-time operation, select One time.
-
To have this a continuous operation that uses the Live Sync feature, select Run a new full backup.
-
-
In the Baseline area, select the backup to use for migration
-
To use the latest full backup, select Use most recent full backup.
-
To run a new backup for the Live Sync operation, select Run a new full backup.
-
-
To have the destination database come up in standby mode, select the Restore Destination in Standby Mode check box.
-
In the Number of Streams box, type the number of streams that the software will use for the replication operation.
-
In the Post migration validation script box, type the full path and script name for the script that you use to validate the Oracle database.
-
-
Click Submit.
Result
The Commvault software creates the service and database, and then migrates the database and application.
There are 2 jobs for the migration, a VM provisioning job and a backup job.
What to Do Next
You can control or view the job. For more information, see Jobs.
Note: If the destination Oracle SID has a different value from the source Oracle SID (because you are performing a cross-instance migration), then perform the following steps when the job goes to a PENDING state.
-
Log on to the DBaaS instance.
-
Shut down the database, and then take a backup of the existing init file.
-
Set the db_name parameter in the init file to the source instance name.
-
Set the db_unique_name parameter in the init file to the new target database instance name.
-
Continue the restore, and then open the database with the resetlogs option.
-
Use the Oracle NID utility to rename the database.