DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Saturday, June 11, 2016

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



No comments: