Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, I will be explaining how to do Control File Multiplexing in Database Using ASM.
1. SPFILE is backed up as PFILE.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | [oracle@primary1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 7 15:40:52 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> create pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/spfilebackup.ora' from spfile; File created. |
2. The CONTROL_FILE parameter is updated as follows.
1 2 3 | SQL> alter system set control_files='+DATA/primary/controlfile/current.260.897835619','+FRA' sid='*' scope=spfile; System altered. |
3. The closed Database is reopened in NOMOUNT mode.
1 2 3 | [oracle@primary1 ~]$ srvctl stop database -d primary [oracle@primary1 ~]$ srvctl start database -d primary -o nomount |
4. Perform CONTROLFILE recovery with RMAN.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | [oracle@primary1 ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Mon Dec 7 15:37:16 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: PRIMARY (not mounted) RMAN> restore controlfile from '+DATA/primary/controlfile/current.260.897835619'; Starting restore at 07-DEC-15 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=196 instance=primary1 device type=DISK channel ORA_DISK_1: copied control file copy output file name=+DATA/primary/controlfile/current.260.897835619 output file name=+FRA/primary/controlfile/current.264.897838667 Finished restore at 07-DEC-15 RMAN> exit Recovery Manager complete. |
5. The CONTROLFILE parameter is updated as follows.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | [oracle@primary1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 7 15:38:11 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> alter system set control_files='+DATA/primary/controlfile/current.260.897835619','+FRA/primary/controlfile/current.264.897838667' sid='*' scope=spfile; System altered. |
6. The database in NOMOUNT mode is closed.
1 2 3 4 5 6 7 8 9 | SQL> shutdown immediate; ORA-01507: database not mounted ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options |
7. The database is opened again in OPEN mode.
1 | [oracle@primary1 ~]$ srvctl start database -d primary |
8. The CONTROL_FILE parameter is checked.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | [oracle@primary1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 7 15:40:52 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> show parameter control NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_file_record_keep_time integer 7 control_files string +DATA/primary/controlfile/current.260.897835619, +FRA/primary/controlfile/current.264.897838667 |
