Skip to main content
Enterprise applications

Consistency group backups

Contributors jfsinmsp

For the simplest possible backup, just place the entire Oracle database in a single ONTAP volume

Protecting the datafiles, archive logs, redo logs, and controlfiles with a single snapshot is a valid backup, restore, and replication method. However, the RPO is limited to the point of the backup itself. It is suitable for an RPO of one hour or greater. If a database spans volumes, cg-snapshots are required using one of the tools discussed previously.

As an example, the entire database can be in a single volume with the following snapshot schedule:

  • 72 hourly snapshots

  • 30 nightly snapshots

  • 12 monthly snapshots

This delivers an RPO of one hour over the rolling period of the preceding 72 hours, plus additional nightly and monthly backups. Multiple databases or application files can also be included in the single volume or set of cg-snapshots to deliver consistent backups across a larger environment.