Backup / Restore

It provides backup/recovery capabilities to minimize data loss and ensure business continuity. Snapshots can be created to safely archive data at a specific point in time and recover it when needed. Snapshot creation and archiving is only possible when the database operational status is Running and the instance status is Normal. Recovery operations are only possible when the database operational state is Running and the instance state is not Disconnect .

Note

Archiving is not currently available in Azure environments.

Caution

If additional data files are added between the time of snapshot creation and recovery, the recovery might fail.

TBR-24018 : CF-DD correction is required due to wrong CF/DD info or added/dropped datafiles while recovery process.

Automatic snapshot / auto-archive settings

Item	Description	Periodicity	Retention period
Automatic snapshots	Automatically take snapshots with a set frequency	1 hour to 7 days	1 hour to 30 days
Auto-archive	Set a frequency to automatically archive snapshots	1 day to 7 days	90 days to 365 days

1. Navigaet to the OwlDB console screen > Administration > Backup/Recovery > Backup Scheduler menu.

2. Click the DB Alias drop-down button to pull down the database for which the users want to set up automatic snapshots, automatic archiving.

3. Click the Edit button.

---

Snapshot / Archive Management

Item	Description	Retention period
Snapshot	Securely archive data at a specific point in time Storage is expensive Instantly recoverable and takes 30 minutes on average	1 hour to 30 days
Archive	Archives snapshots to preserve saved snapshots for a longer period of time. Costs less by storing them in cold storage. Recovery takes up to 3 days.	90 days to 365 days

Creating snapshots

1. Navigate to the OwlDB console screen > Administration > Backup/Recovery > Snapshot/Archive menu.

2. Click the DB Alias drop-down button to pull down the database for which the users want to create a snapshot.

3. Click the Create button.

4. Key in a name and retention period and click the Create button.

Archiving snapshots

1. Navigate to the OwlDB console screen > Administration > Backup / Recovery > Snapshot / Archive menu.

2. Click the DB Alias drop-down button to pull down the database the users want to archive the snapshot to.

3. Click the ☑️ : icon to pull down the snapshots the users want to archive.

4. Click the Archive button.

5. Key in the retention period and click the Archive button.

Note

The minimum retention period is 90 days. Archived data is charged for 90 days of storage, regardless of whether it is deleted or not.

Deleting snapshots

1. Navigate to the OwlDB console screen > Administration > Backup/Restore > Snapshot/Archive menu.

2. Click the DB Alias drop-down button to pull down the database whose snapshot the users want to delete.

3. Click the ☑️ : icon to pull down the snapshot the users want to delete.

4. Click the Delete button.

Caution

Once deleted, the snapshot cannot be recovered and all data will be completely deleted.

Recovering snapshots

1. Navigate to the OwlDB console screen > Administration > Backup/Recovery > Snapshot/Archive menu.

2. Click the DB Alias drop-down button to pull down the database the users want to recover.

3. Click the Recover button to key in the point in time the users want to recover, or click the ☑️ icon to pull down the point in time the users want to recover.

4. Click the Recover button.

5. The users can check the progress under 'Viewing Recovery History'.

Caution

When the users recover a snapshot, the database is immediately restored and all currently stored snapshots are deleted.

Archiving recovery

1. Navigate to the OwlDB console screen > Administration > Backup/Recovery > Snapshot/Archive menu.

2. Click the DB Alias drop-down button to pull down the database from which the users want to recover the snapshot.

3. Click the ☑️ icon to pull down the snapshot the users want to recover.

4. Click the Recover button.

5. Key in the recovery date and time and click the Recover button.

6. The users can check the progress under 'Viewing Recovery History'.

Caution

An archival recovery will immediately restore the database and delete all currently saved snapshots. Depending on the size of the usersr data, this can take up to 3 days.

Deleting archives

1. Navigate to the OwlDB console screen > Administration > Backup / Recovery > Snapshots / Archive menu.

2. Click the DB Alias drop-down button to pull down the database whose archived snapshot the users want to delete.

3. Click the ☑️ icon to pull down the snapshot the users want to delete.

4. Click the Delete button.

Caution

Deleted archives cannot be recovered and all data will be completely deleted.

---

Viewing recovery history

1. Navigate to the OwlDB console screen > Administration > Backup/Recovery > Recovery History menu.

2. Click the DB Alias drop-down button to pull down the database whose recovery history the users want to check.

3. View the snapshot / archive recovery history.

• The users can filter the viewing period, recovery type, and status.

• The users can check recovery history by directly searching name and ID, creation date, and expiration date.