Re: Re-Syncing physical/logical standby

From: Olaf Musch <Olaf.Musch_at_computer.org>
Date: Wed, 30 Jun 2004 16:43:10 +0200
Message-ID: <2kg1qbF1uog8U1@uni-berlin.de>

"Pete's" <empete2000_at_yahoo.com> schrieb im Newsbeitrag news:6724a51f.0406300429.6c1fea8a_at_posting.google.com...
>

Hi Pete's,

> For the physical standby, all you do is the following:
> 1. Copy all archives from the time gap to the standby database
> archive location.
> 2. startup nomount
> 3. alter database mount standby database
> 4. recover automatic standby database until cancel
> 5. recover managed standby database disconnect.
>

Thanks, we'll check this out

> For logical standby's, I'm not sure, I've not had the opportunity to
> test. However, I would think that this would make your setup more
> complex in having to manage two different standby db's.
>

Your're heavily understating ;-)

Olaf Received on Wed Jun 30 2004 - 09:43:10 CDT