OraFAQ Forum: Backup & Recovery » rman backup instance and tablespace

Home » RDBMS Server » Backup & Recovery » rman backup instance and tablespace (oracle 11.2.0.3.0 on Solaris10)

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

rman backup instance and tablespace [message #582489]

Thu, 18 April 2013 14:34

zeeshan047
Messages: 99
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

Report message to a moderator

Re: rman backup instance and tablespace [message #582491 is a reply to message #582489]

Thu, 18 April 2013 14:51

Michel Cadot
Messages: 68165
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I don't see where is the question.

Regards
Michel

Report message to a moderator

Re: rman backup instance and tablespace [message #582498 is a reply to message #582491]

Thu, 18 April 2013 16:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

RMAN backup can not be used to restore specific tablespace.

Report message to a moderator

Re: rman backup instance and tablespace [message #582514 is a reply to message #582498]

Fri, 19 April 2013 00:58

zeeshan047
Messages: 99
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

Report message to a moderator

Re: rman backup instance and tablespace [message #582517 is a reply to message #582514]

Fri, 19 April 2013 01:16

Michel Cadot
Messages: 68165
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

Report message to a moderator

Previous Topic:	ISSUE WITH shutting down database
Next Topic:	backup all datafiles only using RMAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 19 16:33:22 CDT 2022