Corrupt SPFILE & no back up - now what?
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 21

Thread: Corrupt SPFILE & no back up - now what?

Hybrid View

  1. #1
    Join Date
    Nov 2004
    Posts
    2

    Corrupt SPFILE & no back up - now what?

    I am running 10G on Windows XP, I edited my SPFILE by mistake, and now I believe it is corrupt.

    The DB will not startup, all I can do is SQLPLUS /NOLOG.

    How can I start my DB back up?

    Thanks

    Daniel

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    create spfile from pfile;

    that is if you still have one around.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    Jul 2002
    Posts
    335
    Um, at least you know to take regular backups now

    I have to admit I fell foul of this when I did some tesing ages back, but at the moment we don't use spfiles in production.

    I guess someone may have a bright idea, I'm just wondering if you could recreate it manually using info from the alert log from the last time the database was started up, it should list all the non default parameters.

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    open it with wordpad and create pfile from it's contents to get you back in business
    I'm stmontgo and I approve of this message

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    why on earth would you edit an spfile, open it up and you see loads of junk at the top - isnt that enough to at least think about what you are doing

  6. #6
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    why on earth would you edit an spfile, open it up and you see loads of junk at the top - isnt that enough to at least think about what you are doing
    Yes it contains junks but it also coantains relevent parameters and their values (somewhere doen below)
    copy--> paste



    I'm just wondering if you could recreate it manually using info from the alert log from the last time the database was started up, it should list all the non default parameters.
    this also a good idea

    the best is, of course , if still have the init.ora...
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  7. #7
    Join Date
    Nov 2004
    Posts
    2
    Hi,

    Thanks for all your help.

    I ended up solving my problem by using another XP machine, installing 10G again with exactly the same folders and set up as my problem machine, I then copied over the SPFILE to the problem machine and it started working again.

    Daniel

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Originally posted by danielrc15
    Hi,

    Thanks for all your help.

    I ended up solving my problem by using another XP machine, installing 10G again with exactly the same folders and set up as my problem machine, I then copied over the SPFILE to the problem machine and it started working again.

    Daniel
    wow major overkill for such a simple thing

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Originally posted by simply_dba
    Yes it contains junks but it also coantains relevent parameters and their values (somewhere doen below)
    copy--> paste


    the best is, of course , if still have the init.ora...
    I know whats in it, my point was why anyone would go editting it when it clearly looks like it shouldnt be edited

  10. #10
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by danielrc15
    I ended up solving my problem by using another XP machine, installing 10G again with exactly the same folders and set up as my problem machine, I then copied over the SPFILE to the problem machine and it started working again.

    Daniel
    Absolute stupidity..
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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