Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Wednesday, September 7, 2011

Exclude tablespace in a backup

For example, you can exclude testing tablespaces cwmlite and example from whole
database backups as follows:
CONFIGURE EXCLUDE FOR TABLESPACE DATA_01;
CONFIGURE EXCLUDE FOR TABLESPACE INDEX_01;
BACKUP DATABASE;

If you run the above command, then RMAN backs up all tablespaces in the database except DATA_01 and INDEX_01:

No comments: