AIM

DBCS Lift Shift

Procedure

Author: Karthik Sardarsingh

Creation Date: July 12, 2021

Last Updated: July 13, 2021

Document Ref: Nil

Version: V1

Install Oracle Database – On-premise

Download and Unzip the required 11.2.0.4 Database software in the location where you want to install.

Navigate to database folder and invoke “runInstaller” and proceed with the installation.

Note: Ensure all the Pre-requisites like Kernel Settings and RPM’s are done, which is not covered in this document. Ensure to select the Character Set as shown below.

Insert Data into “SCOTT” schema

Please refer sample test data here.

Create a OCI user available in “Administrator” group

Click Hamburger menu à Identity & Security à Users à Create User à Provide the username, email, ensure the user is not in Federated group rather user should be in “Administrator” group.

Ensure to create API Keys

Ensure to Note the Auth Token – It will not be displayed again

Ensure the user is having DBAAS Administrator role

Create a Compartment

Click Hamburger menu à Identity & Security à Compartments à Create Compartment à Provide the Name and Select the Parent/root compartment

Create a VCN

Subnets

CIDR Blocks

Route tables

Security Lists

Service Gateways

Create Object Storage/Bucket

Hamburger Menu à Storage à Buckets à Create Bucket à Provide Bucket name under the compartment

Create Pre-Authenticated request

Install OCI Backup module

RMAN Configuration

RMAN> configure controlfile autobackup on;

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters are successfully stored

RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt PARMS='SBT_LIBRARY=/u01/app/oracle/product/11.2.0.4/db_1/lib/libopc.so,SBT_PARMS=(OPC_PFILE=/u01/app/oracle/product/11.2.0.4/db_1/dbs/opcdbcs.ora)';

RMAN> CONFIGURE COMPRESSION ALGORITHM 'MEDIUM';

new RMAN configuration parameters:

CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

new RMAN configuration parameters are successfully stored

RMAN> CONFIGURE DEVICE TYPE sbt BACKUP TYPE TO COMPRESSED BACKUPSET;

The below encrypted password should be provided during Instance creation