multiplexing oracle ASM control files

SQL> show parameter control_files;

--------------- ----------- ------------------------------
control_files string +FLASH/AZKKUAT/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: AZKKUAT (not mounted)

RMAN> restore controlfile from '+FLASH/AZKKUAT/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/AZKKUAT/controlfile/current.412.714325539
output file name=+FLASH/AZKKUAT/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/AZKKUAT/controlfile/current.412.714325539, +FLASH/AZKKUAT/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: