Home » RDBMS Server » Backup & Recovery » Read *.dbf and *.log
icon5.gif  Read *.dbf and *.log [message #268738] Wed, 19 September 2007 09:23 Go to next message
gendut_boyx
Messages: 2
Registered: September 2007
Junior Member
I'm sorry if this thread is repost
and I'm sorry also if my english is bad

I have problem here
I have reinstall my computer operating system
but I forget to doing export procedure for backup
that computer I use for testing my project using PHP-Oracle 10g
I have input around 200 record data for testing
The oracle data I install in different partition, so file *.dbf and *.log is save
The problem is I don't know how to read the record data now.

I hope anybody in this forum can help me
I need this data as soon as posibble
Thanks...
Re: Read *.dbf and *.log [message #268752 is a reply to message #268738] Wed, 19 September 2007 10:38 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Do you have all data files ,control file, redo log files???
Re: Read *.dbf and *.log [message #268830 is a reply to message #268752] Wed, 19 September 2007 20:02 Go to previous messageGo to next message
gendut_boyx
Messages: 2
Registered: September 2007
Junior Member
Yes I'm
Last night I try to install new Oracle 10g
and create new same name DB
then I try to paste the old data, control, and log file
into the new DB
then I try start ora service
I think the redo03.log make the sistem crash

Is there any solution
thanks for reply
Re: Read *.dbf and *.log [message #268837 is a reply to message #268738] Wed, 19 September 2007 22:03 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

After creating database you wanted to post data files. It is not possible. If you have all the necessary files of the database, then first set the oracle_sid and then through sqlplus as sysdba perform startup by initialize parameter. If you have same directory structure as previous then further action is not necessary.
Previous Topic: preparing test server using production server RMAN hot backup
Next Topic: oracle 9i RAC on Solaris
Goto Forum:
  


Current Time: Sat Dec 14 13:12:10 CST 2024