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).
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.
The tasks necessary for performing quick recovery in this example are:
Create a snapshot of the Oracle datafile volume, and resume normal processing with the Oracle datafile.
Simulate Oracle datafile corruption, and recover the Oracle datafile.