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

Have you considered OEM?

"Vincent G. Poore" <VincePoore_at_excite.com> wrote in message news:K9lm6.5228$W05.989680_at_news1.rdc1.mi.home.com...
> 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 Mon Feb 26 2001 - 20:16:54 CST