RAC Implementation.
As i understand that, 31 Servers to Create RAC Setups. We will configure
OS(Jumbo Frames, OS Kernel configurations, Oracle Prerequsite rpms(we can
provide list of rpms to be installed)) and DB(Redolog allocation with proper size,
db parameters, latest patches) as per Oracle Standard.
Backup will be configured with proper schedule.
Minimum 2 interface required for network, Public and Private.
Network adapters should use high speed adapters and switchers that
support TCP/IP and UDP( minimum 1 GbE, with 10 GbE recommended) we can
also use InfiniBand for the interconnect.
RAID - 1 0 can use it here. Can use multipath configuration for Storage
Contolfile, DB Files can keep it in RAID Disk.
Redo log – can be multiplexed. Fast Write speed Required. Not
Required for RAID.
Archivelog – Not required in RAID.
We can Configure Dataguard for Required RAC Environment, if required we
can configure DG Broker.
We configure Dataguard with Performance Mode. If DR should sync with
Primary on near to zero data loss, we can configure with realtime apply.
Dataguard Bandwidth Calculations.
Required bandwidth = ((Redo rate bytes per sec. / 0.70) * 8) / 1,000,000 =
bandwidth in Mbps
ex: 100MB/Sec Redo Generate at business hours -
((10,48,57,600/0.70) * 8) / 1,000,000 = 11,983 MBPS -- 11GB.
Migrating existing DB to New RAC.
Windows and Linux are same endian format, it supports Standby. so we
create standby on New RAC and do Switchover to NEW RAC to reduce downtime.
clarifications
31 servers to create RAC Setup. how many node on each RAC. 31 Rac
Setup?
usually 2 node RAC. it depends on Customer requirement.
How many databases should be there in each RAC?. Only One or Multiple
database
What is the Version of RAC. (19c mostly used).
ALL RAC Environment Should have Dataguard Environment?.
Each RAC Implementation may take around 40hrs. DR Setup , Migration
of existing DB to New RAC depending on DB Size.