TDE encryption setup for migrating on-premise backup to Oracle cloud using RMAN

This note describe how we can configure TDE encryption for RMAN backup in on-premise database to migrate to Oracle cloud. 1.First I need to update sqlnet.ora with proper location where my wallet will reside to enable TDE encryption. # sqlnet.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/sqlnet.ora # Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) ENCRYPTION_WALLET_LOCATION= (SOURCE= (METHOD=FILE) (METHOD_DATA= (DIRECTORY=/var/opt/oracle/hdg/tde_wallet) ) […]

Backup on-premise database and restore to Oracle cloud database

My on-premise database hostname:-gnssrv01 Database name:-orcl12c Cloud database hostname:-myclone A.Backup of on-premise database to cloud container Please create the empty container for holding backup of on-premise database using following link https://clouddba.co/oracle-dbaas-1z0-160-part-24-backup-in-single-instance-oracle-cloud/ 1.First I need to install backup module for cloud in on-premise database You need to download opc.cert and opc_install.jar mentioned in above metalink note (Doc ID 2360941.1) [oracle@myclone ~]$ […]

Oracle DBaaS 1z0-160 part 31 :- Oracle cloud database security

Data security In Oracle Database Cloud Service databases, data security is provided for data in transit and data at  rest. Security of data in transit is achieved through network encryption. Data at rest security is achieved through encryption of data stored in database data files and backups.Data in Oracle Database files, including backups, is secured by the use of encryption […]

Oracle DBaaS 1z0-160 part 28:- Backup and recovery in RAC in oracle cloud

Backup and Recovery from DB Console You may face problem in taking backup to oracle container for oracle cloud RAC. Please follow below link to troubleshoot. https://clouddba.co/kbhs-00712-ora-29024-received-from-local-http-service-during-backup-in-rac-oracle-cloud/ Once you have resolved the issue,You can proceed with backup Please proceed to take backup Backup log location You can find backup of RMAN log for oracle cloud in following location:- [oracle@pocracdemo1 ~]$ […]

Oracle DBaaS 1z0-160 part 26 :- Install RAC from console in oracle database cloud

Please select create instance after selecting “Database” option Please select one of following options(I choose custom) Please select the option to create RAC Please provide SSH public key or create new key SSH key will be generated now Please provide other relevant information The instance will be now creating and will take 2-3 hours After installation you will get following […]

Oracle DBaaS 1z0-160 part 25 :- Recover database in oracle database cloud

1.Recover database from console 2.Please select among below options 3.Please check the recovery progress now 4.Point in time recovery using PITR [root@MYTST ORCL]#  dbaascli orec –args -list [root@MYTST ORCL]#  dbaascli orec –args -pitr TAG20180409T051640 DBAAS CLI version 1.0.0 Executing command orec –args -pitr TAG20180409T051640 –args : -pitr TAG20180409T051640 OREC version: 16.0.0.0 Starting OREC Logfile is /var/opt/oracle/log/ORCL/orec/orec_2018-04-09_12:39:36.log Config file is /var/opt/oracle/orec/orec.cfg […]

Oracle DBaaS 1z0-160 part 24 :- Backup in single instance oracle cloud

Backup types When you create a database deployment, you choose one of the following backup destinations: Both Cloud Storage and Local Storage. Backups are configured to be created automatically and stored both on local compute node storage and on an Oracle Storage Cloud Service container. Cloud Storage Only. Backups are configured to be created automatically and stored on an Oracle […]