Re: How to duplicate an opened database every night ?

On Wed, 05 Dec 2001 04:58:52 -0500, Thep SYKHEO wrote:

> The goal of my question is to create secondary database for datawarehouse
> requests that penalize our production database. I would like to create
> this new database on a small server because we have got it already. So I
> could not use the mirrored logical volume.
>
> Regarding Shareplex, this soft seem to be too expensive for us.
>
> I would like to try a standby database, do you know if I can open the 2
> instances in the same time ?

I work for a company which does precisely that. We use EMC SRDF to sync the disks, and then recover the database on another machine, It's a fairly complex procedure using severeal tailor made programs to perform parsing of te "create controlfile" from the .trc file and alike.

-- 
Mladen Gogala