Re: shutdown for backup : pro's and con's

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Fri, 08 Dec 2000 08:43:05 -0500
Message-Id: <10704.124002@fatcity.com>

how about a variation on a theme,
alter system checkpoint
SHUTDOWN ABORT
STARTUP RESTRICT
SHUTDOWN NORMAL
<BACKUP>

joe

thats that i use in a non0terminal based script.

Pat Howe - Contractor wrote:
>
> I would like to be convinced one way or the other on the following issue :
> What is the best way to take a database down for a cold backup ?
>
> SHUTDOWN ABORT
> STARTUP RESTRICT
> SHUTDOWN NORMAL
> <BACKUP>
>
>

-- 
Joe Testa  http://www.oracle-dba.com
No you can't fix an ORA-600 error, call Oracle Support.

Received on Fri Dec 08 2000 - 07:43:05 CST