Re: RMAN Scripts (8i, 'change backupset <pkey> delete;)

I'm looking for an intelligent script for deleting archive logs before deciding
to write my own.

My requirements:

a. 1 archive log destination
b. keep 24 hours of archive logs in log destination before deleting
c. archive logs must be backed up on 2 separate tapes before being deleted
d. archive log backup job will run every 2 hours

The basic command:

backup archivelog from time 'sysdate-1' all delete input;

works for keeping recent logs on disk without a restore, but doesn't guarantee
they've been backed up twice.

I'm thinking I'm going to have to query v$ views to detect number of backups for each log and build commands dynamically.

Also, I wouldn't mind seeing your clean up script.

Mike O <ora7dba_at_yahoo.com> wrote in message news:971dsb$omv_at_nntpa.cb.lucent.com...
> Has anyone written any scripts that they would like to share for Oracle's
 8i
> RMAN? I have the basic 'whole' database backup script running and
 restores
> are working.
>
> I am currently in a Veritas NetBackup / Solaris environment and looking
 for
> examples of incremental and differential. Also while testing I have
 written
> a script to clean up the RMAN catalog and trying to release the test tapes
> from the media manager.
>
> Also looking for help on the 'change backupset <pk> delete' process. I
 have
> yet to find good examples here either and the Oracle8i Backup and Recovery
> book (by Rama Velpuri) is a little week in this area.
>
> Thanks!
>
> -Mike
>
>
Received on Sun Feb 25 2001 - 22:43:22 CST