Home » RDBMS Server » Backup & Recovery » Backup of Tablespaces (RHEL 4, Oracle 9.2)
Backup of Tablespaces [message #319102] Fri, 09 May 2008 01:32 Go to next message
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

Re: Backup of Tablespaces [message #319108 is a reply to message #319102] Fri, 09 May 2008 01:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Backup of Tablespaces [message #319272 is a reply to message #319102] Fri, 09 May 2008 09:39 Go to previous messageGo to next message
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?
Re: Backup of Tablespaces [message #319273 is a reply to message #319102] Fri, 09 May 2008 09:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Actually it is possible to say:
backup tablespace 'tbs1','tbs2','tbs3'...;

Regards
Michel
Re: Backup of Tablespaces [message #319279 is a reply to message #319273] Fri, 09 May 2008 10:04 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Sure, but why ? Just a rhetorical question, these crazy requirements are impossible to comprehend.
Previous Topic: Loss of redo-log files
Next Topic: Backup Database v Tablespace
Goto Forum:
  


Current Time: Sat Dec 03 11:54:57 CST 2016

Total time taken to generate the page: 0.06680 seconds