Re: Lost oracle database but have the datafiles

I copied the datafiles after I did a shutdown of the server. Then I rebooted the machine. Then today the harddrive crashed.

So I have a clean copy of the datafile. I installed Oracle on another machine and I wanted to move those file to the new installation but I have no idea on how to do it.

The other machine oracle was on is dead until I can replace the drive.

but the new machine is good to go.

Thanks.

On Sun, 30 Dec 2001 19:46:59 GMT, "koert54" <koert54_at_nospam.com> wrote:

>
>how did you backup those datafiles ?????
>even if you didn't backup controlfiles and redolog you'll be able to open
>the DB
>if you first did a shutdown other than abort and then copied the datafiles
>....
>
>1. copy the datafiles back to your drive
>2. recreate the controlfile (check the create controlfile command)
>3. open the database using resetlogs
>
>"Kev" <java2e_at_yahoo.com> wrote in message
>news:l1ru2uk66fa4ci1bb2gjl44rve2ajadqbl_at_4ax.com...
>> Hello Howard,
>>
>> Here is the problem. I completely lost my harddrive but before I did
>> about a day ago I saved the datafiles, no idea of why I did it. And
>> about 1 week ago I did a export of the schema I care about.
>>
>> What I need to do is jsut get one table out of the datafile and the
>> rest I dont care about.
>>
>> I might be abot to get the control files but not the arcive or redos.
>>
>> I can run the import to create the structure but I need to pull the
>> data from the datafiles if this is at all possible.
>>
>> Thanks,
>>
>> Kev
>>
>> On Mon, 31 Dec 2001 06:29:12 +1100, "Howard J. Rogers"
>> <dba_at_hjrdba.com> wrote:
>>
>> >Kev,
>> >
>> >Your post is not entirely clear... Do you have the datafiles as your post
>> >title suggests, or do you merely have an export file as your post
>contents
>> >suggests?
>> >
>> >If you have the datafiles themselves, do you have a control file as well?
>> >And do you have archives? Because if that's all true, then you can
>perform
>> >a standard incomplete recovery and get all your data back, except for the
>> >last little bit that was in the current online redo log.
>> >
>> >If all you've got is the export file, then you'll have to create a brand
>new
>> >database from scratch, and run import to get the data back as it was at
>the
>> >time you took the export. The easiest way to proceed in that eventuality
>> >would be to manually create all the right tablespaces (and users), and
>then
>> >leave import to create all the tables, indexes and so on, and populate
>them.
>> >
>> >Regards
>> >HJR
>>
>
Received on Sun Dec 30 2001 - 13:47:32 CST