From: jurij.modic@mf.sigov.mail.si (Jurij Modic)
Subject: Re: Backing up Oracle
Date: 1998/05/26
Message-ID: <356b34c3.11874052@www.sigov.si>#1/1
References: <3564C6C6.B3681E35@skypie.sp.trw.com> <35657445.20377487@news.dircon.co.uk> <3565AE3A.66ABBF9F@bgs.ac.uk> <356745F8.A5E8798F@deere.com> <6keho7$a0q$1@pulp.ucs.ualberta.ca>
Organization: Ministry of Finance, Republic of Slovenia
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server



On 26 May 1998 13:57:27 GMT, someone@somewhere.com (Ralph G. Young)
wrote:

>In article <356745F8.A5E8798F@deere.com>, jh33378nospam@deere.com says...
>>
>>I am not aware that this will provide any benefit. Can you elaborate?
>>
>>Peter Lewis wrote:
>>
>>> Once all the rollback has finished and the "shutdown immediate" completes
>>> you should really consider including in your script a "startup mount"
>>> followed by a "shutdown normal". This will leave your database clean and
>>> tidy and ready for copies to be taken of all your database files and log
>>> files.
>
>Oracle states...
>
>"The backup should be taken with the database shutdown cleanly.  If you must 
>use SHUTDOWN IMMEDIATE or SHUTDOWN ABORT to force users off the system, be
>sure to restart the database in restricted mode, then shut it down with
>normal priority."

This is documentation bug (in some earlier releases of Oracle7
manuals). For offline backup the database must be shutdown cleanly,
and for this purpose SHUTDOWN NORMAL and SHUTDOWN IMMEDIATE are
*totaly* equivalent!

As far as sugested sequence SHUTDOWN IMMEDIATE - STARTUP MOUNT -
SHUTDOWN NORMAL is concerned, everything after SHUTDOWN IMMEDIATE is
pure waste of time, especialy because STARTUP MOUNT won't even touch
the database and log files (so what's the purpose?),

>Ralph

Regards,
============================================================
Jurij Modic                             Republic of Slovenia
jurij.modic@mf.sigov.mail.si		Ministry of Finance
============================================================
The above opinions are mine and do not represent any official 
standpoints of my employer