Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stopping and Starting instances from batch (NT)
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 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;
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