by With Oracle Database Cloud Service, you can change the backup destination for your database deployment after creating it. When a database is deployment, it is configured with one of the following backup destinations. I choose None during deployment and now would like to configure backups.
- Both Cloud Storage and Local Storage
- Cloud Storage Only (not currently available for database deployments that use Oracle RAC)
- None
Prerequisites:
To configure both Cloud Storage and Local Storage, you must increase the size of the local storage used for local backups. Click Here to know how to add/increase storage volume.
You must have an Oracle Storage Cloud Service container in your account that is reserved for cloud backups. Here is information for how to create Container
Local Backups:
Connect as the “opc” user to the compute node and start root-user. Change to the location for the backup configuration file.
|
1 2 3 4 5 |
[opc@Clouddb01 ~]$ [opc@Clouddb01 ~]$ sudo -s [root@Clouddb01 bkup]# cd /var/opt/oracle/ocde/assistants/bkup/ [root@Clouddb01 bkup]# ls -al bkup.cfg -r-xr-xr-x 1 oracle oinstall 59 Aug 1 12:11 bkup.cfg |
If a “bkup.cfg” file already exists and contains configuration details, rename the file to make it a backup in case you want to recover that configuration later. In my case its blank. So added the backup information.
|
1 2 3 4 5 6 7 8 9 10 11 |
[root@Clouddb01 bkup]# vi 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=<span class="italic">3</span> # Cloud Realted bkup_oss=no bkup_oss_url=<span class="italic">oss-url</span> bkup_oss_user=<span class="italic">username</span> bkup_oss_passwd=<span class="italic">password</span> bkup_oss_recovery_window=<span class="italic">oss-days</span> |
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.
Prepare “bkup.cfg” to be used as follow:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
[root@Clouddb01 bkup]# chown root bkup.cfg [root@Clouddb01 bkup]# chmod 0600 bkup.cfg # Backup Kick off [root@Clouddb01 bkup]# ./bkup -cfg bkup.cfg Starting BKUP Logfile is /var/opt/oracle/log/bkup/bkup_2017-11-20_14:11:54.log Config file is bkup.cfg dbname: CDB01 Dataguard configuration Enabled: 0 Mode: PRIMARY Looking for previous configuration: Directory : /home/oracle/bkup/CDB01 -> obkup -> Found: 1 files -> Moving previous configuration to /home/oracle/bkup/CDB01_20171120141203 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. Adding entry to crontab Accessing to your Database ID .. The DBaaS instance database id is: 1496315960 Deleting unencrypted autobackups. A backup has been triggered. # Backup completed. cd /u03/app/oracle/fast_recovery_area/CDB01 [root@Clouddb01 CDB01]# ls 4E00718FC63415E6E053424FC40A903F archivelog backupset datafile ohcfgfiles oscfgfiles 4E010D850260320FE053424FC40AA81E autobackup control02.ctl flashback onlinelog |
Cloud Backups:
For backups as Cloud Storage Only destination, enter as follows:
|
1 2 3 4 5 6 7 8 |
# The bkup.cfg file will hold all the config info for BKUP bkup_cfg_files=yes bkup_disk=no bkup_oss=yes bkup_oss_url=<span class="italic">oss-url</span> bkup_oss_user=<span class="italic">username</span> bkup_oss_passwd=<span class="italic">password</span> bkup_oss_recovery_window=3 |
- oss-url is the REST endpoint of the storage container.
- username is the username for your account.
- password is the password for your account.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 |
[root@Clouddb01 bkup]# ./bkup -cfg bkup.cfg Starting BKUP Logfile is /var/opt/oracle/log/bkup/bkup_2017-11-27_20:47:38.log Config file is bkup.cfg dbname: CDB01 Dataguard configuration Enabled: 0 Mode: PRIMARY Looking for previous configuration: Directory : /home/oracle/bkup/CDB01 -> the system is clean DB edition: enterprise OSS channels: 5 INFO: OSS connection using supplied creds passed. Using oss container: cloudbkup02 No initial bkup of PFILE needed. Configuring Backup to NDS and OSS. Configuring Backup to OSS Preparing OPC library. Downloading opc_installer.zip... Running OPC installer... INFO : libopc found at /u01/app/oracle/product/12.1.0/dbhome_1/lib. Move to /tmp directory. using file : /var/opt/oracle/log/CDB01/bkup/temp.sh Oracle Database Cloud Backup Module Install Tool, build 2016-09-30 Oracle Database Cloud Backup Module credentials are valid. Oracle Database Cloud Backup Module wallet created in directory /u01/app/oracle/admin/CDB01/opc_wallet. Oracle Database Cloud Backup Module initialization file /u01/app/oracle/product/12.1.0/dbhome_1/dbs/opcCDB01.ora created. Downloading Oracle Database Cloud Backup Module Software Library from file opc_linux64.zip. Downloaded 28876322 bytes in 18 seconds. Transfer rate was 1604240 bytes/second. Download complete. OPC installer completed successfully. OSS specific RMAN config for libopc 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. Adding entry to crontab Accessing to your Database ID .. The DBaaS instance database id is: 1496315960 Deleting unencrypted autobackups. A backup has been triggered. Reference: |
DBaaS monitor console also shows the backup status.Click to know more about DBaaS monitor console
OS/DB home configuration backups:
The /home/oracle/bkup/CDDB01/obkup cron job performs operating system file backups. Two files “dbcfg.spec” (Oracle_Home configuration files ) and “oscfg.spec” (OS Configuration Files) are there to back up configuration files. If you have more directories to be backed up, please update these configuration files.
Mandy!!!!
Reference:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/change-backup-config-different-destination.html#GUID-E7EBDB67-007A-4910-8B5A-A84B5A4AA27E
https://docs.oracle.com/en/cloud/iaas/storage-cloud/cssto/creating-containers.html
Leave a Reply