How to multiplex control files?

Control file is small binary file that describes the structure of database.It must be available when database is mounted or opened.                                                                                                  To protect against database failures its necessary task to multiplex control files as well as to keep redo log files as a group.Best practice is to maintain one copy on each disk group for automatic storage management (such as +DATA  and +FRA) and for file system storage each copy on separate disk is maintained.                                                                                            Control files are multiplexed using following syntax:                                                                  >shutdown immediate                                                                                                                              >startup nomount;                                                                                                                                    >alter system set control_files=’/u01/app/oracle/oradata/orcl/control01.ctl’,                                                                                          ‘u02/app/oracle/oradata/ORCL12/control02.ctl’                                                                                    scope=spfile;                                                                                    I have created control file copy using this but I didn’t created a directory (‘/u02/..’)before hitting this command and  it resulted in                                                                                                    ORA-00205: Error in identifying controlfile  and series of challenges that I faced 

ORA-01078: Failure in processing system parameters                                    

LRM-00109: Could not open parameter file                                                        

ORA -32001 Write to SPFILE is requested but no SPFILE is in use

Here I fixed one by one
-ORA-01078 : 
multiplexing controlfiles
recovery of pfile
recovery of pfile

To create pfile from alert_ORCL11.log file hit below command:                                                           > cp alert_ORCL11.log  /u01/$ORACLE_HOME/dbs/initORCL11.ora

 Next step is remove all the alerts from file and keep only parameters.Here your pfile is recovered

recovery of pfile
multiplexing controlfiles

ORA-32001

multiplexing controlfiles

SPFILE is again created by issuing following command:                                                                      > create spfile from pfile;                                                                                                                            Restart is necessary for this as I edited multiple files.                                                                           > Shutdown immediate;

 > startup;

Author Profile

Tejas
Tejas
Passionate traveller,Reviewer of restaurants and bars,tech lover,everything about data processing,analyzing,SQL,PLSQL,pig,hive,zookeeper,mahout,kafka,neo4j
Like
Like Love Haha Wow Sad Angry
Summary
How to multiplex control files?
Article Name
How to multiplex control files?
Description
Challenges you can face while recovery of database. Fixes for ORA-00205,ORA01078, LRM00109 ,0RA32001
Author

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enable Notifications.    Ok No thanks