Home » RDBMS Server » Backup & Recovery » Create a Backup and Restore "Tablespace" (9 and above)
Create a Backup and Restore "Tablespace" [message #407784] Thu, 11 June 2009 10:32 Go to next message
orapmj
Messages: 2
Registered: June 2009
Junior Member
Hi

I am new to Oracle. I have a task to find out how to take a backup of a tablespace with the associated user and recover that backup later. I have been surfing quite a lot and am not able to come to a solution. Please help me in this. Thanks
Re: Create a Backup and Restore "Tablespace" [message #407786 is a reply to message #407784] Thu, 11 June 2009 10:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It depends on your exact Oracle versions, tools and methods you are willing to employ or your folks would support, volume of data.
Check dba_obects. You can map the users and tablespaces which hold their objects.
Backup specific tablespaces with a separate policy using RMAN.
Re: Create a Backup and Restore "Tablespace" [message #407788 is a reply to message #407786] Thu, 11 June 2009 10:48 Go to previous messageGo to next message
orapmj
Messages: 2
Registered: June 2009
Junior Member
Hi,

Its is that my clients can have database version which starts from 9i onwards.
Re: Create a Backup and Restore "Tablespace" [message #407790 is a reply to message #407784] Thu, 11 June 2009 11:00 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B10501_01/server.920/a96519/toc.htm

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/toc.htm

http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/part_int.htm#sthref12
Re: Create a Backup and Restore "Tablespace" [message #407865 is a reply to message #407790] Fri, 12 June 2009 01:18 Go to previous message
brillix
Messages: 6
Registered: June 2009
Junior Member
Usually backups are in the scope of the entire database.
BUT RMAN can let you backup and restore specific tablespace (After you have taken base backup of the entire database).

Look here for some RMAN scripts - http://www.dbsnaps.com/articles/ora_rman_script/

My recommendation to you is backup and restore the entire database in cases you need only some of the data go for export/import and import only corrupted data.

Oded

[Updated on: Fri, 12 June 2009 01:31] by Moderator

Report message to a moderator

Previous Topic: offline
Next Topic: Recovering Corrupt Redolog
Goto Forum:
  


Current Time: Fri Dec 09 23:01:28 CST 2016

Total time taken to generate the page: 0.13147 seconds