Re: Stopping and Starting instances from batch (NT)

From: Matthias Gresz <GreMa_at_t-online.de>
Date: Fri, 26 Feb 1999 08:58:09 +0100
Message-ID: <36D65411.90AF1257@t-online.de>

Ken Rachynski schrieb:
>
> Good day,
>
> I'm having some difficulty trying to do cold backups of my Oracle8
> databases. I have two instances that I would like backed up. When I shut
> one down from my backup program, it shut down just fine, except that

Try:

Call server manager to run the SQL-script:

c:\programm\orant\bin\SVRMGR23.EXE @c:\cmd\sql\down_bac.sql

SQL-script would look like:

CONNECT <dba>/<pwd>
SHUTDOWN IMMEDIATE;
STARTUP RESTRICT; -- instance recovery

alter rollback segment rb1 SHRINK;
alter rollback segment rb2 SHRINK;
alter rollback segment rb3 SHRINK;
alter rollback segment rb4 SHRINK;
alter rollback segment rb5 SHRINK;
alter rollback segment rb6 SHRINK;
alter rollback segment rb7 SHRINK;
alter rollback segment rb8 SHRINK;
alter rollback segment rb9 SHRINK;
alter rollback segment rb10 SHRINK;
alter rollback segment rb11 SHRINK;
alter rollback segment rb12 SHRINK;
alter rollback segment rb13 SHRINK;
alter rollback segment rb14 SHRINK;

alter rollback segment rb15 SHRINK;
alter rollback segment rb16 SHRINK;
alter rollback segment rbbig SHRINK;

ALTER SYSTEM SWITCH LOGFILE;    -- number of logfiles in group times
ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;

ALTER DATABASE BACKUP CONTROLFILE TO TRACE; SHUTDOWN; Then run your backup. The cmd-file could also be run as the pre-job of your backup-software.

HTH
Matthias
--
grema_at_t-online.de

Es gibt nichts Neues mehr.
Alles, was man erfinden kann, ist schon erfunden worden. Charles H. Duell, Leiter des US Patentamtes bei seinem Rücktritt 1899 Received on Fri Feb 26 1999 - 01:58:09 CST