OraFAQ Forum: Backup & Recovery » RMAN tablespace backup and restore

Home » RDBMS Server » Backup & Recovery » RMAN tablespace backup and restore (11gr2 LINUX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN tablespace backup and restore [message #565878]

Fri, 07 September 2012 13:30

chandu208
Messages: 17
Registered: July 2012

Junior Member

i want to clone the test db to dev db but i dont want default users and tablespaces(SYS,SYSAUX,...) in the test db datapump and exp are not working, then contacted ORACLE support and they concluded that test db sysaux was corrupted.

i took RMAN all tablespace bkup except default tablespaces. then created new database using DBCA and now i want to restore and recover all those test db tablesapces but while i'm doing restore its saying

RMAN> restore tablespace MAIN_DATA;

Starting restore at 07-SEP-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=129 device type=DISK

creating datafile file number=20 name=/opt/oracle/oradata/DEV71/main_data01.dbf
restore not done; all files read only, offline, or already restored
Finished restore at 07-SEP-12

i created all tablespaces in dev same as test db, can any one help me doing this?

Report message to a moderator

Re: RMAN tablespace backup and restore [message #565879 is a reply to message #565878]

Fri, 07 September 2012 13:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

what is your aversion to the SYSTEM & SYSAUX tablespaces; since that is where needed objects reside?

why don't you just from test instance do as below?
RMAN> DUPLICATE DATABASE;

Report message to a moderator

Re: RMAN tablespace backup and restore [message #565880 is a reply to message #565879]

Fri, 07 September 2012 13:43

chandu208
Messages: 17
Registered: July 2012

Junior Member

Oracle support people said some of the obejcts or something is invalid in it so we planned to move the database to another database.
i think if we do Duplicate database whole db will come including (sys and sysaux) but except these i need all remaining

Report message to a moderator

Re: RMAN tablespace backup and restore [message #565881 is a reply to message #565879]

Fri, 07 September 2012 13:46

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

If you don't want to duplicate the database (why not?) you probably want to use tablespace transport:
http://docs.oracle.com/cd/E11882_01/server.112/e25494/tspaces013.htm

Report message to a moderator