Saturday, January 7, 2012

Multiplexing of CONTROL FILES


Multiplexing of CONTROL FILES on RAC database. Process is same for single instance datbase.

1) shutdown database on all nodes; ensure no instance is mounting the database

2) startup nomount one instance

3) rman target /

4) restore controlfile to '+DATA' from '+DATA/PRIMARY/CONTROLFILE/Current.269.764683861';
   restore controlfile to '+DATA' from '+DATA/PRIMARY/CONTROLFILE/Current.269.764683861';

repeat for other controlfiles.

check your ASM disk targets... this is only a example

5) sqlplus / as sysdba

6) alter system set control_files='+DATA/PRIMARY/CONTROLFILE/current.753.771970049', '+DATA/PRIMARY/CONTROLFILE/Current.269.764683861',  
   '+DATA/PRIMARY/CONTROLFILE/current.751.771970043' scope=spfile;

7) shutdown (immediate)

8) srvctl start database -d <database name>

No comments:

Post a Comment