Printable View
I am using oracle 11g XE
My server hard disc crashed yesteday and i don't have any backups
I am able to recover the .dbf by using a recovery tool
is it possible to use this .dbf into new server and recover my data
please help me to solve this issue ?
thanx in advance
How many archive logs do you have? Do you have the online redo logs? Have you done any research into recovery techniques? You should be able to recreate the control files, but you need redo to being the database to a consistent state.
thanx 4ur reply
I don't have any archive or redo logs
I have all .dbf files nothing else
please help me to resolve this issue
Unless the .dbf files are from a cold backup, you don't have a database. It might be time to start over. Only this time look into having the databases in archive log mode and find a script for doing Hot RMAN backups. Then test backing up the database and doing restores of the database. Until you practice the recovery, you will never be certain that the backup is any good.