Re: Backup & Recovery

From: Brian Peasland <peasland_at_email.msn.com>
Date: Thu, 22 Jul 1999 22:02:37 -0500
Message-ID: <uLNHefL1#GA.344@cpmsnbbsa05>

Glen Gorman wrote in message <3794B079.4712F51F_at_nbnet.nb.ca>...
>I was wondering what alternatives there are for the Legato Stroage
>system for Oracle backup and recovery?

I don't know of any, but I thought I would give my 2 cents worth. From what I understand, the problem with Legato and hot backups is that a datafile in a tablespace that's online can not be truly backed up since it can be modified while the backup is running. To counter this, we backup the tablespace (using Oracle hot backup scripts) to another subdirectory. Legato can then back up that datafile. It's kind of a kludge, but it's the best we have. I think someone could make some decent money developing a product that has hooks into Oracle. When this product goes to back up disk files belonging to a tablespace, the product issues the ALTER TABLESPACE ts_name BEGIN BACKUP command. Then it issues the END backup command when the tablespace's disk files are backed up.

My $0.02 worth!
Brian Peasland
peasland_at_msn.com Received on Thu Jul 22 1999 - 22:02:37 CDT