Re: Backing up Oracle on Netware server

In article <4lomr8$o6h_at_frazier.uoknor.edu>, pdensmore_at_oklaosf.state.ok.us says...
>
>
>In article <4lnbmk$1l_at_crick.bms.com>, <DMARQU_at_usccmail.bms.com>
>writes:
>>
>> I am trying to automate or batch my Oracle exports on a netware 3.1
>> server. I have tried this using by executing an NCF file with the
>> following three load commands in it from the remote console prompt.
 The
>> results were not satisfactory.
>>
>> load sqldba command="file with shut down script"
>> load exp parfile="file with parameters"
>> load sqldba command="file with startup script"
>>
>> Any suggestions?
>>
>I am experiencing the same situation, however in a NW 4.1
>environment. How does one get SQLDBA to execute commands from a *.ncf
>file?
>
>Thanks for any suggestions.

    We use third party scheduler for netware called "Merlin". At some appropriate time ( in the middle of the night ) we use it to kick off the export. Merlin has its own scripting language which we use to create date based filenames for the exports, delete old export files etc. The Merlin scripting language allows you to execute the "Load ..." commands from within it.
  Incidentally, the database must be up to do an export so we do not shut the database down for an 'export'. You can use the consistent=Y parameter in the export parameter file to get a "consistent" export.   To backup the database files, we use merlin to first shutdown the database using "load sqldba ...(sqldba shutdown script)". Once the database
is down the database files are backed up by another third party backup tool "arcserve". We then restart the database using another merlin script.

• Amit