Home » RDBMS Server » Server Utilities » Backup through Batch file. (11g)
Backup through Batch file. [message #507808] Wed, 18 May 2011 01:57 Go to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,
exp system/abc@c file=c:\dmp_%date%.dmp log=c:\log.txt owner=xyz


I run this script through batch file its working.Problem is dump file showing with this format C:\dmp_wed.dmp.I want to date format like that C:\dmp_18052011.dmp.

Please help me for date formatting.How I can add date format in a batch file.

Regards,
Irfan
Re: Backup through Batch file. [message #507819 is a reply to message #507808] Wed, 18 May 2011 02:38 Go to previous messageGo to next message
Michel Cadot
Messages: 58847
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ export is NOT a backup
2/ There are many scripts in "Utilities" forum (where this topic should be and not in "Backup" one) that depends on your OS and shell. Search for them.

Regards
Michel
Re: Backup through Batch file. [message #507821 is a reply to message #507819] Wed, 18 May 2011 02:42 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Ok.
Thank you for prompt reply.
Re: Backup through Batch file. [message #507837 is a reply to message #507821] Wed, 18 May 2011 03:46 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,
My problem solved pls read this link.
http://www.minasi.com/forum/topic.asp?TOPIC_ID=37283

Regards,
Irfan
Re: Backup through Batch file. [message #507842 is a reply to message #507837] Wed, 18 May 2011 03:56 Go to previous messageGo to next message
Littlefoot
Messages: 19469
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As Michel said, the solution is only a few clicks away, on this very OraFAQ forum. There are other suggestions, but only if you search for them.
Re: Backup through Batch file. [message #507843 is a reply to message #507837] Wed, 18 May 2011 03:58 Go to previous message
Michel Cadot
Messages: 58847
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So your OS is Windows, you'd find the same thing here and in our "Windows" forum.
Next time, provide your OS name and version, and Oracle one as well, with 4 decimals

Regards
Michel
Previous Topic: Missing objects during datapump import
Next Topic: Data Migration using Datapump
Goto Forum:
  


Current Time: Wed Aug 20 19:41:14 CDT 2014

Total time taken to generate the page: 0.10120 seconds