Connect your Enterprise Manager 13cR2 with the Oracle Database Backup Service

In EM13cR1, it was the first time when the Oracle Database Backup Service was integrated . In Release 2 the configuration menu was extended, a storage container can be defined now e.g. for a better organization and overview of the backups. This blog post shows you how to configure the Oracle Database Backup Service in Enterprise Manager 13cR2 and how to prepare a database for a cloud backup. All you need is the Oracle Database Backup Service, a trial works too.

Configure Service Settingsbackup_service_step_00

 

 

 

 

 

Enter your domain and login information. Optional: Set a backup container. A backup container is an organiziation unit like a subdirectory on a server.

backup_service_step_01

Configure the Database

Select the database which you want to backup to the Oracle cloud from the database target page. Configure Oracle Cloud Backup Service.

backup_service_step_02

The first time when you run the configuration, you need to enter your host credentials for the host where the database is running which you want to configure. Use the username which has installed the database software, or you can use a named credential. Be sure that the server where the backup has to be configured has access to the internet.

After submit, a deployment procedure configures the Oracle Database Backup Service on the server. The Oracle Database Backup Service module will be installed on server.

backup_service_step_03

backup_service_step_04

The deployment procedure copies the tape library for the Oracle Database Backup Service into the $ORACLE_HOME/lib and creates a wallet in $ORACLE_HOME/dbs/opc with the cloud certficates. Bot components are required to use the service.

oracle@kestenholz:/u00/app/oracle/product/12.1.0.2/dbhome_1/lib/ [rdbms12102] lr libopc.so
-rwxr-----. 1 oracle oinstall 72062283 Oct 10 08:53 libopc.so
oracle@kestenholz:/u00/app/oracle/product/12.1.0.2/dbhome_1/dbs/opc/ [EMREPO] lr
total 4
-rw-rw-rw-. 1 oracle oinstall    0 Oct 10 08:53 cwallet.sso.lck
-rwxr-x---. 1 oracle oinstall 3101 Oct 10 08:53 cwallet.sso

The EM13c view after the successful deployment. To verify the configuration, press the Test Oracle Cloud Backup Button.

backup_service_step_05

All backups into the Oracle Cloud have to be encrypted, the test run too.

backup_service_step_06

Backup test succeeded.

backup_service_step_07

Execute  RMAN Backup

Now you are able to backup an Oracle database with RMAN into the Oracle Cloud. Schedule a backup.

backup_service_step_08

Schedule a customized backup

backup_service_step_09

On the backup settings page, scroll down to set the encryption mode. You can choose between the wallet and the password method. For more information how to configure a wallet for a backup, take a look at my blog post here: Encrypt RMAN Backups for the Oracle Cloud with a Keystore.

As reminder, database backups with target Oracle Cloud have to be encrypted locally. Otherwise the backup job fails. Activate the checkbox for the password method and set/confirm the password. Next.

backup_service_step_10

Select the Oracle Cloud as destination. Below you can see the used RMAN parameter. Oracle uses the file libopc.so like a tape driver. Next.

backup_service_step_11

Schedule the execution. Next.

backup_service_step_12

Now you can submit the job or use the syntax in the RMAN script box.

backup_service_step_13

set encryption on for all tablespaces algorithm 'AES128' identified by '%PASSWORD' only;
backup device type sbt tag '%TAG' database;
backup device type sbt tag '%TAG' archivelog all not backed up;
run {
allocate channel oem_backup_sbt1 type 'SBT_TAPE' format '%d_%U' parms "SBT_LIBRARY=/u00/app/oracle/product/12.1.0.2/dbhome_1/lib/libopc.so ENV=(OPC_HOST=https://<mydomain>.storage.oraclecloud.com/v1/Storage-<mydomain>, OPC_WALLET='LOCATION=file:/u00/app/oracle/product/12.1.0.2/dbhome_1/dbs/opc CREDENTIAL_ALIAS=martin.berger@trivadis.com_<mydomain>')" maxpiecesize 1000 G;
backup tag '%TAG' current controlfile;
release channel oem_backup_sbt1;
}

The Backup Management Page shows the Oracle Cloud as Media

backup_service_step_14

Summary

The Oracle Database Backup Service is fully integrated in the Oracle Enterprise Manager 13c and it works fine. The EM deploys you  the Oracle backup module on the target servers, once deployed, the configuration can be used for every other database which runs on the same target host as configured.

For more information about the Oracle Database Backup Service, take a look in the documentation here: https://docs.oracle.com/cloud/latest/dbbackup_gs/