Re: Oracle 8i Standby Complete Recovery

Hi Chris,

With 8i, this is the big issue with the use of a Standby DB.

If the "disaster" doesn't allow time for a final switch logfile, then yes, potentially data will be lost. In some scenarios, you may have the opportunity for an 'alter system switch logfile' command and the logfile's subsequent archive, in some scenarios you may not.

In a site I have been working at, they issue a log switch every half hour to resync their standby DB to minimise possible data loss.

If this possible data loss is a real issue for you, I would recommend either:

1. Move to 9i and make use of Data Guard which through the use of the LGWR process being used to transport redo to the standby DB, can guarantee no loss of data. The cost of this is probable performance loss on the Prod DB but there are various options/settings that can be used to "balance" performance/protection as appropriate.

or

2) Hire DBAs who put the well being of the database ahead of personal protection. You need DBAs made of the right stuff, who during an earthquake, rather than flee the building as it comes crashing down and as flames from burst gas pipes engulf the place will think, "Must ... get ... to ... console (cough cough), must ... switch .... logfile ........".

However, I'm a rare breed and option 1 might be the way to go ;)

Cheers

Richard
"Chris Forbis" <chrisforbis_at_yahoo.com> wrote in message news: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?
>
> Thanks
>
> Chris
Received on Tue Oct 15 2002 - 09:01:38 CDT