-
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
-
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
-
How come the Database still up if they lost all controlfile(s).
-
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?
-
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?
-
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 ..?
-
u say he is ur client and u doesn't keep the record of the database.Great what a consultency it is.
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|