OraFAQ Forum: Backup & Recovery » Backup of Tablespaces

Home » RDBMS Server » Backup & Recovery » Backup of Tablespaces (RHEL 4, Oracle 9.2)

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

Backup of Tablespaces [message #319102]

Fri, 09 May 2008 01:32

myana.srinivas1
Messages: 9
Registered: April 2008
Location: India

Junior Member

Hi all,
I have 50 tablespaces in my database.
Now, i am planning to take backup of all these tablespaces using a single statement(not using scripts).
I wanna know if that is possible.. if yes, please let me know

Report message to a moderator

Re: Backup of Tablespaces [message #319108 is a reply to message #319102]

Fri, 09 May 2008 01:46

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is not possible.

By the way, a single statement IS a script as soon as you put it in a file.

Regards
Michel

Report message to a moderator

Re: Backup of Tablespaces [message #319272 is a reply to message #319102]

Fri, 09 May 2008 09:39

ebrian
Messages: 2794
Registered: April 2006

Senior Member

myana.srinivas1 wrote on Fri, 09 May 2008 02:32

I have 50 tablespaces in my database.
Now, i am planning to take backup of all these tablespaces using a single statement(not using scripts).

What type of requirement is that?

What is wrong with simply backup database [plus archivelog]; with RMAN?

Report message to a moderator

Re: Backup of Tablespaces [message #319273 is a reply to message #319102]

Fri, 09 May 2008 09:44

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Actually it is possible to say:
backup tablespace 'tbs1','tbs2','tbs3'...;

Regards
Michel

Report message to a moderator

Re: Backup of Tablespaces [message #319279 is a reply to message #319273]

Fri, 09 May 2008 10:04

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Sure, but why ? Just a rhetorical question, these crazy requirements are impossible to comprehend.

Report message to a moderator

Previous Topic:	Loss of redo-log files
Next Topic:	Backup Database v Tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 20:17:18 CST 2025