Re: rman level 0 backup

On Wed, 02 Mar 2005 04:02:19 GMT, gecho <gechoNO-SPAM_at_hawaii.rr.com> wrote:

>Not intimate with how RMAN (using Oracle 9.2.0.4) works. We have a
>recurring situation (until wise management agrees to buy some hardware for
>us). A level 0 backup doesn't complete because there was no space
>remaining on the disk. RMAN did manage to complete several backup sets
>with the space that was available. If we free up some space and run a
>level 1 incremental, does RMAN do a level 0 backup of the missing pieces?
>I read that RMAN is supposed to do a level 0 if there is no base backup,
>but I wasn't sure if this was applied to a complete level 0 or just any
>set from a level 0 backup.
>
>Thanks,
>gecho

Hi Gecho,

Don't mess with unfinished backups.

And if you are not intimate with RMAN and you're being responsible for backup of a production system...get intimate. Now.

Anyway, a level 1 backup will pick a level 0 backup of the missing parts. So the answer to your question is yes. For safety, do a "crosscheck backup of database;" before the level 1 backup.

• Kenneth Koenraadt