MOVING CONTROLFILES IN ASM

MOVING CONTROLFILES TO DIFFERENT LOCATION IN ASM

1) BACKUP YOUR SPFILE

2) IDENTIFY THE CONTROLFILE LOCATION

SQL> show parameter control_files

3) SHUTDOWN YOUR DATABASE AND BRING IT IN NOMOUNT MODE (If you are running on the RAC, start only ONE INSTANCE)

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 7466151936 bytes

Fixed Size                  2240872 bytes

Variable Size            3774877336 bytes

Database Buffers         3674210304 bytes

Redo Buffers               14823424 bytes

4) Change the Mount point location for the controlfile

SQL> alter system set control_files='+Bhuvan','+Bhuvan2','+Bhuvan3' scope=spfile sid='*';

System altered.

5) shutdown and bring the database to nomount stage

SQL> shutdown immediate;

SQL> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Mon Sep 26 15:49:38 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 1219334144 bytes

Fixed Size                  2225952 bytes

Variable Size             620759264 bytes

Database Buffers          587202560 bytes

Redo Buffers                9146368 bytes

Note: you need to specify your original copy of the control file for restoring

$ rman target /

Recovery Manager: Release 11.2.0.2.0 - Production on Mon Sep 26 15:50:53 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: Bhuvan (not mounted)

RMAN> restore controlfile from '+Bhuvan/bhu/controlfile/backup.256.762532857';

Starting restore at 26-SEP-11

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=80 instance=BHU_1 device type=DISK

channel ORA_DISK_1: copied control file copy

output file name=+BHUVAN1/bhu1/controlfile/current.268.762882663

output file name=+BHUVAN2/bhu1/controlfile/current.386.762882663

output file name=+BHUVAN3/bhu1/controlfile/current.269.762882665

Finished restore at 26-SEP-11

RMAN>

SQL> alter database mount;

Database altered.

SQL> show parameter control

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

control_file_record_keep_time        integer     30

control_files                        string      +bhuvan1/bhu1/controlfile/current.268.762882663,

                                                        +bhuvan2/bhu1/controlfile/current.386.762882663,

                                                        +bhuvan3/bhu1/controlfile/current.269.762882665

SQL> alter database open;

Database altered.

SQL>