Re: Query Database while shutdown in progress

I know 1 team that manage sun system they shutdown the system using "sync; sync; init 6;" and already have been like that for few years oracle is invisible to them. Power Ranger :)

On 6/28/07, Elliott, Patrick <patrick.elliott_at_medtronic.com> wrote:
>
>
> I do SHUTDOWN ABORT all the time, and I haven't seen corruption caused
> by it since probably Oracle 7. It is best to issue the "ALTER SYSTEM
> CHECKPOINT" command first, but this may not be possible if the database
> is hung. I have seen many situations where a SHUTDOWN IMMEDIATE simply
> would not complete.
>
>
> Pat
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Don Seiler
> Sent: Wednesday, June 27, 2007 2:56 PM
> To: oracle-l
> Subject: Re: Query Database while shutdown in progress
>
> In all the docs I read for 10g (read: certification prep guides),
> shutdown abort is still treated like a leper. I'm pretty surprised by
> this thread so far.
>
> Don.
>
> On 6/27/07, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:
> >
> > The last time I checked, admittedly in the 8.1.7 world, oracle stated
> > that you could end up with file corruption on a shutdown abort (note
> > that is could, not would, I never had it happen), If they have
> > changed this and now say that a shutdown abort is as safe as a
> > shutdown immediate, I have not heard it. Does anyone have a statement
> from oracle to that effect?
>
> --
> Don Seiler
> oracle blog: http://ora.seiler.us
> ultimate: http://www.mufc.us
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
> ___________________________________________________________________________________________________
> CONFIDENTIALITY AND PRIVACY NOTICE
> Information transmitted by this email is proprietary to Medtronic and is
> intended for use only by the individual or entity to which it is addressed,
> and may contain information that is private, privileged, confidential or
> exempt from disclosure under applicable law. If you are not the intended
> recipient or it appears that this mail has been forwarded to you without
> proper authority, you are notified that any use or dissemination of this
> information in any manner is strictly prohibited. In such cases, please
> delete this mail from your records.
>
> To view this notice in other languages you can either select the following
> link or manually copy and paste the link into the address bar of a web
> browser: http://emaildisclaimer.medtronic.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
regards,

Sinardy

--
http://www.freelists.org/webpage/oracle-l