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

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

  1. #11
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Originally posted by abhaysk
    Absolute stupidity..
    And you wonder why companies don't do a more through check on the people whom they trust to run the heart beat of the company.

    You know, I really don't know if having people who know nothing about Oracle database administration being in such a position is good for us (the people who know wtf they're doing). If it will hurt us in the long run or benifit us (at least financially)?
    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

  2. #12
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    I think some of you are being a bit over critical, the poster does'nt claim to be an expert or running this on behalf of a company so why the attack. Sure thier way of solving the problem was not perfect but "absolute stupidity" I think not!

    Remeber all of us have to start somewhere and all of us at some time have overworked a solution.

    And to be fair it is running on Windoz where basically the answer to most problems is to reinstall
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #13
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    I know whats in it, my point was why anyone would go editting it when it clearly looks like it shouldnt be edited
    It was not the question of editing the spfile .Rather copying parameters from it and creating a new pfile since the spfile was not working
    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

  4. #14
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333

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

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

    Daniel
    he edited it, he wasnt copying contents from it - he was editing it, which is stupidity as it clearly shouldnt be edited

    Read what is written next time

  5. #15
    Join Date
    Jul 2002
    Posts
    335

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

    Originally posted by davey23uk
    he edited it, he wasnt copying contents from it - he was editing it, which is stupidity as it clearly shouldnt be edited

    Read what is written next time
    I may be way off the mark here (its been a while since I played with SPfiles) but isn't it possible to corrupt them if you alter a parameter online and do a typo on the parameter value whilst doing it?

    Apologies in advance if I'm talking crap.

  6. #16
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333

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

    Originally posted by bazza
    I may be way off the mark here (its been a while since I played with SPfiles) but isn't it possible to corrupt them if you alter a parameter online and do a typo on the parameter value whilst doing it?

    Apologies in advance if I'm talking crap.
    Think here we are talking about editing the actual file, perfectly possible to corrupt it then

    No, not possible to corrupt it using alter system = ... as any invalid parameter wont be written to the file.

    although you can make it so your instance doesnt start that way - but the file itself is still valid

  7. #17
    Join Date
    Jul 2002
    Posts
    335

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

    Originally posted by davey23uk
    Think here we are talking about editing the actual file, perfectly possible to corrupt it then

    No, not possible to corrupt it using alter system = ... as any invalid parameter wont be written to the file.

    although you can make it so your instance doesnt start that way - but the file itself is still valid
    Right fair enough, I was a tad hazy on that. Better rtfm if I ever use a SPFILE

  8. #18
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    Originally posted by stmontgo
    open it with wordpad and create pfile from it's contents to get you back in business


    he edited it, he wasnt copying contents from it - he was editing it, which is stupidity as it clearly shouldnt be edited
    Read what is written next time
    He edited it alright.
    It was stupidity alright.
    But he has already done it and the talk was going on how to create pfile from a busted spfile.

    You should read the posts and not only the mesgs
    Last edited by simply_dba; 11-26-2004 at 08:36 AM.
    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

  9. #19
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Originally posted by simply_dba
    He edited it alright.
    It was stupidity alright.
    But he has already done it and the talk was going on how to create pfile from a busted spfile.

    You should read the posts and not only the mesgs

    YOU replied to MY posts about him being stupid - which were nothing to do about recovering the file, therefore you were questioning what I had said

  10. #20
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    YOU replied to MY posts about him being stupid - which were nothing to do about recovering the file, therefore you were questioning what I had said
    No I wasn't .I just gave an idea to recreate the pfile from the spfile.Does that make u angry?
    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

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