The Oracle (tm) Users' Co-Operative FAQ

How Do I Recover From Loss of a Member of a Multiplexed Control File?


Author's name: Allan W. Tham

Author's Email: allanwtham@hotmail.com

Date written: Mar 5 2002

Oracle version(s): 8.1.7.0.0

I multiplexed my control files yet one of them get corrupted. How do I recover from it?

Back to index of questions


Scenario 1 : Disk and filesystem is intact

In this case, there is no need to modify any setting in init.ora. Simply copy a good controlfile to the location of the bad controlfile.

1. Shutdown abort
2. Copy good controlfile to original location of bad controlfile:- cp /path/blah_good.ctl /path/blah_bad.ctl
3. Startup

Scenario 2 : Disk and filesystem is no good

1. Shutdown abort
2. Copy good controlfile to a new location:- cp /path/blah_good.ctl /new_good_path/blah.ctl
3. Change the CONTROL_FILES param in init.ora to reflect the new good path
4. Startup

 

Further reading: Oracle9i User-Managed Backup and Recovery Guide


Back to top

Back to index of questions