Re: Backing up Oracle

From: Ralph G. Young <someone_at_somewhere.com>
Date: 1998/05/26
Message-ID: <6keho7$a0q$1@pulp.ucs.ualberta.ca>#1/1

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 Tue May 26 1998 - 00:00:00 CDT