Re: Managing Archived Redo Logs

Dave,
 Welcome to the world of archivelogs, Point it time recovery, and running out of disk space at 2 am.
Yes the archive logs have to be saved to tape, a pc, or other storage device else the disk will full up and the instance will hang waiting for disk space to write the log. I have 200 GIG space for archivelogs and RMAN depository and I have to watch the space when I execute a long running update of the database.
 The RMAN backup process is slick and easy to set up and learn. There are some nice books on the market that really help. The can be confusing as they talk about the actions needed with 9i and 8i and the instruction sets are different for each version.
I use a Linux pc to control the RMAN backup of the database (prod) and RMAN instance and depository are on the development server.  I delete the files over 3 weeks old ( they are backed up on tape weekly) and then clean up the RMAN catalog. Works nice and easy. Recovery is fast and easy also. Ron

>>> DFarnsworth_at_Ashleyfurniture.com 07/23/03 03:09PM >>>
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).