Create a new RSA Key
Oracle$ 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
Public Fingerprint from the Public Key
Do it from the OCI Console
First 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
Take 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;
Create a new RSA Key
[oracle@ocidbsystem oci_installer]$ java -jar oci_install.jar -newrsakeypair -walletDir $ORACLE_HOME/dbs/opc_walletOracle Database Cloud Backup Module Install Tool, build 19.3.0.0.0DBBKPCSBP_2019-10-16
OCI API signing keys are created:
PRIVATE KEY –> /d01/app/oracle/product/18.0.0.0/dbhome_1/dbs/pvt_oci
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.
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 /d01/app/oracle/product/18.0.0.0/dbhome_1/dbs/pvt_oci
-pubFingerPrint 12:95:8q:33:74:86:77
-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 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/19c/dbhome/dbs/opc.ora)’;
RESTORE CONTROLFILE FROM autobackup ;
alter database mount ;
restore database ;
recover database;
}
