Re: Help: Standby issue

This happens when you start to apply the archivelog before it has been fully copied by the ARCH process to the standby database. Oracle9i prevents this from occurring, but with Oracle8i you need to manually ensure the archival has completed.

Rick

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 - 07:22:03 CDT