Monday, September 26, 2011

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>

No comments:

Post a Comment