on 01-19-2010 4:34 PM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.