Re: Oracle 8i Standby Complete Recovery

Yea, but the major issue with datagaurd is thatboth systems become a point of failer, so level of failer goes up.

I had an idea, but not sure about it...
Is it possible by looking at the alert log to see what redo log is current one, then look at the archive log numbers, and copy the redo_current over to archvie_##### (what ever number is next), then let it import till it is done, then restart db?

I know this assumes that you can get to the redo on the broken server, but I figure unless just a crazy issue if you have a few copies on differnet drive sets there should be a way...

Thoughts?

Ronald Rood <ronr_at_ronr.nl> wrote in message news:<0001HW.B9D16458000166C3F0284600_at_news.cis.dfn.de>...
> On Mon, 14 Oct 2002 23:49:54 +0200, Chris Forbis wrote
> (in message <f2dc430d.0210141349.6b4b299f_at_posting.google.com>):
>
> > I am looking into ways of recovering in the case of a major failer on
> > a primary server. I have the idea to create a standby server, and
> > this seems to take care of much of the work. The problem I see is
> > when the primary system fails, and a log switch has not happened in
> > the last 4 minutes, It seems I loss that 4 minutes of data because the
> > log has not been archived and moved.
> >
> > Ideas of how to get 100% no data loss?
>
> Switch to 9i. It allows you to configure dataguard with no data loss (at the
> cost of a performance penalty).
>
> Ronald
> -----------------------
> http://ronr.nl/unix-dba
Received on Tue Oct 15 2002 - 09:46:23 CDT