Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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