Home > Oracle > multiplexing oracle ASM control files

multiplexing oracle ASM control files

SQL> show parameter control_files;

NAME            TYPE        VALUE
--------------- ----------- ------------------------------
control_files   string      +FLASH/testorac/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@uknesdb99:~/scripts>  rman target /

Recovery Manager: Release - Production on Mon Mar 22 15:35:41 2010

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

connected to target database: TESTORAC (not mounted)

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

Starting restore at 22-MAR-10
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/testorac/controlfile/current.412.714325539
output file name=+FLASH/testorac/controlfile/current.440.714325539
Finished restore at 22-MAR-10

SQL> alter database mount ;

Database altered.

SQL> alter database open ;

Database altered.

SQL>show parameter control_files

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

Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: