DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: urgent wanna do a startup force

  1. #1
    Join Date
    Jan 2001
    Posts
    2,828

    Question

    hi folks

    i have given this command on NT

    svrngr>shutdown

    its taking ages to shutdown

    should i do a
    svrmgr>startup force

    i dont want to lose any data i am in no archive log mode on nt running oarcle 8.0.5 kindly advise on the repercussions of my action if i do that

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    force a checkpoint then shutdown abort then startup again then shutdown normal then startup again

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    i am not able to connect to oracle it says oracle is shutting down .can i implement your suggestion when database is shutting down and when i am unable 2 connect.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well even itīs shutting down you can cancel the shutdown process if you connect as internal

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    hi pando

    what are the commands for doing that

    svrmgr>connect internal
    svrmgr> password :*****
    svrmgr>connected
    now what

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828

    Cool

    hey thanks pando i solved the problem but still want to know what exactly does this command mean startup force is it same as saying shutdown abort when my databse is not shutting down .lokin for an answer

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well i have never used startup force, if the shutdown is too slow I simply do what I mentioned in previous message.
    I guess startup force is something similar but instead of you executing 3 or 4 commands it does in one, I am NOT sure because I have never used it. I am pretty sure that command is explained in Oracle Documentations, I have read it somewhere before...

  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    STARTUP FORCE = SHUTDOWN ABORT + STARTUP
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  9. #9
    Join Date
    Jan 2001
    Posts
    2,828

    Angry

    hi folks

    i had given shutdown and oracle took an inordinately long time 2 shutdown .when i tried to connect it refused connection saying that it was shutting down .and thats when i did a startup force and i was able to to bounce back the database without losing any data.but my question is why didnt i lose data.coz i always thought

    startup force=shutdown abort+startup


  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Oracle does instance recovery automatically and shutdown abort is an instance failure

Posting Permissions

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


Click Here to Expand Forum to Full Width