multiplexing oracle ASM control files


SQL> show parameter control_files;




NAME TYPE VALUE

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

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>

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 11.2.0.3.0 - 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
Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: