Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Managing archive logs

Managing archive logs

From: <npm_at_netcom.com>
Date: Thu, 14 May 1998 23:04:07 GMT
Message-ID: <npmEsyyqv.2wF@netcom.com>


I'm at a site where we have oracle archive logs to deal with and I'd like to be able to remove these big suckers after we've done a cold backup. However, our backups are fully automated and I'm a little nervous about deleting these automagically. My concern is that the backup might fail and the archive logs would be deleted...

How do other sites handle this? Have you developed an automated means of doing this? Is there any software or tools that you recommend?

My one thought right now is to create a file to use as a timestamp when Oracle is started up after a level 0 backup and then, after the backup has been examined by a human eyeball, is to delete any archive logs older than the timestamp file. Does that sound reasonable?

I'm not an Oracle DBA though I play one on TV. I'm actually just a Unix system administrator. Your help is hugely appreciated!

--

Nancy Milligan		Milligan Consulting Services	
npm_at_netcom.com		System Administration, Perl/C/shell programming
			Internet Connectivity, Security, Usenet, WWW, and so on.
			http://nmcs.com

Received on Thu May 14 1998 - 18:04:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US