Re: Question about DataGuard

Try the following:

On the primary database you need to make it either Maximum protection mode or Maximum Available mode.

Use the command:

alter database maximise protection
{availability|Performance|Protection}

Secondly on your log_archive_dest_n='SERVICE=INSTANCE_NAME'

change it so that it definitley uses LGWR

eg

log_archive_dest_n='SERVICE=INSTANCE_NAME LGWR

You can that parameter in the pfile (init.ora for your database)

or if u use spfile

alter system set log_archive_dest_n=as above

That should make the lgwr process send the transactions as they happen on the online redo logs...

test it out first!

emdproduction_at_hotmail.com wrote:
> Group,
>
> I have a question when reading about Dataguard.
>
> Say, I have a primary database and standby database, and all the
> archived logfile are shipped from primary databaes to standby site on
> confirmed mode.
>
> If my primary database was crashed and not available, all I have in
> standby site is the archvived log files, what happens to the
> transactions in online redo but not archived yet? Is there any way I
> can transfer info in online redos to standby site?
>
> Will I lose some data if my primary site went down suddenly?
>
> Thanks for any people who will clear this up for me.
Received on Sun Jul 30 2006 - 13:50:23 CDT