OCI Oracle DB Cloud Backup module

Dear All,

In this post i am sharing Oracle cloud Backup Module.

Setup on the On-Prem Machine

 # Create a new RSA Key

-bash-4.2$ java -jar oci_install.jar -newrsakeypair -walletDir

$ORACLE_HOME/dbs/opc_wallet

Oracle Database Cloud Backup Module Install Tool, build 19.3.0.0.0DBBKPCSBP_2019-10-16

OCI API signing keys are created:

PRIVATE KEY --> /opt/oracle/product/18c/dbhomeXE/dbs/opc_wallet/oci_pvt

PUBLIC KEY --> /opt/oracle/product/18c/dbhomeXE/dbs/opc_wallet/oci_pub

# Generate a Public Fingerprint from the Public Key

 Do it from the OCI Console

# Install the OCI Module

java -jar oci_install.jar -argFile arglist.txt

-host https://objectstorage.eu-frankfurt-1.oraclecloud.com

 -pvtKeyFile /opt/oracle/product/18c/dbhomeXE/dbs/opc_wallet/oci_pvt

-pubFingerPrint 07:2b:fc:10:34:b7:a4:b9:8d:83:72:ca:49:d6:11:27

-uOCID

 -tOCID

 -walletDir /opt/oracle/product/18c/dbhomeXE/dbs/opc_wallet

-libDir /opt/oracle/product/18c/dbhomeXE/lib

 -configFile /opt/oracle/opc/opc_installer/oci_installer/ociconfig.ora

# Perform an Encrypted Backup

 RMAN> set encryption on identified by "oracle12" only;

run

{

 configure channel device type 'sbt_tape' PARMS 'SBT_LIBRARY=/opt/oracle/product/18c/dbhomeXE/lib/libopc.so , SBT_PARMS=(OPC_PFILE=/opt/oracle/opc/opc_installer/oci_installer/ociconfig.ora)';

backup as compressed backupset device type 'sbt_tape' database plus archivelog;

 }

 

Oracle Cloud Machine

# Create a new RSA Key

 [oracle@ocidbsystem oci_installer]$ java -jar oci_install.jar -newrsakeypair -walletDir $ORACLE_HOME/dbs/opc_wallet

Oracle Database Cloud Backup Module Install Tool, build 19.3.0.0.0DBBKPCSBP_2019-10-16

OCI API signing keys are created:

PRIVATE KEY --> /u01/app/oracle/product/18.0.0.0/dbhome_1/dbs/opc_wallet/oci_pvt

PUBLIC KEY --> /u01/app/oracle/product/18.0.0.0/dbhome_1/dbs/opc_wallet/oci_pub

Please upload the public key in the OCI console.

 # Generate a Public Fingerprint from the Public Key

 Do it from the OCI Console

 # Install the OCI Module

java -jar oci_install.jar -argFile arglist.txt

-host https://objectstorage.eu-frankfurt-1.oraclecloud.com

-pvtKeyFile /u01/app/oracle/product/18.0.0.0/dbhome_1/dbs/opc_wallet/oci_pvt

-pubFingerPrint 9d:38:a9:1c:13:57:38:ce:d3:b3:dc:c5:e7:54:16:7b

-uOCID

-tOCID

-walletDir /u01/app/oracle/product/18.0.0.0/dbhome_1/dbs/opc_wallet

-libDir /u01/app/oracle/product/18.0.0.0/dbhome_1/lib

-configFile /u01/app/oracle/staging/opc_installer/oci_installer/ociconfig.ora

 # Perform a Restore / Recover on the Oracle Cloud

 set dbid=2908503447;

SET DECRYPTION IDENTIFIED BY "oracle12";

Run

 {

 ALLOCATE CHANNEL t1 DEVICE TYPE 'sbt_tape' PARMS 'SBT_LIBRARY=/opt/oracle/product/18c/dbhomeXE/lib/libopc.so ENV=(OPC_FILE=/opt/oracle/product/18c/dbhomeXE/dbs/opcXE.ora)';

 RESTORE CONTROLFILE FROM autobackup ;

 alter database mount ;

restore database ;

recover database;

 }

Thanks,

Srini