Re: Backing up Oracle

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1998/05/26
Message-ID: <356b34c3.11874052@www.sigov.si>#1/1

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

>In article <356745F8.A5E8798F_at_deere.com>, jh33378nospam_at_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_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Tue May 26 1998 - 00:00:00 CDT