Example of quick recovery of an Oracle database

Last published : Aug 05, 2026
This example demonstrates how SFW's split-mirror snapshot can be used to recover an Oracle database after its data has become corrupted. The advantage of using the snapshot process is that it is much faster than recovering the database from tape backup. The process assumes that these split-mirror snapshots would take place on a regular schedule following the regular backup of the database.
This example does not require Microsoft Volume Shadow Copy Service (VSS).
Prerequisites for performing quick recovery of an Oracle database
This example assumes experience with Oracle database backup and recovery and SFW FlashSnap procedures.
The setup must be as follows:
  • The Oracle database must be running in the ARCHIVELOG mode on a single server.
  • The volume that contains the datafile for the Oracle database must not be the system or boot volume, but an SFW volume.
Tasks for performing quick recovery of an Oracle database
The tasks necessary for performing quick recovery in this example are:
  1. Create a snapshot of the Oracle datafile volume, and resume normal processing with the Oracle datafile.
See Creating a split-mirror snapshot of the database.
  1. Simulate Oracle datafile corruption, and recover the Oracle datafile.
See Recovering the database using the split-mirror snapshot and database logs.