Re: Archived Redo Logs

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 17 May 2007 16:29:32 -0700
Message-ID: <bf46380705171629u245149dfob30efcc6b03e5aee@mail.gmail.com>

On 5/17/07, Ignizio, Richard <richard.ignizio_at_paetec.com> wrote:
>
> Hi all,
>
> I would like to know your backup policies concerning Archived redo logs,
> such as how long do you keep them on tape, etc.
>

We keep archived logs as long as we keep the database files.

I'm not sure what the purpose would be of having difference retention policies
for archived logs and data files.

Archive logs are backed up twice to tape, then deleted from disk.

eg.

BACKUP FORMAT '%%d_T%%T_arch_s%%s_p%%p_t%%t' ARCHIVELOG ALL NOT BACKED UP 2 TIMES; DELETE ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE sbt;

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 17 2007 - 18:29:32 CDT