OraFAQ Forum: Backup & Recovery » Attaching DBF / ORA files to Oracle 10g express

Home » RDBMS Server » Backup & Recovery » Attaching DBF / ORA files to Oracle 10g express

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Attaching DBF / ORA files to Oracle 10g express [message #244131]

Mon, 11 June 2007 12:33

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

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?

Report message to a moderator

Re: Attaching DBF / ORA files to Oracle 10g express [message #244160 is a reply to message #244141]

Mon, 11 June 2007 14:59

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.

Report message to a moderator

Re: Attaching DBF / ORA files to Oracle 10g express [message #244168 is a reply to message #244160]

Mon, 11 June 2007 15:57

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.

Report message to a moderator

Re: Attaching DBF / ORA files to Oracle 10g express [message #244286 is a reply to message #244131]

Tue, 12 June 2007 04:38

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.

Report message to a moderator

Re: Attaching DBF / ORA files to Oracle 10g express [message #244302 is a reply to message #244286]

Tue, 12 June 2007 05:20

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The only way is export/import.

Regards
Michel

Report message to a moderator

Re: Attaching DBF / ORA files to Oracle 10g express [message #244394 is a reply to message #244302]

Tue, 12 June 2007 10:48

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

Report message to a moderator

Re: Attaching DBF / ORA files to Oracle 10g express [message #244789 is a reply to message #244131]

Thu, 14 June 2007 02:21

karenjones
Messages: 1
Registered: June 2007
Location: usa

Junior Member

Vertygo wrote on Mon, 11 June 2007 12:33

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

Report message to a moderator

Re: Attaching DBF / ORA files to Oracle 10g express [message #244817 is a reply to message #244789]

Thu, 14 June 2007 03:10

Vertygo
Messages: 4
Registered: June 2007
Location: Banjaluka

Junior Member

Thanks but have no credit card to buy their services Embarassed

Report message to a moderator

Previous Topic:	Tablaspace recovery
Next Topic:	System Change Number issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 17:31:35 CDT 2024