Re: "Thou shalt use 'Shutdown Abort' whenever you shutdown the database." Makes sense?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/05/04
Message-ID: <336d8a3f.1184503@newshost>#1/1

On 4 May 1997 04:57:36 GMT, beatonb_at_cadvision.com (Bill Beaton) wrote:

>
>In article <337dd193.2328728624_at_203.12.176.153>,
> gedau_at_mim.com.au (George Dau) writes:
>
>>
>>
>>]I would recommend that they use a shutdown immediate, or if they must
>>]shutdown abort, at least start the database backup and then shutdown
 [snip]
>>
>>I think Thomas ment ... start the database back up and then shutdown normal,
>>then start the database backup ...

YES, sorry bout that, backup != back up. I meant back up as in, start the database again so it can process redo and rollback to make everything consistent.

the following sequence spells is out and does it so no one else can sneak in when you 'bounce' the database.

>Actually, I'd recommend the sequence:
>shutdown immediate;
>startup restrict;
>shutdown normal;
>

[snip]

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun May 04 1997 - 00:00:00 CDT