1. Converged UA
  2. Simulator Labs for Oracle Database Appliance
  3. Simulator Labs Overview
  4. Lab 2 - Manage Databases
 

Step 8 - Create Database Backups on Local Disk, External NFS Storage, or on Oracle Cloud

Backing up and restoring Oracle databases on Oracle Database Appliance is very simple.  There are two simple steps involved to create a database backup locally or on Oracle Cloud. These can be done using the web GUI:

  1. Create a backup policy
  2. Attach a backup policy to a database

To back up to an external NFS storage, you must create an NFS mount point first.

To back up to the Oracle Cloud, you must obtain and create Object Store credentials first.

There is a default backup policy associated with the database. To create a new backup policy, click on the Backup Policy tab and then click Create Backup Policy.

Create Backup Policy

Then, name the Backup Policy (for example, DiskBackup), Backup Destination (Internal FRA/Local Disk or External FRA/External NFS Storage or Object Store/Oracle Cloud), and Recovery Window in days, then click Create.  To back a database to an external NFS storage, you need to specify a mount point such as /u03/app/oracle/oradata/nfs_backup.

Create Backup Policy page

You can see the DiskBackup policy has been created.

Backup Policy list

Next you select the database, for example, db4, that you want to backup.  The db4 database has the default backup policy, so modify the database first by clicking Modify under Actions. Assign a CPU pool to db4 at the same time.

Assign CPU pool

Select DiskBackup as the Backup Policy and cpupool1 as the CPU pool for db4, and then click Modify.

Modify Database page

Once the job is completed, you can verify that the backup policy is listed under Database Information of the database, for example, db4.  You can also see that a CPU pool is assigned to db4.  Once this configuration is completed, Oracle Database Appliance will start backing up the database to the disk regularly and produce backup reports.

Database Information page

You can see the backup reports under the Backups heading below.

Database Backup Reports page

You can also click Manual Backup, then click Start to back up a database manually.

Manual Backup

You can see the details of the Backup Report by clicking on the Backup Report ID.

Backup Report page

In addition to backing up to local disk, you can back up to Oracle Cloud.  To back up databases in Oracle Database Appliance to Oracle Cloud, you must obtain Object Store credentials first. Once you have your credentials, click the Object Store tab, then click Create Object Store Credential.

Create Objectstore Credentials page

Enter the required Object Store Credentials including the name.  You can now create a backup policy, attach a database to the policy, and specify the Object Store as the backup destination.  Oracle Database Appliance will start backing up the database to the Oracle Cloud regularly.

Create Object Store Credentials

This concludes Lab 2.