Re: Managing Archived Redo Logs

Dave, yes you have the responsibility to get them off disk, ie: the database will appear to halt processing if the archive_dest gets full.

RMAN is good for that, you can back them up and purge them in one step.

Feel free to email direct if you want to talk in depth about it.

joe

Farnsworth, Dave 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
>
>
>
>

-- 
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000