Re: RMAN delete BEFORE backup

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Tue, 8 Feb 2011 09:19:54 +1100
Message-ID: <AANLkTimNq1t2HMU07fbSNJrW7vu_64G4D9WgDy39SCQW_at_mail.gmail.com>

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 it.

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_at_earthlink.net> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 07 2011 - 16:19:54 CST