Re: Restoring individual databases

Simpson, Don wrote: > <snip> > Currently we back up the databases by both > ontape and nightly unloads to ASCII files. Using the ASCII unloads is our > solution to restoring individual databases when someone "accidentally" > deletes one. <more snippage> > It looks like the only real answer to > restoring individual databases is to put them in their own dbspace. > Unfortunately, having to deal with so many databases, it's not a solution > for us. We'll just have to port our ASCII backup utilities, not a big deal. At the risk of repeating myself, I would just like to point out that even putting the databases in their own dbspaces is not a solution to your problem, as described here. If you restore just a single dbspace, you MUST go through logical recovery. This means that when someone "accidentally" deletes his database, the logical recovery *replays* the deletion, and at the end of the recovery, you're back where you started, i.e. your database is still deleted. What individual dbspace backup buys you is reduced time to restore, and ability to keep using the other dbspaces while one is being recovered. June -- june_t@hotmail.com Grounded in Palo Alto, living on Pop-Tarts (blueberry)