Oracle RMAN Pocket Reference

Backing Up a Tablespace

The ability to specify only a subset of tablespaces in a backup operation can add flexibility to your backup strategy. For Oracle9i, the syntax can be fairly simple:

RMAN> backup tablespace system, users format
2> '/d99/rmanback/brdstn/rman_bckup_%d_%t_%U.bus';

Once again, note that with Oracle8i, the syntax is a bit different with respect to the run{} command:

RMAN> run {
2> allocate channel d1 type disk;
3> backup format
4> '/d99/rmanback/brdstn/rman_bckup_%d_%t_%U.bus'
5>
 tablespace system, users include current controlfile;
6> }