Re: Re-Syncing physical/logical standby

"Olaf Musch" <Olaf.Musch_at_computer.org> wrote in message news:<2kf4brF1k48aU1_at_uni-berlin.de>...
> Hi everyone,
>
> we're running Oracle 9.2 Enterprise and are using
> DataGuard to mirror the db
> - as a physical standby to a second machine within the lan
> - as a logical standby to a remote machine via vpn over
> internet (secured with ipsec)
> Now we're experiencing that the mirror databases
> are out of sync. Especially the logical standby,
> which was caused by some connection problems in the
> past.
> Is there an "easy" way to get them back into sync
> or do we have to set it all up anew?
>
> In the oracle manuals, there's everything to set
> it all up and to check it for errors. But there
> seems nothing to be for re-syncing the standby dbs.
>
> Any hints anyone?
>
> Best regards
>
> Olaf

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.

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.

HTH,
Pete's Received on Wed Jun 30 2004 - 07:29:45 CDT