11g R2 RAC (ASM) veritabanında control file çoklama

multiplex control file

 

1- RAC node’larından biri ile veritabanına bağlanıp and mevcut control file durumunu kontrol ediyoruz.DATA disk grup altında control file’ın mevcut olduğunu görüyorum ve test sunucusunda başka disk grup ekli olmadığı için control file çoklama işlemini aynı disk grup altında yapacağım.

-bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 10 14:30:53 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select name from v$controlfile;

NAME
——————————————————————————–
+DATA/test/controlfile/current.261.814996359

2- Aşağıdaki şekilde ‘+DATA’ disk grubunu ikinci control file için ekliyoruruz.

SQL> alter system set control_files=’+DATA/test/controlfile/current.261.814996359′, ‘+DATA’ scope=spfile sid=’*';

System altered.

SQL> exit

3- Veritabanını kapatıp nomount mode da açıyoruz.

-bash-3.00$ srvctl stop database -d test
-bash-3.00$ srvctl start database -d test -o nomount

 

4- Control_files parametrelerini kontrol ediyoruz.

-bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 10 14:30:53 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> show parameter control_files

NAME TYPE VALUE
———————————— ———– ——————————
control_files string +DATA/test/controlfile/current
.261.814996359, +DATA
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

5- Rman’ e bağlanıp restore komutuyla +DATA altında ikinci contol file’ın kopyasını oluşturuyoruz.

-bash-3.00$ rman target /

Recovery Manager: Release 11.2.0.1.0 – Production on Mon Jun 10 14:31:57 2013

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

connected to target database: TEST (not mounted)

RMAN> restore controlfile from ‘+DATA/test/controlfile/current.261.814996359′;
Starting restore at 10-JUN-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=51 instance=TEST1 device type=DISK

channel ORA_DISK_1: copied control file copy

output file name=+DATA/test/controlfile/current.261.814996359
output file name=+DATA/test/controlfile/current.307.817742049
Finished restore at 10-JUN-13

RMAN> exit

Recovery Manager complete.
6- Rman ile restore ettikten sonra output file name satırlarında belirtilen control file’ları set ederiz.

-bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 10 14:35:18 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> alter system set control_files=’+DATA/test/controlfile/current.261.814996359′, ‘+DATA/test/controlfile/current.307.817742049′ scope=spfile sid=’*';

System altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

7- Veritabanını kapatıp tekrar açıyoruz.

-bash-3.00$ srvctl stop database -d test
-bash-3.00$ srvctl start database -d test

8- Veritabanına bağlanıp control file ‘ı listelediğimizde +DATA disk grubun altında control file’ın kopyasının oluştuğunu görüyoruz.

-bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 10 15:57:37 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> show parameter control_files;

NAME TYPE VALUE
———————————— ———– ——————————
control_files string +DATA/test/controlfile/current
.261.814996359, +DATA/test/con
trolfile/current.307.817742049

SQL> select name from v$controlfile;

NAME
——————————————————————————–
+DATA/test/controlfile/current.261.814996359
+DATA/test/controlfile/current.307.817742049

SQL>