Re: Some RMan Questions

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 6 Aug 2004 13:45:26 +1000
Message-ID: <4112feb3$0$2542$afc38c87@news.optusnet.com.au>

"Michael" <melliott42_at_yahoo.com> wrote in message news:91721cf.0408051829.13e19d9d_at_posting.google.com...
> Hello,
>
> In Oracle 8.17 on Sun using RMan with a FULL DATABASE backup to Disk
> can someone please explain:
>
> 1. How to specify a tablespace(s) to NOT backup?

For 8i, you can't (you can in 9i configure an exclude for a tablespace, which thereafter gets skipped from all 'baclup database' jobs).

Instead, do something like

run { ...
backup tablespace system;
backup tablespace data;
backup tablespace users;
}

...and so on.

> 2. How to compress the RMan file during the backup (I am low on
> diskspace).

I smell pipes are in order.

> 3. How to break the backup into two pieces and specify a different
> location for both?

Well, if you are going to list each individual tablespace (or data file for that matter), then you could do something like:

run { ...
backup tablespace system format '/wherever/'; backup tablespace data format '/wherever2'; backup tablespace users format /u01/somewhereelse/again'; }

> I am not sure if the above are possible. Thanks for you help.
>
>
> Thanks,
>
> Michael
Received on Thu Aug 05 2004 - 22:45:26 CDT