11gR2 RAC ASM using RMAN Multiplexing the control file


STEP 1. Check the current control file status 


SQL> select name from v$controlfile;
NAME
——————————————————————————–

+DATA/orcl/controlfile/current.263.800282297


STEP 2. Change the  control_files parameter by adding the new disk group


Alter system set control_files=’+DATA/orcl/controlfile/current.263.800282297′,’+FRA’ scope=spfile;


STEP 3. Shutdown the RAC database and start the database in nomount mode


srvctl stop database -d orcl

srvctl start database -d orcl -o nomount

STEP 4. After bounce and check the database and see if new diskgroup has been added to the control_files parameter

 SQL> show parameter control_files
NAME                                     TYPE                         VALUE
 ———————————— ———– ——————————————————————————-

 control_files                      string                      +DATA/orcl/controlfile/current.263.800282297, +FRA

STEP 5. Connect to RMAN and use restore command to create a copy of the control file


oracle@node1]$ rman target /
Recovery Manager: Release 11.2.0.3.0 – Production on Wed MAY 28 04:50:08 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: orcl (not mounted)
RMAN> restore controlfile from ‘+DATA/orcl/controlfile/current.263.800282297’;
Starting restore at 28-MAY-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=377 instance=orcl1 device type=DISK
channel ORA_DISK_1: copied control file copy
output file name=+DATA/orcl/controlfile/current.263.800282297
output file name=+OCR_VOTE/orcl/controlfile/current.256.800513469

Finished restore at 28-MAY-16


Step:8 Check the controlfile name in ASM diskgroup “FRA”


As you can see above new control file


+FRA/orcl/controlfile/current.256.800513469 has been generated.


STEP 9.modify the control_files parameter using alter system command



 SQL> alter system set control_files=’+DATA/orcl/controlfile/current.263.800282297′, ‘+FRA/orcl/controlfile/current.256.800513469’ scope=spfile;


STEP 10. Shutdown the database and start up normal.


[gridora@node1$ srvctl stop database -d orcl
[gridora@node1$ srvctl start database -d orcl


SQL> show parameter control_files;
NAME                 TYPE        VALUE
 ———————————— ——————————– —————————————————————–————
 control_files     string    +DATA/orcl/controlfile/current.263.800282297, +FRA/orcl/controlfile/current.256.800513469




SQL> select name from v$controlfile;
NAME
 ————————————————————————————————
 +DATA/orcl/controlfile/current.263.800282297
 +FRA/orcl/controlfile/current.256.800513469




  • June 11, 2016 | 14 views
  • Comments