12 Days of #Cloud: Enabling #DBaaS Backups

12 Days of #Cloud: Day 6

When I created the #DBaaS instance, did not create a backup policy. I chose the backups as “None”. Now that some work has been done on the database, would like to create an adhoc backup as well as want to schedule regular local disk backups.

On-demand backup can be performed by running script “/var/opt/oracle/bkup_api/bkup_api bkup_start” as the root user.

[opc@CLDB4ACED ~]$ sudo -s
[root@CLDB4ACED opc]#
[root@CLDB4ACED opc]# /var/opt/oracle/bkup_api/bkup_api bkup_start
DBaaS Backup API V1.5 @2015 Multi-Oracle home
-> Action : bkup_start
-> logfile: /var/opt/oracle/bkup_api/log/bkup_api.log
API INFO : Backups are not configured on this DB Instance. Nothing to do.
*
* RETURN CODE:0
##################################################
[root@CLDB4ACED opc]#

Oops, no backup configured! So, for the first time, we need to configure backup before we can perform a backup.

Reference: Oracle Documentation

Backup configuration is saved in file /var/opt/oracle/ocde/assistants/bkup/bkup.cfg. Let’s edit the file and add required parameters.

[opc@CLDB4ACED ~]$ sudo -s
[root@CLDB4ACED opc]#
[root@CLDB4ACED opc]# cd /var/opt/oracle/ocde/assistants/bkup/
[root@CLDB4ACED bkup]# ls *cfg
bkup.cfg
[root@CLDB4ACED bkup]# cat bkup.cfg
# The bkup.cfg file will hold all the config info for BKUP
[root@CLDB4ACED bkup]# cp -p bkup.cfg bkup.cfg.1
[root@CLDB4ACED bkup]# vi bkup.cfg 

[root@CLDB4ACED bkup]# cat bkup.cfg
# The bkup.cfg file will hold all the config info for BKUP
bkup_cfg_files=yes
bkup_disk=yes
bkup_disk_recovery_window=2
bkup_oss=no
bkup_oss_url=oss_url
bkup_oss_user=username
bkup_oss_passwd=password
bkup_oss_recovery_window=30
[root@CLDB4ACED bkup]#

[root@CLDB4ACED bkup]# chown root bkup.cfg
[root@CLDB4ACED bkup]# chmod 0600 bkup.cfg

[root@CLDB4ACED bkup]# ./bkup -cfg bkup.cfg
Starting BKUP
Logfile is /var/opt/oracle/log/bkup/bkup_2016-12-06_17:01:47.log
Config file is bkup.cfg
dbname: CDDB01
Dataguard configuration
Enabled: 0
Mode: PRIMARY
Looking for previous configuration:
Directory : /home/oracle/bkup/CDDB01
  -> obkup
  -> dbcfg.spec
  -> log
 -> Found: 3 files
 -> Moving previous configutarion to /home/oracle/bkup/CDDB01_20161206170154
No initial bkup of PFILE needed.
Configuring Backup to disk
Common RMAN Config
Instantiating obkup
Instantiating dbcfg.spec
Configuring backup of Config File
Updating Control File Record Keep Time
Enabling block change tracking
Updating RMAN defaults
Adding entry to crontab
INFO: Archivelog management enabled.
Warning: there are already 1 entries for crontab
  -> 0,30 * * * * root /home/oracle/bkup/CDDB01/obkup -dbname=CDDB01 -archivelog
Accessing to your Database ID ..
The DBaaS instance database id is: 4135691349
Deleting unencrypted autobackups.
#### Completed Execution.
[root@CLDB4ACED bkup]#

BKUP_DISK is for local disk backup, and enabled local backup by setting this parameter to YES. Local disk backups are written to the Flash Recovery Area, which is /u03/app/oracle/fast_recovery_area directory. The parameter BKUP_OSS is to write backups to Oracle Cloud Storage.

The bkup script, backup assistant, created few cron jobs to do the backup periodically.

[root@CLDB4ACED etc]# cat /etc/crontab
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=""
HOME=/

# For details see man 4 crontabs

# Example of job definition:
# .---------------- minute (0 - 59)
# |  .------------- hour (0 - 23)
# |  |  .---------- day of month (1 - 31)
# |  |  |  .------- month (1 - 12) OR jan,feb,mar,apr ...
# |  |  |  |  .---- day of week (0 - 6) (Sunday=0 or 7) OR sun,mon,tue,wed,thu,fri,sat
# |  |  |  |  |
# *  *  *  *  * user-name command to be executed

0,30 * * * * root /home/oracle/bkup/CDDB01/obkup -dbname=CDDB01 -archivelog
15 03 * * 6 oracle /var/opt/oracle/cleandb/cleandblogs.pl
54 2 * * * root /var/opt/oracle/bkup_api/bkup_api bkup_start --dbname=CDDB01
[root@CLDB4ACED etc]#

Let’s kick off the backup again.

[root@CLDB4ACED etc]# /var/opt/oracle/bkup_api/bkup_api bkup_start --dbname=CDDB01
DBaaS Backup API V1.5 @2015 Multi-Oracle home
-> Action : bkup_start
-> logfile: /var/opt/oracle/bkup_api/log/bkup_api.log
** process started with PID: 23297
** see log file for monitor progress
-------------------------------------
[root@CLDB4ACED etc]#

