Re: recovering a subset database

From: Mladen Gogala <>
Date: Mon, 9 Feb 2009 19:40:47 +0000 (UTC)
Message-ID: <gmq0rv$144$>

On Mon, 09 Feb 2009 05:53:41 -0800, vick wrote:

> On source database (host A),
> 1. alter database begin backup.
> 2. copied datafiles for system,undots,users,sysaux,redo to the new mount
> points
> 3. alter database end backup.

Hmmm, your backup procedures need some redesign. This is Oracle 7i method. Oracle 7 is slightly out of date but there are still some instances operating. There is a product called "rman" which aleviates the need for such thing. On the other hand, you can do that if you're unwilling to pay for an expensive commercial backups, like Symantec NetBackup or EMC NetWorker. There are backup scripts which work with Bacula which use "alter tablespace begin/end backup" and if that is the case, I apologize for my comments.

Received on Mon Feb 09 2009 - 13:40:47 CST

Original text of this message