Skip to Content
avatar image
Former Member

ERROR, type: CONTROL_FILE_MIRROR

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 19, 2010 at 06:15 PM

    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

    Add comment
    10|10000 characters needed characters exceeded