As mentioned in the question is:
OS windows
Oracle Ver: 10.1.0.5.0
by mistake user deleted the registry and uninstall the oracle software from OS. but he took the backup of original database files (redo.control.datafile)
the database was up and running while he deleted all registry and uninstall oracle software via Oracle Universal Installer.
Not in the particular case but also we can re-build database if we have intact original database files.
the following steps will be helpful
1. Install Oracle software
2. Install any patchset or cpu ( same as before uninstalled)
3. create oracle services via ORADIM ( SID should be same as original database SID)
4. create password files
5. create pfile ( with the required parameters) You can create one dummy database and take the pfile from that database for reference.
6. create the needful directories ( like oradata/admin/bdump/udump/cdump) etc
7. restore original database files from backup to oradata folder
NOTE: It is better if file structure should be same as before uninstall otherwise we need to change the location of controlfiles then relocate redolog and datafiles to the new locations
8. connect to the idle instance with created pfile
9. start database in steps ( to that we can verify and change locations of the files (if required)
10. startup nomount
11. alter database mount
12. alter database open
if you can open successful then write me email at askdbataj
2 comments:
Your point is valueble for me. Thanks!
My site:
dsl anbieter vergleich dslvergleichdsl.com
Your blog is excellent ...
Thanks for sharing with us.
Prachi
HCL
Post a Comment