Home » RDBMS Server » Backup & Recovery » rman backup instance and tablespace (oracle 11.2.0.3.0 on Solaris10)
rman backup instance and tablespace [message #582489] Thu, 18 April 2013 14:34 Go to next message
zeeshan047
Messages: 62
Registered: June 2010
Location: PAKISTAN
Member

hi,
we are using dataware house of huge amount of data I want to take backup using rman so that I restore oracle instance and specific tablespace only not full database






Re: rman backup instance and tablespace [message #582491 is a reply to message #582489] Thu, 18 April 2013 14:51 Go to previous messageGo to next message
Michel Cadot
Messages: 59739
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't see where is the question.

Regards
Michel
Re: rman backup instance and tablespace [message #582498 is a reply to message #582491] Thu, 18 April 2013 16:59 Go to previous messageGo to next message
BlackSwan
Messages: 23026
Registered: January 2009
Senior Member
RMAN backup can not be used to restore specific tablespace.
Re: rman backup instance and tablespace [message #582514 is a reply to message #582498] Fri, 19 April 2013 00:58 Go to previous messageGo to next message
zeeshan047
Messages: 62
Registered: June 2010
Location: PAKISTAN
Member

Actually we have some tablespaces containing source data, we need to backup using rman only these specific tablespace as size of data warehouse is large 40 TB we have limited space.
My question is can we backup using rman of the specific tablespace only(like system, users ,undotbs excluding user1 tablespace so that we can restore it in case of instance crash and up the instance in case of any disaster.

Thanks
Re: rman backup instance and tablespace [message #582517 is a reply to message #582514] Fri, 19 April 2013 01:16 Go to previous message
Michel Cadot
Messages: 59739
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
can we backup using rman of the specific tablespace only


Yes: BACKUP TABLESPACE ...

Quote:
so that we can restore it in case of instance crash and up the instance in case of any disaster


Yes.

Regards
Michel
Previous Topic: ISSUE WITH shutting down database
Next Topic: backup all datafiles only using RMAN
Goto Forum:
  


Current Time: Fri Nov 21 18:21:17 CST 2014

Total time taken to generate the page: 0.27892 seconds