Saturday, August 09, 2008

RAC Infrastruture Guildlines

Dell RH Linux non-critical db servers:
lnx521 and lnx522 (dev)
lnx523 and lnx524 (UAT)
lnx525 and lnx526 (prod)


Storage:
OCR and Voting Disks: multiplexed on 2 – 13 GB luns
Data: allocated in 100GB lun chunks. (current sum of target dev/UAT db’s for
Linux: approx 375GB/650GB)
Recovery: 100GB lun each for dev/UAT


Naming Standards
Server: lnx###
Storage
OCR: OCR1, OCR2
Voting Disk: VOTE1, VOTE2, VOTE3
ASM
Disk Group: ORADATA1 and ORAFLASH1
Disks: oradatad###

Oracle Software Install
/ora01/oracle/product/crs_ CRS $ORACLE_HOME
/ora01/oracle/product/asm_ ASM $ORACLE_HOME
/ora01/oracle/product/db_ Database $ORACLE_HOME

Cluster Name (must be unique across enterprise)
CLDEV##, CLUAT##, CLPROD##

Global DB Name: xxx[D,T,P]
Instance Name: xxx[D,T,P][#]



Install Standards/Database creation
Password file – use file created by default
Companion disk – install in database $OH
dbca – use for db creation – (CSX_Default template will be created)
pfile – located in $OB/admin/SID/pfile (one line referencing spfile), link to $OH/dbs
spfile – on ASM (backup pfile kept in $OB location tbd)
Database Control - do not install/configure (Grid control will be used)
ASM instance sys/system passwords – kept in sync with dev/prod database sys/system passwords
Datafiles: created in ORADATA1 diskgroup
Controlfiles: created in ORADATA1 and ORAFLASH1 diskgroups
Redo logs: created in ORADATA1 and ORAFLASH1 diskgroups
Archive logs: created in ORAFLASH1 diskgroup


Suggested standards/will require follow-up:

ASMlibs created on /opt/oracle/extapi – local rpm package install common to scripts
directory – location cannot be changed – create links for all common directories
currently in use on /opt/oracle

CRS, ASM and database $OH – create on local storage - need to determine any
backup/DR implications/revisions to current standard

/oramisc01 – create on local storage <=50GB partition – need to determine any
backup/DR implications/revisions to current standard

Root access needed for cluster install – will need to develop procedure keeping
with Sarbanes Oxley requirements