Oracle Database Discussions

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!

How restour just only tablespace from backup piece to another node

819348Nov 29 2010 — edited Nov 29 2010

Hello ,
I'm testing the political backup/restore .

I have hot backup with RMAN of database every day , but I would like to restore this database (with the backup pieces) on another host, but I want to restore just one tablespace, without considering the undo, system and sysaux tablespaces.

This database is RAC, but I want bring database open on single instance on another node using ASM.

I woul like restore the tablespace system, sysaux, undotbs1 and arsystem, after that i want to bring database open.
I want to read/write the tablespace arsystem.

Best regards

João Paulo Spaulonci
jpspaulonci@hotmail.com
joaospaulonci@gmail.com

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 27 2010

Added on Nov 29 2010

#general-database-discussions

8 comments

286 views