how do I move orphan dbf to new database

[raygg]

I created a db from scratch and populated it with test data on an xp pro pc. The OS went bad and had to be reinstalled. Unfortunately I did not think to back up the db before the install. Therefore I had to reinstall the oracle xe db.

THe only thing I saved from the original oracle xe instance was the dbf files.

Of these the only one I need is the users.dbf. I tried doing a swap between the users.dbf in the new db instance and the orphaned users.dbf (now I call the old one users2.dbf) while the db was in mount. As soon as I opened the db and the db would not accept it - wrong db id on the file.

Tried resetlogs but that did not work.

Tried to force a recover database to allow the resetlogs to work but that was a nogo.

Any ideas? All I want to do is get the tables from the old dbf to the new db.

 

[Turkbear]

Hi,
Unless someone else can post a solution, I think you are out of luck - without a control file that 'knows' the header info etc. of the DBF file it is probably useless.






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[karluk]

If the dbf files from your old database include a control file, you are ok. You would simply replace the control files of the new db with the old control file and proceed with your recovery.

If you don't have any backup of the old control files, then you have made a serious (but not necessarily fatal) mistake. You would have to recreate the control file by manually putting together a "create controlfile reuse..." statement. Normally you would get the syntax for this command by executing an "alter database backup controlfile to trace resetlogs" but there's no reason you can't create it yourself.

I suggest you research this topic on support.oracle.com. Take a look at articles 735106.1 (How to Recreate a Controlfile) and 18070.1. Depending on your comfort level, you might also want to file a Service Request with Oracle Support.

 

[raygg]

Thanks karluk - I'll research that.