25
Jul
06

How to shutdown oracle if the server is too slow on windows

If for some reasons a server is very slow and the shutdown immediate command can be expected to take ages…

Go for the kill of the Oracle Service in control panel>configuration>services

Find OracleService[OracleSID] and stop it.

Shutting down Oracle by stopping the Oracle service makes a clean stop of the database as opposed to shutdown abort which must be avoided at all costs.

Shutting down with an abort can create fuzzy files which is all DBA’s nightmare.

Advertisements

5 Responses to “How to shutdown oracle if the server is too slow on windows”


  1. 1 Enzo
    August 9, 2006 at 5:40 pm

    Shutdown abort doesn’t create “fuzzy files”. Who told you this crap?

    Shutdown abort is perfectly fine to do anytime you want.

    All transactions that have been committed exist in the redo logs. If all committed transactions exist, then there is zero issue. Learn Oracle architecture.

    When you startup after a shutdown abort, the instance will do crash recovery and roll forward. If you db is configured properly, this will happen in a few seconds.

  2. August 10, 2006 at 1:59 am

    Ok let me put it a better way.

    Shutdown abort gives a chance to create “fuzzy files”.
    I would not recommand it to my customers nor would you. Is it?

    As for the crash recovery if any issue fine. But still, I would prefer to have the people administrating my db user better ways of shutting it down.

    I think the service remains the best way in that case.

  3. August 10, 2006 at 2:10 am

    Also Enzo,

    I’m quite happy to have you around since you are my first comment!

    However, I want that place to be an open space of discussions with good manners.

    If you feel something is wrong, simply correct it but keep the tone informative, not bashing.

    That’s what’s great with blogs. People need an information, they found it. Something is wrong in there?
    It has been corrected by one of the readers! The noob coming around for info would get the news and the comments all in one.

    Bashing tone brings people on defense stance and no conversation is possible because it turns into a ping pong game.

    If a comment is not suitable, I might need to erase it or modify it to be more suitable.

    I don’t pretend to be the king of DBA’s with this blog. But I expect to help people having problems I’ve encoutered before.

    Read the “who am I” page to get more information on my experience.

  4. 4 Jack
    January 29, 2008 at 1:52 am

    It does create fuzzy files.
    You can not use the files and recreate the controlfile and do an open reset logs. It will complain that recovery is needed. Files are fuzzy.

    You are right in that Oracle will open w/o problems after a shutdown abort, but if you loose a redo log between shutdown abort and startup you are stuffed unless you go into underscore parameters.

    Jack

  5. 5 Joseph
    May 8, 2009 at 3:46 pm

    I started alter database open resetlogs. It is siiting there very long time as it uses virtual memory a lot. Can i shutdown abort, reduce amount of SGA and do once more startup mount and alter database open resetlogs?


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: