Re: HOW AUTOMATE EXPORT & BACKUP ?

<ouldmoh_at_yahoo.com> wrote in message news:8dp8ip$rnh$1_at_nnrp1.deja.com...
> Hello,
>
> First: please excuse my english.
>
> Second: I want to create a file containing some shell instructions
> which automate export and then backup the database each days.
> It must contains the following:
> 1) from anwhere connect to the database server (locally).
> 2) make su - oracle then I give it:
> a) username
> b) password
> 3) export database (at this step I well be asked exp file...?, in
> reponse
> I hit
> on Enter button).
> 4) Save the database (in order to locate the last backup of
> database the file must contain Year/days/Hour of saving, e.g.
> MySaveFile_2000/04/22H:30mn.dmp).
> I need all this in a file which can to be run automaticly
> each days for example at 00:00. The script must be able to
> search automaticaly $HOME_ORACLE from /etc/oratab.
>

I used to have this problem:
1. I wrote an Access program to generate an exp80-command-line with a time-stamped dmp file name. Note this program should be executable in a background process of NT4, ie, it can run without logging in the server. 2. Alternatively, if you can tolerate a weekly cycle, it'll be much easier. You can just schedule 5 tasks to run exp80 with different dmp file names. 3. As for the scheduler, AT command and IE5 task scheduler work. I believe an Oracle script can also do it, but I am always looking for the easiest way.
Hope this helps.

Dino Received on Sat Apr 22 2000 - 00:00:00 CDT