Re: Help: Standby issue

Change your script to either...

1. Make sure the last archived log has been completely copied. This can be done by checking the length of the file every 5 seconds or so until it doesn't change.
2. Apply all but the last log received. This would be a little trickier but can be done several ways.

Why not just use the "real" managed standby mode? It's very easy and has worked well for us.

If you want to see if it's "useful" or not, why not open it in read only mode and make sure everything's there?

> u518615722_at_spawnkill.ip-mobilphone.net wrote:
>
> > We have a managed standby database. Oracle
> > will copy the redolog from production site,
> > that works fine. But we are using manual
> > mode for recovery. Every 15 min, shell script
> > will issue
> > Alter database recover standby database automatic;
> >
> > it works fine most of the time, but once or twice a
> > day, we will get the following error messages:
> >
> > ERROR at line 1:
> > ORA-00283: recovery session canceled due to errors
> > ORA-00368: checksum error in redo log block
> > ORA-00353: log corruption near block 6657 change 2373668345 time
 06/04/2001
> > 06:40:43
> > ORA-00334: archived log: '/archive/oradata/traf1/traf1_69996.log'
> > but the problem is, when we found this error, it is 30 minutes later,
 and
> > standby database continue to recover, the following error message is
> > alter database recover automatic standby database
> > *
> >
> > it just triggers our alarms, does not seem to prevent oracle
> > to continue to recover as new redologs are coming in.
> > But we are very concerned that this standby database
> > is useful or not at emergency.
> >
> > I just switched to sustained recovery mode, hope that will
> > help. 4 hour passed, we have not heard any alarm yet.
> >
> > Do you guys have the similar problem?
> >
> > Thanks
> >
> >
> >
> > --
> > Sent by dbadba62 from hotmail piece of com
> > This is a spam protected message. Please answer with reference header.
> > Posted via http://www.usenet-replayer.com/cgi/content/new
>
Received on Wed Jun 06 2001 - 09:23:47 CDT