it's not exactly crystal clear but yes the error is there. I knew I was forgetting something :)
--- John Kanagaraj <[EMAIL PROTECTED]> wrote: > Just to add that you _can_ be informed of this if you monitor the > alert log. > The following errors are logged (from a live system, and way back > from > 7.3.4!) > > Thread 1 advanced to log sequence 69529 > Current log# 1 seq# 69529 mem# 0: /u090/oradata/XXXX/REDO0101.DBF > Current log# 1 seq# 69529 mem# 1: /u091/oradata/XXXX/REDO0102.DBF > ...skipping... > ORA-00255: error archiving log 1 of thread 1, sequence # 69616 > ORA-00312: online log 1 thread 1: '/u090/oradata/XXXX/REDO0101.DBF' > ORA-00312: online log 1 thread 1: '/u091/oradata/XXXX/REDO0102.DBF' > ORA-00272: error writing archive log > ORA-00334: archived log: '/u091/oradata/XXXX/arch/arch1_69616.log' > ARCH: > ORA-00255: error archiving log 1 of thread 1, sequence # 69616 > ORA-00312: online log 1 thread 1: '/u090/oradata/XXXX/REDO0101.DBF' > ORA-00312: online log 1 thread 1: '/u091/oradata/XXXX/REDO0102.DBF' > ORA-00272: error writing archive log > ORA-00334: archived log: '/u091/oradata/XXXX/arch/arch1_69616.log' > Mon May 13 05:36:57 2002 > Thread 1 cannot allocate new log, sequence 69618 > Checkpoint not complete > > John Kanagaraj > > -----Original Message----- > Sent: Wednesday, July 23, 2003 12:30 PM > To: Multiple recipients of list ORACLE-L > > Yes you have to move them to tape and either compress or delete them > once you have backed up the logs and datafiles.... Check out the > Backup and Recovery Handbook by Velpuri, there are some pretty good > examples there. > > If you don't clean out the archive directory on occasion, the > database > will hang when that filesystem is filled. you won't get a message > that > it's hung but it will hang. > > > --- "Farnsworth, Dave" <[EMAIL PROTECTED]> wrote: > > I finally get to put our 8.1.7 on NT databases into archivelog > mode. > > We have a third party app vendor that would not support us if I did > > this but I finally convinced them that is the way to go and it > should > > not effect the app. Anyway, I am reading chapter 7 from the > > Administrators Guide, Managing Archived Redo Logs. I know I have > to > > set the parameters in the init.ora to achieve automatic archiving; > > > > log_archive_start=true > > log_archive_dest_1 = "location=my\disk\drive" > > log_archive_format=%%ORACLE_SID%%T%T%S.ARC -or somthing like that > > > > One thing I don't see in TFM is, do these archived redo logs just > > keep accumulating in the destination directory set in the > > log_archive_dest_1 parameter? Do I need to create a process to get > > them to tape and then once on tape, delete these old archive redo > > logs through my process? > > I'm just excited to be able to finally go to archivelog mode. Once > I > > get the basics down then I want to investigate using RMAN. > > > > Thanks, > > > > Dave > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Farnsworth, Dave > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting > services > > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like > subscribing). > > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: John Kanagaraj > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
