Re: Backup

Since this is a 'bat' file you are looking for, I'm assuming a Windoze platform. In that case, the commands are:

1. net stop OracleServiceSID
2. copy c:\oracle\oradata\SID\*.* c:\oracle\oradata\SID\Backup\*.*
3. net start OracleServiceSID

I highly urge you to heed Daniel's advice and read the Oracle docs and other materials as knowing only the above is only the tip of the ice berg.

HTh,
Brian

Loinex wrote:
>
> I have been asigned for a server maintenance, with Oracle 8 installed...
>
> I know that for making backup I need to do a sort of bat file that stops
> Oracle, copy relevant files to another location and restart Oracle...
>
> What are the commands ?
>
> TIA

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"