This content has been marked as final. Show 4 replies
With RMAN you can individually backup tablespaces. Or you can do individual datafiles.
I believe the answer is no to partitions.
Quote "You cannot use TSPITR to recover tablespaces containing any of the following objects - partitioned tables
Source - Database Backup and Recovery User's Guide 11g Release 2 (11.2) E10642-03
You can restore and recover datafile or tablespace in RMAN but not table. You cannot backup just a table will RMAN.
Depending upon your need, Data Pump may provide the solution you need. The INCLUDE parameter filters objects on an export.
Edited by: mseberg on Dec 7, 2012 8:18 AM
Adi Pruna wrote:Yes.
Does this apply to my first question as well?
If you have a Big Table or whatever you have a option to store only this table on specific Tablespace. Then you can issue on rman "BACKUP TABLESPACE <tbs_name>;"
This way you will be performing a Backup of Tablespaces as this tablespace have only one table, you will backup a specific table only.
If you need to restore only this table (I mean Tablespace) you can use Incomplete Restore feature of RMAN by cloning or restoring excluding all tablespace except the tablespace which is stored your table.
Second option is to use DATA PUMP ( slow to backup/restore) as mentioned by mseberg.