#private
10.11.22.1 OR-01-PRIV OR-01-PRIV
10.11.22.2 OR-02-PRIV OR-02-PRIV
--------------------------------------------------------
SCAN INFORMATION
--------------------------------------------------------
Name: homerac-scan.home.loc
Addresses: 192.168.13.50
192.168.13.53
192.168.13.54
---------------------------------------------------------
DR SITE SERVERS CONFIGURATION
---------------------------------------------------------
Host file on DR Servers
public
198.18.208.195 D-OR-01.home.loc D-OR-01
198.18.208.196 D-OR-02.home.loc D-OR-02
#VIP
198.18.208.204 D-OR-01-VIP.home.loc D-OR-01-VIP
198.18.208.205 D-OR-02-VIP.home.loc D-OR-02-VIP
#private
10.10.10.13 D-OR-01-PRIV D-OR-01-PRIV
10.10.10.14 D-OR-02-PRIV D-OR-02-PRIV
-------------------------------------------------------
Name: dmrac-scan.home.loc
Addresses: 198.18.208.197
198.18.208.198
198.18.208.199
-------------------------------------------------------
Disks attached on production
DISKPART list disk
Disk ### Status Size Free Dyn Gpt
-------- ------------- ------- ------- --- ---
Disk 0 Online 836 GB 1024 KB
Disk 1 Online 5156 MB 5154 MB
Disk 2 Online 5156 MB 5154 MB
Disk 3 Online 600 GB 600 GB
Disk 4 Online 533 GB 1024 KB
Disk 5 Online 333 GB 1024 KB
PARTITIONS AVAILABLE ON PRODUCTION
-----------------------------------------
DISKPART list volume
Volume ### Ltr Label Fs Type Size Status Info
---------- --- ----------- ----- ---------- ------- --------- --------
Volume 0 F DVD-ROM 0 B No Media
Volume 1 System Rese NTFS Partition 100 MB Healthy System
Volume 2 C NTFS Partition 244 GB Healthy Boot
Volume 3 D New Volume NTFS Partition 592 GB Healthy
Volume 4 RAW Partition 533 GB Healthy
Volume 5 RAW Partition 333 GB Healthy
Disks attached on DR Server
DISKPART list disk
Disk ### Status Size Free Dyn Gpt
-------- ------------- ------- ------- --- ---
Disk 0 Online 135 GB 0 B
Disk 1 Online 5156 MB 5156 MB
Disk 2 Online 5156 MB 5156 MB
Disk 1 Online 533 GB 1024 KB
Disk 2 Online 333 GB 1024 KB
Disk 3 Online 10 GB 1024 KB
Disk 4 Online 300 GB 0 B
OCR LUN with 10 GB was created on New DR Servers and new diskgroup OCRVOTE was created on this LUN to store OCRVOTE of new DR Cluster.
VOLUME INFORMATION ON DR SERVER
DISKPART list volume
Volume ### Ltr Label Fs Type Size Status Info
---------- --- ----------- ----- ---------- ------- --------- -------
Volume 0 W CD-ROM 0 B No Media
Volume 1 NTFS Partition 100 MB Healthy System
Volume 2 C NTFS Partition 135 GB Healthy Boot
Volume 3 E Removable 0 B No Media
Volume 4 RAW Partition 533 GB Healthy
Volume 5 RAW Partition 333 GB Healthy
Volume 6 RAW Partition 9 GB Healthy
Volume 7 D New Volume NTFS Partition 300 GB Healthy
=======================================
Grid infrastructure software was installed and cluster (dmrac-scan.home.loc)was created on new DR Servers and OCRVOTE diskgroup is created on newly added candidate 10GB LUN.
--------------------------------------
After GRID installation and configuration run asmca and mount both +homeDBDATA AND +homeDBFLASH on all nodes
create pfile (initprddb1.ora on node1 and initprddb2.ora on node2) in directory
D:\app\Inam\product\11.2.0\dbhome_1\database
and add only spfile parameter in both files
SPFILE='+homeDBDATA/prddb/parameterfile/spfile.309.822141283'
Login on NODE1 D-OR-01 and add database resource
D:\app\11.2.0.3\grid\BIN srvctl add database -d prddb -o D:\app\Inam\product\11.2.0\dbhome_1
Confirm that database is added
D:\app\11.2.0.3\grid\BIN srvctl config database -d prddb
Database unique name: prddb
Database name:
Oracle home: D:\app\Inam\product\11.2.0\dbhome_1
Oracle user: nt authority\system
Spfile:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: prddb
Database instances:
Disk Groups:
Mount point paths:
Services:
Type: RAC
Database is administrator managed
-----------------------------------------
D:\app\11.2.0.3\grid\BIN srvctl add instance -d prddb -i prddb1 -n D-OR-01
D:\app\11.2.0.3\grid\BIN srvctl add instance -d prddb -i prddb2 -n D-OR-02
-----------------------------------------
D:\app\11.2.0.3\grid\BIN srvctl start database -d prddb
-----------------------------------------
C:\Users\farif set oracle_sid=+ASM1
C:\Users\farif sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 2 12:30:12 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL show parameter diskgroup
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string homeDBFLASH, homeDBDATA
SQL alter system set asm_diskgroups = homeDBFLASH, homeDBDATA, OCRVOTE
System altered.
SQL show parameter diskgroup
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string homeDBFLASH, homeDBDATA, OCRVOTE
SQL EXIT
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64
bit Production
With the Real Application Clusters and Automatic Storage Management options
-----------------------------------------
D:\app\11.2.0\grid\bin srvctl config database -d prddb
Database unique name: prddb
Database name:
Oracle home: D:\app\Inam\product\11.2.0\dbhome_1
Oracle user: nt authority\system
Spfile:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: prddb
Database instances: prddb1,prddb2
Disk Groups: homeDBDATA,homeDBFLASH,OCRVOTE
Mount point paths:
Services:
Type: RAC
Database is administrator managed
--------------------------------------------
Change system parameter of remote_listener to reflet changes
-------------------------------------------------
alter system set remote_listener='dmrac-scan.home.loc:1521'
-----------------------------------------------
UPDATE TNSNAMES.ORA on both Nodes
On Node 1
------------------------------------------------
#######################DR SITE###################
DMprddb1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = D-OR-01)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prddb)
)
)
DMprddbRACSCAN1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 198.18.208.197)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 198.18.208.198)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 198.18.208.199)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prddb)
)
)
DMprddbRACSCAN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dmrac-scan.home.loc)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prddb)
)
)
----------------------------------------------
ON NODE 2
------------------------------------------------
#######################DR SITE###################
DMprddb1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = D-OR-01)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prddb)
)
)
DMprddbRACSCAN1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 198.18.208.197)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 198.18.208.198)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 198.18.208.199)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prddb)
)
)
DMprddbRACSCAN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dmrac-scan.home.loc)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prddb)
)
)
No comments:
Post a Comment