Re: Stopping Oracle Instance on NT ?

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1998/02/16
Message-ID: <69v6ao$3g5$1@news01.btx.dtag.de>#1/1

Hi Christophe,

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 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 END BACKDown.CMD

REM EXP_FULL.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 END EXP_FULL.CMD REM DOWN_BAC.CMD
c:\...\orant\bin\SVRMGR23.EXE @c:\....\down_bac.sql REM END DOWN_BAC.CMD 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 END DWON_BAC.SQL 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');

Hope this helps

Christophe wrote:
>
> Do I stop the database in a correct way when I just stop the
> OracleServiceOrcl-service in NT 4 ?
>
> I would like to do that for a full backup.
>
> Thanks for any reply !
 

-- 
Regards

Matthias Gresz    :-)

Received on Mon Feb 16 1998 - 00:00:00 CST