This discussion is archived
4 Replies Latest reply: Dec 7, 2012 7:34 AM by mseberg RSS

RMAN selective backup

937144 Newbie
Currently Being Moderated
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.

Regards,
Adrian
  • 1. Re: RMAN selective backup
    mseberg Guru
    Currently Being Moderated
    Hello;

    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.

    Best Regards

    mseberg

    Edited by: mseberg on Dec 7, 2012 8:18 AM
  • 2. Re: RMAN selective backup
    937144 Newbie
    Currently Being Moderated
    Does this apply to my first question as well?
  • 3. Re: RMAN selective backup
    Levi-Pereira Guru
    Currently Being Moderated
    Adi Pruna wrote:
    Does this apply to my first question as well?
    Yes.

    Note:

    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.
  • 4. Re: RMAN selective backup
    mseberg Guru
    Currently Being Moderated
    Hello again;

    Sorry for the delay.

    Yes it does.

    Best Regards

    mseberg

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points