Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Exclude a tablespace in rman backup

user13148231Jan 30 2012 — edited Jan 31 2012

Data Guard with primary and physical standby both on Oracle 11.2.0.1 on redhat 5.2. I am to duplicate the primary to the standby. The primary has an offline tablespace and I want exclude it from the data guard. Using RMAN to make backup like

BACKUP DEVICE TYPE DISK FORMAT '/u01/flash/dg/%d_%U' DATABASE PLUS ARCHIVELOG;

Questions
1) How to make RMAN report what source objects (files, tablespaces) to be included in the backup command before perform a real backup?
2) How can I make the command exclude the offline tablespace I do not want to copy?

Thanks

This post has been answered by Andy Klock on Jan 30 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 28 2012

Added on Jan 30 2012

#performance-availability, #recovery-manager-rman

8 comments

1,263 views