Re: Archive-Log

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/06/02
Message-ID: <OPQZ4.229809$Tn4.2040025@news1.rdc2.pa.home.com>#1/1

If you use rman to do the backups, then you can use the following statement.

The script (ignore executes) will backup the logs to tape and delete them immediately, but you can change that.

replace script archlogs {
execute script alloc5;
backup
filesperset 4
format '/adsmorc/%d/db_t%t_s%s_p%p.rman' (archivelog all delete input);
execute script rel5;
}

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Christian Hartmann" <c.hartmann_at_tmp-office.de> wrote in message
news:8h7ocf$2ff16$1_at_fu-berlin.de...


> Yes, I know. However, is is possible to implement a function in oracle to

> let it do automatically afer one week?

>

> > They can be deleted after a cold, off-line backup

> > and when they have been backupped themselves,

> > which you should always do.

 


> > > Hi there,

> > >

> > > is it possible to let oracle create archive-logs, but delete them if

 they


> > > are older than, for example one week?

> > >

> > > If yes, how?

> > >

> > > Thanx for help,

> > >

> > > Christian Hartmann

> > >

> > >

> >

> >

>

>

Received on Fri Jun 02 2000 - 00:00:00 CDT