Loss of all controlfiles
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Loss of all controlfiles

  1. #1
    Join Date
    Nov 2003
    Posts
    5

    Loss of all controlfiles

    Dear Friends,
    One of my client is using 8i database,and he lost all controlfiles of database and even don't have any backup of those.Even he do not know about location of datafiles,logfiles on hard-disk,so he is not able to recreate controlfile.Is there any method for recovering controlfile or get back the controlfiles.Pls do needful.

    Thanks
    Sunil Bhutani
    Sunil Bhutani

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

    If the database is still up and running.He can do

    alter database backup control file to trace..

    and please ask him to hire a DBA ;-)..I ama avaliable at a steep price ;-)

    regards
    Hrishy

  3. #3
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    How come the Database still up if they lost all controlfile(s).

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by hrishy
    and please ask him to hire a DBA ;-)..I ama avaliable at a steep price ;-)
    If you are able to make database keep running for a while even when all the controlfiles are gone, then you realy are worth every dollar of your sallary, no matter how much you get paid.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    So if the clueless friend, who "Even he do not know about location of datafiles,logfiles on hard-disk," what makes him so sure he's lost all of his control files? How would he know he's lost the control files, but not know where other files are located?

  6. #6
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Re: Loss of all controlfiles

    Originally posted by Sunil Bhutani
    Dear Friends,
    Even he do not know about location of datafiles,logfiles on hard-disk ,so he is not able to recreate controlfile.

    Thanks
    Sunil Bhutani

    What about the SERVER ..?
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  7. #7
    Join Date
    May 2001
    Posts
    736
    u say he is ur client and u doesn't keep the record of the database.Great what a consultency it is.

  8. #8
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Hmmm wonder if Ora Mag would start a humorous column and kick it off with this thread!
    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

  9. #9
    Join Date
    Nov 2003
    Posts
    5
    Dear Friends,

    Database is not open.
    My question was :
    Is it possible to create a controlfile, when one don't know about the location of datafiles,logfiles and even don't have any backup of controlfiles?

    Thanks
    Sunil
    Sunil Bhutani

  10. #10
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    in short 'NO'
    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