[root@CLDB4ACED etc]# cat /var/opt/oracle/bkup_api/log/bkup_api.log
... ... ...
Tue, 06 Dec 2016 17:17:25 DBaaS Backup API V1.5 @2015 Multi-Oracle home
Tue, 06 Dec 2016 17:17:25 -> Action : bkup_start
Tue, 06 Dec 2016 17:17:25 -> logfile: /var/opt/oracle/bkup_api/log/bkup_api.log
Tue, 06 Dec 2016 17:17:25 ** process started with PID: 23297
Tue, 06 Dec 2016 17:17:25 db35376e-bbd7-11e6-9159-c6b07b253285 -> Starting execution of backup log in background
Tue, 06 Dec 2016 17:17:25 ** see log file for monitor progress
Tue, 06 Dec 2016 17:17:25 -------------------------------------
Tue, 06 Dec 2016 17:17:25 db35376e-bbd7-11e6-9159-c6b07b253285 STARTING BACKUP REQUEST
Tue, 06 Dec 2016 17:17:25 Creating Backup Api registry datatabase
Tue, 06 Dec 2016 17:17:25 UUID db35376e-bbd7-11e6-9159-c6b07b253285 written with PID 23297
Tue, 06 Dec 2016 17:17:33 db35376e-bbd7-11e6-9159-c6b07b253285 Checking if CDDB01 resource is available
Tue, 06 Dec 2016 17:17:33 db35376e-bbd7-11e6-9159-c6b07b253285 registering request into the database
Tue, 06 Dec 2016 17:17:37 db35376e-bbd7-11e6-9159-c6b07b253285 current backups 0
Tue, 06 Dec 2016 17:17:37 db35376e-bbd7-11e6-9159-c6b07b253285 command /home/oracle/bkup/CDDB01/obkup -dbname=CDDB01
Tue, 06 Dec 2016 17:19:54 db35376e-bbd7-11e6-9159-c6b07b253285 The backup process failed

Backup failed! This time, it was due to insufficient local storage to hold the backup. Since I chose no backup option, Oracle Cloud Service did not allocate storage to perform backups to /u03 file system. The database was created in ARCHIVELOG mode, and the Cloud Service setup a cron job to remove the archivelog files hourly.

It took a while to figure out how to add storage to /u03 file system. More storage is added to the standard file systems by using the “Scale up or down Resources” menu item.

Added 50G to “Backup Storage Volume”, which is /u03. 6G volume is now 56G.

Adding disk space alone is not sufficient, need to increase the Fast Recovery Area as well.

Though backup is scheduled to run periodically using the cronjobs, lets kick off a backup to verify if the added storage in /u03 resolved the backup issue.

Voila, successful backup!

DBaaS monitor console also shows the status.

The /home/oracle/bkup/CDDB01/obkup cron job performs operating system file backups. The file backups are based on two configuration files, and their contents are:

[root@CLDB4ACED CDDB01]# pwd
/home/oracle/bkup/CDDB01

[root@CLDB4ACED CDDB01]# cat dbcfg.spec
### Oracle_Home configuration files.
#
# Doc Spec
dbcfg.spec
# DB id
dbid
#
# Directories
/u01/app/oracle/product/12.2.0/dbhome_1/admin/CDDB01/xdb_wallet
/u01/app/oracle/admin/CDDB01/xdb_wallet
/u01/app/oracle/admin/CDDB01/db_wallet
/u01/app/oracle/admin/CDDB01/opc_wallet
# Note: tde_wallet must be backed up in a different location than DATA bkup.
/u01/app/oracle/admin/CDDB01/tde_wallet
/u01/app/oracle/admin/CDDB01/cat_wallet
#/u01/app/oraInventory
#
# Single files
/u01/app/oracle/admin/CDDB01/opcCDDB01.ora
/u01/app/oracle/product/12.2.0/dbhome_1/dbs/orapwCDDB01
/u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
/u01/app/oracle/product/12.2.0/dbhome_1/network/admin/sqlnet.ora
/u01/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora
/u01/app/oracle/product/12.2.0/dbhome_1/rdbms/lib/env_rdbms.mk
/u01/app/oracle/product/12.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk
#
# Creg
/var/opt/oracle/creg/CDDB01.ini
#
[root@CLDB4ACED CDDB01]#
[root@CLDB4ACED CDDB01]# cat oscfg.spec
## OS Configuration Files
#
# Doc Spec
oscfg.spec
#
# Directories
/etc/rc.d
/home/oracle/bkup
#
# Single files
/home/oracle/.bashrc
/etc/crontab
/etc/sysctl.conf
/etc/passwd
/etc/group
/etc/oraInst.loc
/etc/oratab
/etc/fstab
[root@CLDB4ACED CDDB01]#

As you can see, all important files from the Operating System are backed up. If you have directories to be backed up, add to the dbcfg.spec file.

Enabling and performing cloud backups is also using similar steps. Update these parameters accordingly in the bkup.cfg file.

bkup_oss=yes
bkup_oss_url=oss_url
bkup_oss_user=username
bkup_oss_passwd=password
bkup_oss_recovery_window=30

 

4 Replies to “12 Days of #Cloud: Enabling #DBaaS Backups”

  1. Hello, I did all the steps and manual backups are successful but still can’t see the backup tab in cloud console. what configuration is required to enable the “Backup tab”

Comments are closed.