![]() ![]() If possible, restore the control file to its original location. Restoring a Backup Control File to the Default Location Start a new instance and mount and open the database. Then, you can edit it as follows: CONTROL_FILES='/oracle/oradata/trgt/control01.dbf','/new_disk/control02.dbf' Assume the initialization parameter file contains: CONTROL_FILES='/oracle/oradata/trgt/control01.dbf','/bad_disk/control02.dbf' For example, to copy a good version of control01.dbf to a new disk location you might issue: % cp $ORACLE_HOME/oradata/trgt/control01.dbf /new_disk/control01.dbfĮdit the parameter file of the database so that the CONTROL_FILES parameter reflects the current locations of all control files and excludes all control files that were not restored. If you cannot correct the hardware problem that caused the media failure, then copy the intact control file to alternative locations. To restore a control file to a nondefault location: In this case, you must alter the CONTROL_FILES initialization parameter to indicate a new location for the missing control file. For example, enter: STARTUPĬopying a Multiplexed Control File to a Nondefault LocationĪssuming that the disk and file system containing the lost control file are not intact, then you cannot copy one of the good control files to the location of the missing control file. For example, to replace bad_cf.f with good_cf.f, you might enter: % cp /oracle/good_cf.f /oracle/dbs/bad_cf.f Use an intact multiplexed copy of the database's current control file to copy over the damaged control files. ![]() If you cannot repair the hardware problem quickly, then proceed with database recovery by restoring damaged control files to an alternative storage device, as described in "Copying a Multiplexed Control File to a Nondefault Location". If the instance is still running, then shut it down: SHUTDOWN ABORTĬorrect the hardware problem that caused the media failure. To replace a damaged control file by copying a multiplexed control file: In this case, you do not have to alter the CONTROL_FILES initialization parameter setting. If the disk and file system containing the lost control file are intact, then you can simply copy one of the intact control files to the location of the missing control file. Copying a Multiplexed Control File to a Default Location ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |