I have the following questions from one of our partners.
For Oracle database version 11g R2:
Q1: is RMAN capable of backing up a single partition of a database ?
Q2: is RMAN capable of backing up a single partition of a single table ?
I know that RMAN can backup a single table, but I could not find anything regarding partitions. Also any documentation you may have on will help alot.
Adi Pruna wrote:
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.