OraFAQ Forum: Backup & Recovery » How I can backup into Different Directory.

Home » RDBMS Server » Backup & Recovery » How I can backup into Different Directory.

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

How I can backup into Different Directory. [message #243849]

Sun, 10 June 2007 00:47

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

My backup file size is about 13 GB. But I have disk space in one directory is 10GB . In another directory about 9GB and in another directory about 8GB. whenever I want to make backup how I can distribute over several directory?

i use 10.2.0.2.0 enterprise edition.

Report message to a moderator

Re: How I can backup into Different Directory. [message #243853 is a reply to message #243849]

Sun, 10 June 2007 01:04

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

Senior Member
Account Moderator

Split your backup and use the format parameter or use the compress option.

Regards
Michel

Report message to a moderator

Re: How I can backup into Different Directory. [message #243857 is a reply to message #243849]

Sun, 10 June 2007 01:39

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Yes I use format Paramater but how I can split backup. Should I choice backup some datafiles in one directory and then again backup rest datafiles in another directory and then control files in another directory using format option?

Is there any way so that I can be able the full database backup at one time. Suppose I want after filled up one directory it will automatically fill up another directory and make the backup a totally one.

Report message to a moderator

Re: How I can backup into Different Directory. [message #243859 is a reply to message #243857]

Sun, 10 June 2007 02:34

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

Senior Member
Account Moderator

You have to use 3 backups statements, afaik.

Regards
Michel

[Updated on: Sun, 10 June 2007 02:41]

Report message to a moderator

Previous Topic:	How to Delete All Backups (merged)
Next Topic:	Backup Through EM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 00:54:22 CST 2024