Re: How to copy arch logs in rman

From: Venkat <vreddy_at_no_spamix.netcom.com>
Date: Wed, 1 Jul 1998 18:21:00 -0400
Message-ID: <6npeqn$mah@dfw-ixnews10.ix.netcom.com>

Matt,
You can use the following
replace script backup_al_all {

#  Backs up all archived logs to tape, then deletes them once the
#  backup has successfully completed.
#  Does not delete if backup fails

allocate channel ----------
  backup
    format 'al_%d_%s_%t.%p'
    (archivelog all
     delete input);
release channel ----
}

there are some sample scripts in $ORACLE_HOME\rdbms80\rman directory. RMAN allows you to copy archive logs generated between two dates or copy all logs by specifying a range of log sequence numbers.

Venkat

>I'm setting up rman for our 8.0.4 production databases. I have been
backing
>up the archive logs and deleting them through the rman script. I'd like to
>start copying the archive logs off to another disk before deleting them.
>I've looked into using the "copy" command in rman, but the docs say that
>each archivelog file must be specified. Is there an easier way to do this?
>
>Please email answers to mattlarson_at_usa.net
>
>Thanks,
>Matt
>
>
Received on Wed Jul 01 1998 - 17:21:00 CDT