Database Reference
In-Depth Information
Use the EXCLUDE command to instruct RMAN as to which tablespaces not to back up:
RMAN> configure exclude for tablespace users;
Now, for any database-level backups, RMAN will exclude the data files associated with the USERS tablespace.
You can instruct RMAN to back up all data files and any excluded tablespaces with this command:
RMAN> backup database noexclude;
You can clear the exclude setting via the following command:
RMAN> configure exclude for tablespace users clear;
Backing Up Data Files Not Backed Up
Suppose you have just added several data files to your database, and you want to ensure that you have a backup of
them. You can issue the following command to instruct Oracle to back up data files that have not yet been backed up:
RMAN> backup database not backed up;
You can also specify a time range for such files that have not yet been backed up. Say you discover that your
backups have not been running for the last several days, and you want to back up everything that hasn't been backed
up within the last 24 hours. The following command backs up all data files that have not been backed up within the
last day:
RMAN> backup database not backed up since time='sysdate-1';
The prior command is also useful if, for any reason (a power failure in the data center, your backup directory's
becoming full during backups, and so on), your backups aborted. After you have resolved the issue that caused your
backup job to fail, you can issue the previous command, and RMAN will back up only the data files that have not been
backed up in the specified time period.
Skipping Read-Only Tablespaces
Because data in read-only tablespaces can't change, you may only want to back up read-only tablespaces once and
then skip them in subsequent backups. Use the SKIP READONLY command to achieve this:
RMAN> backup database skip readonly;
Keep in mind that when you skip read-only tablespaces, you'll need to keep available a backup that contains
these tablespaces. As long as you only issue the RMAN command DELETE OBSOLETE , the RMAN backup set containing
the read-only tablespaces will be retained and not deleted, even if that RMAN backup set contains other read-write
tablespaces.
 
Search WWH ::




Custom Search