This section provides insights into the backup and restore methods used for Oracle server databases. Before Druva Phoenix can back up your databases, you have to configure your databases for backup and restore. See, Quick steps to set up Druva Phoenix to back up databases.
After you configure databases for backup, Druva Phoenix performs a full backup of the databases on your server hosts. When a full backup is triggered based on the backup policy, the Phoenix agent backs up database files, archived logs, control files, and the server parameter file in the database.
If your databases are getting backed up for the first time, the databases are backed up entirely. If your databases are not getting backed up for the first time, a full scan of the databases is executed but only the updates to your databases are backed up after deduplication is applied. When the backup job is successful, Druva Phoenix creates a snapshot (Restore Point) in your storage.
When you configure databases for backup, Druva Phoenix performs a full backup of databases on your server hosts. Druva Phoenix performs all subsequent backups as incremental backups. When an incremental backup is triggered, the Phoenix agent requests information about databases that are updated. Druva Phoenix backs up the changed data and creates a snapshot in your storage. An incremental backup can be triggered if a snapshot from a full backup exists. If a snapshot from a full backup does not exist, an incremental backup is automatically converted into a full backup job.
Restore point created after every incremental backup is self-sufficient and can restore the entire server without depending on any other restore point.
For more information, see Scenarios when the Oracle incremental backups get converted to full backups.
Archive Log backup
Druva Phoenix allows you to perform archive log backups on your server hosts. When Oracle databases run in the ARCHIVELOG mode, the databases make copies of all online redo logs after the databases are filled. The changes made to the database after the backup are stored in the archive logs. Druva Phoenix backs up such archive logs and helps you to recover your database transactions lost during any server or network failures.
You can define a backup schedule for archive logs while creating backup policy and specify the interval at which Druva Phoenix should back up archived logs. The default value is 1 hour. However, Druva Phoenix allows you to provide value in the range of 15 minutes to 12 hours.
When a full backup is triggered based on the backup policy, the Phoenix agent executes a full scan of all the databases included in the backup and backs up database files and archived logs. Druva Phoenix then continues to trigger archive log backups separately based on the schedule defined in the backup policy. You can track the archive log backup jobs on the Jobs tab.
Druva Phoenix allows you to restore your databases to any point-in-time between the available range of the archived logs. It is a useful, lightweight approach to backup and restore. Archive log backups are incrementally triggered after a full backup job has completed, and a restore point exists. The archive log is backed up every few minutes based on your settings.
Restore databases from snapshots
Druva allows you to restore databases from the warm snapshots that are stored in the Druva Cloud and cold snapshots stored in the AWS glacier. The databases can be restored to the original Oracle server host where the databases were backed up or to a different Oracle server host. For more information on how the snapshot restore works, see the Restore an Oracle database from a snapshot.
Restore databases to a point in time
When Oracle databases run in the ARCHIVELOG mode, the databases make copies of all online redo logs after the databases are filled. Druva Phoenix backs up such archive logs, and you can use it to restore your databases to any point-in-time between the available range of the archived logs. It is a useful, lightweight approach to backup and restore. Archive log backups are incrementally triggered after a full backup job has completed, and a restore point exists. The archive log is backed up every few minutes based on your backup schedule settings.
Druva Phoenix uses the restore point and the archive logs that were logged, to perform a point-in-time restore. When you restore the database using archive logs, Druva Phoenix restores databases to the last available committed transaction before the specified point-in-time. For more information on how the point-in-time restore works, see the Restore an Oracle database to a point-in-time.