Re: Oracle Archived logs?

From: Phillip <tienp_at_wholefoods.com>
Date: Wed, 26 Feb 2003 11:10:01 -0600
Message-ID: <3E5CF4E9.C2B3AD73@wholefoods.com>

if you do your hot backups via rman, you can have rman delete the archivelogs for you upon completion of the backup. Here's a sample rman script:

run {

        allocate channel t1 type 'SBT_TAPE';
        allocate channel t2 type 'SBT_TAPE';
        allocate channel t3 type 'SBT_TAPE';
        allocate channel t4 type 'SBT_TAPE';

backup
tag production_cold_level_0
format 'production_df_%U'
(database);
backup
format 'production_al_%U'
(archivelog all delete input);
}

This will keep your archivelog directory current since the last level 0 backup.

James wrote:

> Hi there
> A question I take online hotbackups of my database. The question I have is
> when do the archive logs become unnecessary?
>
> For example I make a hotbackup everyday but I'm also backing up every
> Archived log since I started performing hotbackups. Surely there must come a
> time when those old arechived logs are not needed. I don't want to back them
> all up cause I'm running out of space!! How do I find out which are needed?
> If I need them all why?
>
> I'm using oracle 9 on Win 2k.
>
> A BIG thanks in advance
> james

--
Phillip Tien
Database Administrator
Whole Foods Market

You can't spell 'failure' without U  R  A.

Received on Wed Feb 26 2003 - 11:10:01 CST