Recovering 10g database
687127Feb 24 2009 — edited Feb 25 2009I am running oracle 10g standard edition on an XP Pro system.
All was installed and working well, until XP became infected by a virus. This required a complete reinstall of XP. I now have the system back up and running.
Oracle has gone and needs to be reinstalled (although the original files are still there). The database files are all intact (all 20GB of them). I have a backup of the data but it is over 1 month old.
Is there any way I can (re)install Oracle 10g BUT ask it to recognise and reconnect to the existing oracle database files? I would like to point the new instance of Oracle to the exisintg USERxx.DBF datafiles to recover the data.
Cheers,
Mark