garden3.jpg

Mirror control files.


In this document we will mirror control file 01, thus keeping two
copies of this files in two different locations.

Disclaimer: Apply to a TEST environment first. Use on production systems is at
DBAs own risk.

When using spfile:

1) create pfile from spfile so you have the latest version of the spfile.
create pfile from spfile;
2) graceful shutdown the database (immediate, startup restrict open, shutdown normal)
3) copy the controlfiles to new location
cp /u01/oradata/emrep/control01.ctl /u02/oradata/emrep/control01.ctl
4) make changes in the pfile updating the control_files parameter.
5) startup the database.
startup pfile=’/u01/app/oracle/product/9.0.1/dbs/initEMREP.ora’
6) recreate the spfile using the command create spfile from pfile
create spfile from pfile
shutdown immediate
7) startup the database.
show parameter spfile and make sure it used the spfile
8)
show parameter control to verify control file location.

When not using spfile:

1) graceful shutdown the database (immediate, startup restrict open, shutdown normal)
2) copy the controlfiles to new location
cp /u01/oradata/emrep/control01.ctl /u02/oradata/emrep/control01.ctl
3) make changes in the pfile (initSID.ora) updating the control_files parameter.
4) startup the database.
startup

Latest Blog Items

email

Thank you for your interest in idbasolutions.

Contact us using this email: contact.us@idbasolutions.com