Re: RMAN delete BEFORE backup

  • From: Jack van Zanen <jack@xxxxxxxxxxxx>
  • To: asterger@xxxxxxxxxxxxx
  • Date: Tue, 8 Feb 2011 09:19:54 +1100

I hope this is hypothetical question only.

Get client to invest in more disk space. Most likely cheaper than the amount
of time (money) spent on a new backup strategy and the testing involved with

Jack van Zanen

This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation

On Tue, Feb 8, 2011 at 5:22 AM, Alan Sterger <asterger@xxxxxxxxxxxxx> wrote:

> Hello Listers,
> Using Oracle 9i RMAN template below.  Level 0 executes on Sunday, Level 1
> the rest of the week.
> Client has limited disk space. Can the 'delete input' and/or 'delete
> obsolete' be executed BEFORE the two 'backup' commands?
> Are there other tweaks that can be applied?  Got a better script?
> run {
> allocate channel Channel1 type disk format 'F:\orabackups\%d_%s_%p_%t';
> backup  incremental level 1
>   ( database  include current controlfile );
> backup  ( archivelog all  delete input );
> }
> allocate channel for maintenance device type disk;
> delete obsolete device type disk;
> Cheers,
> Alan Sterger
> --

Other related posts: