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
Perform Full RMAN backup and Validate in Cloud
Object Storage Container
Create Instance
Create New Private Keys for the instance and
Ensure to download both Private and Public keys.
Create Instance from Backup
In the below screen choose
·
Backup & Recovery Configuration to “None”
·
Create Database from Existing Backup to “Yes”
·
Check the option “On-Premise” Backup
·
Provide the Cloud Storage Container Name,
Username and AuthToken as password.
Ensure to
provide the DBID of the On-Premise database
In Decryption
Method Either wallet can be zipped and uploaded (or) à Choose Paste RMAN Key à password_1
