Re: Managing Archived Redo Logs

You will have to write separate batch script or use some tool to back them up to tape .
Yes, RMAN can do it all for you if setup accordingly to delete xyz days old archived log;

-ak

• Original Message ----- From: "Farnsworth, Dave" <DFarnsworth_at_Ashleyfurniture.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, July 23, 2003 12:09 PM Subject: Managing Archived Redo Logs

> 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).
Received on Wed Jul 23 2003 - 14:38:32 CDT