OraFAQ Forum: Backup & Recovery » Create a Backup and Restore "Tablespace"

Home » RDBMS Server » Backup & Recovery » Create a Backup and Restore "Tablespace" (9 and above)

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

Create a Backup and Restore "Tablespace" [message #407784]

Thu, 11 June 2009 10:32

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

Mahesh Rajendran
Messages: 10708
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.

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

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

BlackSwan
Messages: 26766
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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 03 15:25:41 CDT 2025