Message-ID: <3B1E206B.753C3E4F@oracle.com> From: Rick Anderson X-Mailer: Mozilla 4.7 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Help: Standby issue References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 50 Date: Wed, 06 Jun 2001 08:22:03 -0400 NNTP-Posting-Host: 138.2.231.33 X-Trace: inet16.us.oracle.com 991831738 138.2.231.33 (Wed, 06 Jun 2001 05:48:58 PDT) NNTP-Posting-Date: Wed, 06 Jun 2001 05:48:58 PDT 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@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