- 01-17-2012 #1Junior Member
- Join Date
- 17 Jan 2012
how to restore a functional .dbf and control file from scratchHi,
Setup: Windows 2008 R2 64bit / ORACLE 11g XE
I have a corrupt ORACLE installation with a consistent database, which I cannot access anymore. sys/system passwords are known.
Can I backup/copy the files elsewhere and make a new ORACLE setup and restore the database?
Many thanks in advance for your support
- 01-17-2012 #2
Re: how to restore a functional .dbf and control file from scratchYou shouldn't need to copy the datafiles anywhere, simply install Oracle in a new home (preferably a fairly recent release) then use the database upgrade assistant to move the database from the old home to the new home. If you have a known good backup of the Oracle home you could restore that to return to a usable software installation then you should be able to start your database and carry on as if nothing had happened. Another option might be to reinstall the Oracle software that is now corrupted in the same Oracle home; I would copy that home to a different drive or to tape to preserve what you currently have before overwriting it. And yet another option is to use RMAN to backup your database files, install a new version of Oracle then restore and recover the database under the new software installation.
Take care with any of these options and always back up your database BEFORE beginning any work.David Fitzjarrell
- By infotech in forum Jobs BoardReplies: 1Last Post: 09-14-2010, 04:32 AM
- By dsub42 in forum Oracle DatabaseReplies: 10Last Post: 04-14-2010, 05:27 PM
- By anijan in forum Other Development ToolsReplies: 9Last Post: 03-10-2010, 07:11 AM
- By Netra1 in forum External Resources / Market PlaceReplies: 0Last Post: 03-08-2010, 06:01 PM
- By haraprasad in forum Security, Backup and RecoveryReplies: 1Last Post: 06-18-2009, 02:46 PM