Results 1 to 8 of 8

Thread: Script for performing clean shutdown before windows shutdown

  1. #1
    Join Date
    Jul 2005
    Posts
    35

    Script for performing clean shutdown before windows shutdown

    Hi all,
    I need a script to perform a clean oracle shutdown every time that windows going to shutdown.I need this to be sure that there wont be any instance recovery every time I startup the oracle(Mostly I fear from header inconsistency and ...).
    Is there any thing that I can deploy for my development sites?
    -Your help will be so appreciated

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    What version of Oracle are you using?. Unlike Oracle 8.x, in Oracle 9.x shutting down Windows does SHUTDOWN IMMEDIATE.

    Instance recovery happens at startup even if you manually shutdown the database, Oracle may not have to do any roll forward but it still needs to check it.

  3. #3
    Join Date
    Jul 2005
    Posts
    35
    Thanks,
    I am using 10g R1.Where is the documetation that says:
    in Oracle 9.x shutting down Windows does SHUTDOWN IMMEDIATE.
    I do not have any problem with oracle startup checks,I want to sleep without the fear of not matching headers in datafiles!
    -Regards

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    Look for ORA_SID_SHUTDOWNTYPE value in HKLM - Software - Oracle - Home for the current value, by default it is i for immediate.

  5. #5
    Join Date
    Jul 2005
    Posts
    35
    Excuse me to repeat this more and more,but:
    Is that registry value can ensure me,It will be cleanely shutdown oracle?
    If yes then why there are a lot of "instance recovery" entries in alert.log(You have mentioned it is default)?
    I startup oracle,then shutdown windows(Nothing done: any DML or ...) but there is still fair amount of "instance recovery" entries.
    -Thanks

  6. #6
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    Oracle will be shutdown with IMMEDIATE clause. We use it and have no issues with it.

    Post the Instance Recovery messages.

  7. #7
    Join Date
    Sep 2005
    Posts
    9
    Hi,

    Try using the oracle administration assistant for windows.
    you can select the option for shutting down the instance using the immediate mode when the service is stopped. using shutdown immediate shouldn't usually pose problems. Instance recovery is not carried out on startup.

    vikram

  8. #8
    Join Date
    Sep 2005
    Posts
    9
    Hi,

    Look for the ora_sid_shutdowntype key. If the value is a change it to i.
    Oracle 9i uses immediate as the default mode.

    Try performing a shutdown abort and a shutdown immediate.
    Obviously abort is quicker, so u can guess which mode is being used by default.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •