Re: startup and shutdown.....

Jurij Modic (jurij.modic_at_mf.sigov.mail.si) wrote:
: On Tue, 01 Jul 1997 11:09:47 -0700, "V.K. Sundaresan"
: <sundarvk_at_ntserver1.photodisc.com> wrote:
 

: >Hi all,
: >We have a web commerce system that has Oracle 7.3.2 as backend.
: >
: >My Question is :
: >When we need to take down the system, we run the dbshut and it waits
: >there
: >till all the users logged out.
: >
: >So we decided to write a batch script that gets into svrmgr
: >and execute
: >
: >> connect internal
: >> shutdown immediate
: >> startup .................? Do I have to go to mount stage or open stage
 for oracle to recover
: >> shutdown normal
: >
: >I would like to get an insight on what you think?
: >
 

: You don't need STARTUP -> SHUTDOWN NORMAL after you shut down the DB
: in IMMEDIATE mode because Oracle won't perform any instance recovery
<snip>

I beg to differ back in version 7.2, it was stated by oracle that the best way to do get the database shutdown was to do a shutdown immediate followed by a startup and a shutdown normal. It then leaves the database in a clean state for off-line backups. That is the best policy.

Joe

-- 
BDJoseph S. Testa, Database Administrator, Ohio EPA
  IRCop on Atlantis.sorcery.net, If your gonna IRC anywhere make it
    Sorcery.net, find out about IRC and sorcery.net at www.sorcery.net
  Look for me, I run the #oracle and #oracle-dba channels.