RE: Managing Archived Redo Logs

it's not exactly crystal clear but yes the error is there. I knew I was forgetting something :)

• John Kanagaraj <john.kanagaraj_at_hds.com> 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" <DFarnsworth_at_Ashleyfurniture.com> 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: DFarnsworth_at_Ashleyfurniture.com
  > >
  > > 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com
  >
  > 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: ListGuru_at_fatcity.com (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: john.kanagaraj_at_hds.com
  >
  > 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: ListGuru_at_fatcity.com (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).
  

  ---