Help: Standby issue

From: <u518615722_at_spawnkill.ip-mobilphone.net>
Date: Mon, 04 Jun 2001 20:13:00 GMT
Message-ID: <l.991685581.1832916259@[198.138.198.252]>

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 Mon Jun 04 2001 - 15:13:00 CDT