Home » RDBMS Server » Backup & Recovery » RMAN tablespace backup and restore (11gr2 LINUX)
RMAN tablespace backup and restore [message #565878] Fri, 07 September 2012 13:30 Go to next message
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?
Re: RMAN tablespace backup and restore [message #565879 is a reply to message #565878] Fri, 07 September 2012 13:36 Go to previous messageGo to next message
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;
Re: RMAN tablespace backup and restore [message #565880 is a reply to message #565879] Fri, 07 September 2012 13:43 Go to previous messageGo to next message
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
Re: RMAN tablespace backup and restore [message #565881 is a reply to message #565879] Fri, 07 September 2012 13:46 Go to previous messageGo to next message
John Watson
Messages: 8922
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
Re: RMAN tablespace backup and restore [message #565882 is a reply to message #565880] Fri, 07 September 2012 13:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I would use expdp & impdp
Re: RMAN tablespace backup and restore [message #565883 is a reply to message #565882] Fri, 07 September 2012 13:54 Go to previous messageGo to next message
chandu208
Messages: 17
Registered: July 2012
Junior Member
yeah but datapump is not working
Re: RMAN tablespace backup and restore [message #565884 is a reply to message #565883] Fri, 07 September 2012 13:57 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
transportable tablespaces
Previous Topic: error with RMAN utility
Next Topic: RMAN not removing backups
Goto Forum:
  


Current Time: Thu Mar 28 09:44:49 CDT 2024