Restoring Your Confidence in Oracle Backups

March 27, 2006

[From SysAdmin]

Wouldn't it be great to be able to rely on your backups and have full confidence that they will work properly during a disaster or a routine restore operation? Unfortunately, making assumptions about your restores can lead to delays in projects, wasted time, and ultimately data loss. While it may be fairly easy to configure backups and assume the restore process will work as long as the backups have run successfully, the reality is that each process is different and involves its own set of challenges.

On a basic hardware level, backups write to tape, and restores perform a read operation on the tape hardware. As the following example illustrates, success of one process does not guarantee success of the other.

The article continues at http://www.samag.com/documents/s=10067/sam0605a/0605a.htm