Members   Search   Help    Register    Login   Home
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
Report message to a moderator
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: 9777
Registered: March 2002
Location: oracleDocoVille
Senior Member
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.
Report message to a moderator
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.
Report message to a moderator
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: 3227
Registered: January 2009
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
Report message to a moderator
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 8 23:44:29 CST 2009

Total time taken to generate the page: 0.01385 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.