Re: batch file for oracle

From: Peter Winters <peterw_at_trinitysoftware.com.au>
Date: Tue, 18 Jan 2000 16:41:30 +1000
Message-ID: <newscache$clqiof$spk$1@news.iig.com.au>

svrmgr30 or svrmgrl will accept command-line arguments. Here is an NT example, which could be schedule via the AT service. It is broken into two part
1- The NT command file
2- The SQL Script run by svrmgr30

• NT COMMAND FILE *****

set ORACLE_SID=AURP
SVRMGR30 command=@E:\ORAAdmin\AURP\scripts\AURP_Shutdown.sql net stop 'OracleServiceAURP'
net stop 'OracleStartAURP'

• The above will then run AURP_Shutdown.sql ****

connect internal/ntoracle8i_at_AURP;
shutdown immediate;
startup restrict open pfile=E:\ORAAdmin\AURP\pfile\initAURP.ora; shutdown normal;
exit;

• The database AURP is now ready for an off-line backup ****

Regards
Peter Winters
System Frustrator
Trinity Software
CAIRNS Queensland AUSTRALIA
<marishen_at_my-deja.com> wrote in message news:860lat$b9d$1_at_nnrp1.deja.com...
> how do you write a batch file to stop and start the oracle engines at a
> specific time in order to backup the database, etc?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jan 18 2000 - 00:41:30 CST