Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Dataguard / Archive Logs

Re: Dataguard / Archive Logs

From: Dimitre Radoulov <cichomitiko_at_gmail.com>
Date: Wed, 1 Jun 2005 20:12:13 +0200
Message-ID: <004b01c566d5$722e20a0$2a00a8c0@IBME1D11967173>


Perhaps I'm missing something here but .., do you really need DataGuard with this configuration?

You just can stop the primary and start the other one ... or you need the secondary open in read only(and you could open it anyway without DataGuard)?

Dimitre

> Hi,
>
> I have a couple more questions on this as its getting quite involved
> here as to how we are going to set it up.
>
> Still in the planning phase here and what we have is the primary and
> seconday site each with its own SAN.
>
> The SAN's are connected via a fibre link wihich have their own
> transfer protocol between them. At the moment there is no standard
> network connection available between the two sites for us.
>
> As the data gets written on the primary, the SAN is replicating that
> data automatically to the standby site so in theory they are the same
>
> so all being well can we then take that archive log and apply it
> manually to the standby database.
>
> Is this a known configuration? =20
>
> This is going to be harder to do a test on, so if anyone knows I would
> be extremely grateful
>
> On 5/31/05, Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl> wrote:
>> It depends.
>>=20
>>=20
>> If using LGWR to get the redo sent to the standby (using standby redo log
>> files), the logswitch will be performed locally on the standby. So, there
>> is no incomplete archived redo logfile at the standby.
>>=20
>> A test for the first case can go along the following steps:
>> - stop the log-transfer (defer the log_archive_dest_x)
>> - perform a logswitch on the primary.
>> - Copy the archived logfile to the standby manually
>> - blank or delete the last blocks, eg using dd. (talking *n*x here)
>> - register the logfile manually to the stanby
>> - try to apply it.
>> - see what happens
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 01 2005 - 14:17:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US