Home » Infrastructure » Windows » automatic imp/exp (Database,10.2.0.3,Windows server 2003)
automatic imp/exp [message #349643] Mon, 22 September 2008 08:29 Go to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member

Hello,

I have a bit of a coding problem. We're working on a dev server and the backup method we use at this stage is a normal export of the schema on which the developments are made. After every major dev, a dump is made. Now management wants to automate the export and schedule it every 9PM. Haven't done that that way before. Can anyone help me?

Thanks in advance.
Re: automatic imp/exp [message #349648 is a reply to message #349643] Mon, 22 September 2008 08:58 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
export is NOT a database backup strategy.

You can use Windows scheduler to do this.

Regards
Michel
Re: automatic imp/exp [message #349656 is a reply to message #349648] Mon, 22 September 2008 09:26 Go to previous messageGo to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
Michel Cadot wrote on Mon, 22 September 2008 08:58
export is NOT a database backup strategy.

Thank you for correcting me. Can we call it a backup method?

Thanks for the tip.But how do we do that on LINUX?

[Updated on: Mon, 22 September 2008 09:53]

Report message to a moderator

Re: automatic imp/exp [message #349670 is a reply to message #349656] Mon, 22 September 2008 10:36 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
abdulaziz wrote on Mon, 22 September 2008 16:26
Michel Cadot wrote on Mon, 22 September 2008 08:58
export is NOT a database backup strategy.

Thank you for correcting me. Can we call it a backup method?

Thanks for the tip.But how do we do that on LINUX?

1/ You can call it a logical backup or a data backup keeping in mind that you can only restore what you saved, that is some data at the backup date.

2/ Why do you want to know how to do it on Linux when you said you are working on Windows?

Regards
Michel

[Updated on: Mon, 22 September 2008 10:37]

Report message to a moderator

Re: automatic imp/exp [message #349818 is a reply to message #349670] Tue, 23 September 2008 03:58 Go to previous messageGo to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
1/ Go for "data backup" then.

2/ You know what they say: "Prevention is better than cure".We never know...I might need to do it someday on Linux. In addition, I have a db on my laptop that runs on Linux(RHEL4), and every new thing I do on Windows, I try and repeat it on Linux.I can put automatic import in practice the same way, so when the time comes, I am ready. Besides, That'd be a plus in my knowledge.

So do you know how to do it in Linux?
Re: automatic imp/exp [message #349822 is a reply to message #349818] Tue, 23 September 2008 04:02 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use "cron", native Unix/Libnux scheduler.

Regards
Michel
Re: automatic imp/exp [message #349848 is a reply to message #349822] Tue, 23 September 2008 04:54 Go to previous message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
Thank you for the tip. Let me look into it. Thanks again.
Previous Topic: how to find used rows and used coloumns via ole
Next Topic: TNS-12560 during installation
Goto Forum:
  


Current Time: Tue Oct 21 23:58:32 CDT 2014

Total time taken to generate the page: 0.11971 seconds