Home » RDBMS Server » Backup & Recovery » Attaching DBF / ORA files to Oracle 10g express
icon5.gif  Attaching DBF / ORA files to Oracle 10g express [message #244131] Mon, 11 June 2007 12:33 Go to next message
Vertygo
Messages: 4
Registered: June 2007
Location: Banjaluka
Junior Member
Hi,
I have Oracle 10g Express and I want to attach/restore database. I`m begginer in oracle so I know little about process of restoring/attaching databases. I have only DBF/ORA files, is it possible to restore them and how?
Any help appreciated.

Thanks,
Ivan.

[Updated on: Mon, 11 June 2007 12:40]

Report message to a moderator

Re: Attaching DBF / ORA files to Oracle 10g express [message #244141 is a reply to message #244131] Mon, 11 June 2007 13:29 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
What do you mean by Attached??

From which version to which version you want to restore?
Re: Attaching DBF / ORA files to Oracle 10g express [message #244160 is a reply to message #244141] Mon, 11 June 2007 14:59 Go to previous messageGo to next message
Vertygo
Messages: 4
Registered: June 2007
Location: Banjaluka
Junior Member
Well I`m comming from MS SQL and there if you have .mdf file you can attach database, if you have .bak file you can restore database. So I`m not sure what does it mean if I have .dbf file .. can I restore or attach database ...

Thanks,
Ivan.
Re: Attaching DBF / ORA files to Oracle 10g express [message #244168 is a reply to message #244160] Mon, 11 June 2007 15:57 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
not only .DBF you must need controlfiles...redologs files..pfile/spfile...password file.
if you have all thses files then you can run your database.
Re: Attaching DBF / ORA files to Oracle 10g express [message #244286 is a reply to message #244131] Tue, 12 June 2007 04:38 Go to previous messageGo to next message
Vertygo
Messages: 4
Registered: June 2007
Location: Banjaluka
Junior Member
Can you give me info/link on how to backup oracle 8.x database and how to restore it on oracle express 10g ?
What utility for managing Oracle database to use?
(restoring/creating database)

Thanks alot.
Re: Attaching DBF / ORA files to Oracle 10g express [message #244302 is a reply to message #244286] Tue, 12 June 2007 05:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The only way is export/import.

Regards
Michel
Re: Attaching DBF / ORA files to Oracle 10g express [message #244394 is a reply to message #244302] Tue, 12 June 2007 10:48 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
Can you give me info/link on how to backup oracle 8.x database and how to restore it on oracle express 10g ?


Its not possible.
you can do that on same versions.

go with micheal advice
Re: Attaching DBF / ORA files to Oracle 10g express [message #244789 is a reply to message #244131] Thu, 14 June 2007 02:21 Go to previous messageGo to next message
karenjones
Messages: 1
Registered: June 2007
Location: usa
Junior Member
Vertygo wrote on Mon, 11 June 2007 12:33
Hi,
I have Oracle 10g Express and I want to attach/restore database. I`m begginer in oracle so I know little about process of restoring/attaching databases. I have only DBF/ORA files, is it possible to restore them and how?
Any help appreciated.

Thanks,
Ivan.


hi,

me 2 is a student fo computer sceinces an these days workin on assignment on oracle database administration so often search on net to gte some help in preparing the asigmnt regarding oracle database administration, few days back i found www.oracleplace.com which help me alot not only in makin my assinment but also gave much more ifo of oracle's other application

hop it could help u 2 in finding the solution of ur problm.

good luk

karenjones
icon10.gif  Re: Attaching DBF / ORA files to Oracle 10g express [message #244817 is a reply to message #244789] Thu, 14 June 2007 03:10 Go to previous message
Vertygo
Messages: 4
Registered: June 2007
Location: Banjaluka
Junior Member
Thanks but have no credit card to buy their services Embarassed
Previous Topic: Tablaspace recovery
Next Topic: System Change Number issue
Goto Forum:
  


Current Time: Mon Dec 05 13:02:42 CST 2016

Total time taken to generate the page: 0.14318 seconds