ERROR, type: CONTROL_FILE_MIRROR

[Former Member]

Hi!

After system copy of SAP ERP system with oracle via oracle backup/restore the DB13 check retrieves the following error:

ERROR, type: CONTROL_FILE_MIRROR, object: E:\ORACLE\GT6\102\DATABASE\CTL1<sid>.ORA

What are the action to solve this problem?

When I edit the init<DBSID>.ora and add there the parameter control_files this setting will be diappeared after restart the db.

Thank you!

[Former Member]

This condition checks whether there are control files that are not mirrored on the Oracle side.

you have to mirror the control file in 3 different areas for safety .

( EXAMPLE : /origlogA/cntrl/cntrlSID.dbf','/oracle/SID/origlogB/cntrl/cntrlSID.dbf','/oracle/SID/sapdata1/cntrl/cntrlSID.dbf')

Assuming you are using SPFILE for your DB

Kindly create a pfile from spfile . ->Create spfile from pfile

make a copy of your pfile

Make the entries for controlfile locations in the PFILE created

shutdown the db and app

Copy the control files to the mirror locations indicated in the PFILE

Start the DB using pfile -> startup nomount pfile=' location'

Create spfile from pfile

shutdown the DB

Startup normally

Gerard

Edited by: GerardChristopher on Jan 19, 2010 7:16 PM

Edited by: GerardChristopher on Jan 19, 2010 7:17 PM