Re: Interesting topic in linked in
Date: Sat, 9 Mar 2013 16:34:07 -0300
Message-ID: <CAJ2dSGR9S=CpYLTERCgsTe_tw4bo=D-DH6ykRPrL1L2Uy9SrKQ_at_mail.gmail.com>
This is just off the top of my head... and it probably won't work. But you could create a blank DB and then recreate the controlfile including all the DFs from the other DB. The DB Name should be the same, and I don't know if you can force a DB ID at database creation, otherwise it might not be possible. Or if you can change the dbid of the other datafiles. An SR with Oracle would be ideal, they've helped me with some weird recovery scenarios with hot copies of the DFs without enabling backup mode and stuff like that.
I'll add this to the next DRE we perform...
Also, while updating the resume is a sound advice, I would suggest that if asscovering is required he look into the reason for there not being a backup. I've often found that the reason for most unrecoverable databases are manages who don't want to "waste" money or storage in backups.
hth
Alan.-
On Sat, Mar 9, 2013 at 4:21 PM, Andrew Kerber <andrew.kerber_at_gmail.com>wrote:
> Someone on LinkedIn is asking how to start the db when system01.dbf is
> missing and there is no backup. Interesting topic, but for the life of me
> I can't think how it can be done. There are some suggestions on how to
> retrieve the data.
>
> My own suggestion was to update the resume, but I am curious if anyone has
> ever managed to do this, and if so, how?
>
>
> Sent from my iPad--
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Mar 09 2013 - 20:34:07 CET