Re: Batch file for startup database on NT 3.51, 4.0

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1998/01/15
Message-ID: <69krib$7al$1@news02.btx.dtag.de>#1/1

Hi,

this is what I posted to Svein-Egil Pettersen hwo had a most similar problem:

we use NT4 with Arcserve 6.
'before backup job' will be a command file named 'BACKDOWN.CMD'. 'After Backup job' will be 'STARTUP.CMD'.

REM BACKDown.CMD

REM Making full export
call c:\...\cmd\exp_full.cmd

REM Copying export out of RAID
copy D:\dbf\dump f:\dump

REM Shutting down
call c:\cmd\down_bac.cmd

REM Copying control-dump out of RAID
copy c:\...\orant\rdbms73\trace\control f:\control

REM Copying archived redo-logs out of RAID call c:\...\cmd\cop_arch.cmd

REM EXP_FILL.CMD c:\...\orant\bin\exp73.exe <dba>/<pwd> file=d:\dbf\dump\exp.dmp full=y log=d:\dbf\dump\log.txt >> d:\dbf\dump\exp.log REM Must say nobody is connected at this time since shop closes 20:00h.

REM DOWN_BAC.CMD
c:\...\orant\bin\SVRMGR23.EXE @c:\....\down_bac.sql

REM DWON_BAC.SQL CONNECT <dba>/<pwd>
SHUTDOWN IMMEDIATE;
STARTUP RESTRICT;

ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;

ALTER DATABASE BACKUP CONTROLFILE TO TRACE; SHUTDOWN; REM STARTUP.CMD
c:\...\orant\bin\SVRMGR23.EXE @c:\....\down_bac.sql

REM STARTUP.SQL
connect <dba>/<pwd>
startup
set termout off
--filling data buffers
select * from <BlahBlah>;
--keeping some packages in cache

EXECUTE SYS.DBMS_SHARED_POOL.KEEP('SYS.STANDARD');
EXECUTE SYS.DBMS_SHARED_POOL.KEEP('SYS.DBMS_STANDARD');
EXECUTE SYS.DBMS_SHARED_POOL.KEEP('SYS.DBMS_UTILITY');
EXECUTE SYS.DBMS_SHARED_POOL.KEEP('SYS.DBMS_DESCRIBE');
EXECUTE SYS.DBMS_SHARED_POOL.KEEP('SYS.PIDL');
EXECUTE SYS.DBMS_SHARED_POOL.KEEP('SYS.DIANA');
EXECUTE SYS.DBMS_SHARED_POOL.KEEP('SYS.DIUTIL');
EXECUTE SYS.DBMS_SHARED_POOL.KEEP('<BlahBlah');

Yuttana wrote:

>
> Dear Oracle Gurus :
>
> I'm new users for Oracle NT.
>
> I've Oracle 7.2 on NT 3.51, if i want to use batch file
> for startup/shutdown database how can i do its ???
>
> ==========================
> Yuttana Santi
> yuttana_at_siamcity.co.th
> ==========================
 

-- 
Regards

Matthias Gresz    :-)

Received on Thu Jan 15 1998 - 00:00:00 CST