Re: Backing up Oracle

According to Oracle..... Shutdown immediate is leaving the database in a good clean state. You do not have to restart and shutdown normal.

John Jones
DB Basics, Inc.
http://www.dbbasics.com

Ralph G. Young wrote in message <6keho7$a0q$1_at_pulp.ucs.ualberta.ca>...
>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.
>>>
>>> Hope this is of help to you
>>>
>>> Peter Lewis
>>
>>
>>
>
>
>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."
>
>
>Ralph
>
Received on Wed May 27 1998 - 00:00:00 CDT