Re: Shutdown from OS Batch File (NT40), and Backup

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/12/17
Message-ID: <678g6u$u0a$1@news00.btx.dtag.de>#1/1

Hi Svein-Egil,

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');

-- 
Regards

Matthias Gresz    :-)

Svein-Egil Pettersen wrote:


> 

> Hello!

> Does anyone know how to make an OS Batchjob to shutdown

> the DB before backup, and then start the DB after

> Backup. I am using Cheyenne Arcserve backup SW. Cheyenne

> has the possibility to do 'Before backup job' and

> 'After Backup job' in the backup task.

> This shutdown and startup has to go without any

> user action. This is a fullvolum backup job of all

> partitions and all disks.

> Perhaps even an export before backup starts.

> 

> Any tips/Ideas

> Config:         Oracle 7.3.3 (NT)

>                 Enterprise Manager 1.4

>                 Win NT 4.0 Server

>                 12 GB Disks

> 

> Regards

> 

> Svein-Egil Pettersen   Email #1: svpett_at_online.no

> Joh-Data AS            Email #2: svpett_at_ibm.net

> Oslo, Norway           Email #3: 100445,1527(Compuserve)

Received on Wed Dec 17 1997 - 00:00:00 CST