How to import a DBF file?

Backup, Recover, Import, Export, Datapump, etc
Post Reply
Prosillo
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 3
Joined: Wed, 28 Oct 2009 9:21 am
Location: Campinas
Contact:

I am a beginner with Oracle and I am in the following situation:

I have a problem on a client, where the server was pro space, and the last scheduled backup became corrupted, would have how I copy the DBF from the server, move to another machine and try to export and "re-import" again as soon as the server returns from the maintenance?

Is this possible?


Environment information:
* Oracle version: 10g
* Operating system: Win 2000 Server
miltonbastos
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 22
Joined: Tue, 19 May 2009 12:40 pm
Location: Curitiba - PR

No colleague, this is not possible!

DBF is Oracle Datafile, and you can not recover a base only with a DBF file, Oracle is much more complex than this.

has to be backed up, always!
Prosillo
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 3
Joined: Wed, 28 Oct 2009 9:21 am
Location: Campinas
Contact:

Poutz ...

Thanks for the answer!
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

I could try to install Oracle in the same structure in the SO, and create a bank by pointing the same datafiles for the ancient paths (DBFS) and then lower the instance and copy the old over, as far as I knew it worked ...
Prosillo
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 3
Joined: Wed, 28 Oct 2009 9:21 am
Location: Campinas
Contact:

Hehehe ... That's what I'm testing now!
Even so good! :)
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

At the end you need to re-create the password file,

orapwd in the $ oracle_home / dbs,

good luck,
wrogati
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Thu, 17 Oct 2013 4:30 pm

Diego,

I have the same problem, I have a .dbf file and several other but create the database all in the same old standard and when overlap the tablespace file the bench stops working.

Do you have any other alternative?
How do you re-create the password file?

Att,
Wellington Rogati
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 2 guests