Oracle Database Migration to Oracle Cloud; #Lift&Shift, #DatabaseMigration

Overview:

Oracle Cloud is all over the place and has become a mandatory skill set for every DBA. This blog gives an insight into Migrating an OnPrem Oracle Database to Oracle Database Cloud. (Called Lift And Shift)

High Level Steps:

  1. Download and configure RMAN Module
  2. Backup Database to Oracle Cloud
  3. Create a DBCS Instance and Restore DB

Detailed Steps:

Steps 1 & 2 are covered in my other post on “Oracle Database Backup to Oracle Cloud” (https://pradeepvattem.wordpress.com/2018/05/01/oracle-database-backup-to-oracle-cloud-oraclecloud-backuptocloud)

Create a DBCS Instance & Restore DB:

Login to Oracle Cloud “https://cloud.oracle.com” in to your Identity Domain, under Services, Click on “Services” –> Database

cloud20

The Page redirects to “Oracle Database Cloud Service”, Click on “Go to Console”,

cloud21

Click on “Create Instance”,

cloud22

Provide the details of “Instance Name”, Version of Source Database (Which was backed up), Edition & Database Type (Single Instance or Database Clustering with RAC or Single Instance with Data Guard or Data Guard standby for Hybrid DR or Database Clustering with RAC & Data Guard Standby)

cloud23

Click Next and enter the DB Name to be created “ORCL” (is taken as example here), Provide the Administrator Password and mention the size of DB and required space, also select the Compute for running the DB (here, I selected the basic configuration server).

cloud28

Also, provide the Backup & Recovery Configuration. To Clone The new DB from Existing Database (on Prem), provide the “Cloud Storage Container” details and DB ID of OnPrem Database.

You could generate a new SSH keys,

cloud24

Create new keys and download the same.

cloud25

Select the option to “Create Database from Existing Backup”

cloud26

Enter all the details required and click “next”

cloud28

Upon reviewing the summary, click “Create”, which will create the database on Cloud.

cloud29.png

Once the Environment is created, you could connect to the Database.

cloud30.png

Advertisements
This entry was posted in Oracle Cloud. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s