multiplexing oracle ASM control files

SQL> show parameter control_files;


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

control_files string +FLASH/ANARDB/controlfile/current.256.710173383

SQL> alter system set control_files='+DATA','+FLASH' scope=spfile ;

System altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.


SQL> startup nomount ;

ORACLE instance started.

Total System Global Area 267227136 bytes

Fixed Size 2212496 bytes

Variable Size 222301552 bytes

Database Buffers 37748736 bytes

Redo Buffers 4964352 bytes

SQL> exit

oracle@test:~/scripts> rman target /

Recovery Manager: Release - Production on Sat Dec 28 09:48:12 2013

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

connected to target database: ANARDB (not mounted)

RMAN> restore controlfile from '+FLASH/ANARDB/CONTROLFILE/Current.256.710173383';

Starting restore at 28-DEC-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=25 device type=DISK

channel ORA_DISK_1: copied control file copy

output file name=+DATA/ANARDB/controlfile/current.412.714325539

output file name=+FLASH/ANARDB/controlfile/current.440.714325539

Finished restore at 28-DEC-13

SQL> alter database mount ;

Database altered.

SQL> alter database open ;

Database altered.

SQL>show parameter control_files

+DATA/ANARDB/controlfile/current.412.714325539, +FLASH/ANARDB/controlfile/current.440.714325539

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: