!!高可用性システム構築~RAC基本編 - Oracle

1 !! ~RAC ~ Copyright 2011, Oracle . All rights Oracle java Oracle Corporation Copyright 2011, Oracle . All rights RAC RAC RAC Copyright 2011, Oracle . All rights reserved. Active-Standby Oracle Real Application Clusters RAC Copyright 2011, Oracle . All rights reserved. ??5 Copyright 2011, Oracle . All rights 6 OracleInstanceACTIVE OracleInstanceOracleInstance Active-Standby standby Active-Standby ACTIVEC opyright 2011, Oracle .

2 All rights 7 Active-Standby 1 CPU Copyright 2011, Oracle . All rights 8 1 CPU CPU Active-Standby 1 CPU Copyright 2011, Oracle . All rights Real Application Clusters 9 OracleInstanceACTIVE OracleInstanceOracleInstanceOracleInstan ceACTIVEACTIVEACTIVE Oracle Real Application Clusters(RAC) Copyright 2011, Oracle . All rights reserved. 2 10 processprocessprocessprocessprocessproce ss CPU CPU processprocess .. CPU CPU 2 / processprocessCopyright 2011, Oracle . All rights RAC 11 OracleInstanceOracleInstanceOracleInstan ce RAC Active-Active RAC processprocessprocessprocessprocessproce ssCopyright 2011, Oracle .

3 All rights RAC STANDBY OracleInstanceActive-Standby ACTIVEO racleInstance RACACTIVE ACTIVEO racleInstanceOracleInstance ACTIVEO racleInstance12 Copyright 2011, Oracle . All rights RAC 13 ACTIVEO racleInstanceOracleInstanceOracleInstanc e ACTIVEACTIVE RAC Copyright 2011, Oracle . All rights Copyright 2011, Oracle . All rights reserved. 15 UNDO REDO REDO Oracle Instancetnslsnr REDO UNDO Copyright 2011, Oracle . All rights 16 Oracle InstancetnslsnrOracle InstancetnslsnrUNDO REDO REDO UNDO REDO REDO UNDO REDO REDO RAC Oracle REDO UNDO Instance 1 Instance 2 Oracle InstancetnslsnrInstance nInstance 1 Instance 2 Instance n Copyright 2011, Oracle .

4 All rights 17 Public Network RAC Interconnect Network RAC Copyright 2011, Oracle . All rights 18 Oracle Grid InfrastructureOracle Database Oracle Database 11g Release 2 RAC Grid DatabaseCopyright 2011, Oracle . All rights 19 Oracle DatabaseOracle ClusterwareOracle Automatic Storage ManagementOracle Grid Infrastructure Oracle Grid Infrastructure 2 Oracle Clusterware Oracle Oracle Automatic Storage Management (ASM) Oracle Copyright 2011, Oracle . All rights RAC RAC RAC Copyright 2011, Oracle . All rights 21 RAC CPU SQL Public Networkprocessprocessprocessprocessproce ssprocessCopyright 2011, Oracle .

5 All rights reserved.$sqlplususername/password@ hostname:1521/service_1 22 $sqlplususername/password@ hostname:1521/service_1 RAC RAC Oracle RAC service_1service_1 Copyright 2011, Oracle . All rights reserved. SQL 23 Oracle InstanceOracle InstanceOracle Instancesales RAC SQL SQL> select * from sales;service_1 SQL> select * from sales;oracleoracleOracle (SQL )Copyright 2011, Oracle . All rights reserved. 24oracleoracle ( ) CPU RAC ( ) ( ) : Oracle Database I/O : I/O Oracle (SQL ) Oracle : : Copyright 2011, Oracle .

6 All rights 25oracleoracleoracleoracle RAC ( ) Cache Fusion ( ) SQL CPUC opyright 2011, Oracle . All rights 26oracle ( ) Oracle CPUSQL Copyright 2011, Oracle . All rights 27oracleoracleoracleoracle CPU ( ) SQL Copyright 2011, Oracle . All rights 28 CPU SQL oracleoracleoracleoracleoracleoracleCopy right 2011, Oracle . All rights 29 RAC CPU oracleoracleoracleoracleoracleoracleCopy right 2011, Oracle .

7 All rights 30 RAC CPU 1 SQL PSPS oracleParallel Slave ProcessesCopyright 2011, Oracle . All rights 31 PSPSPSPSPSPSPSPS RAC CPU 1 SQL 1 SQL oracleCopyright 2011, Oracle . All rights 32 RAC 1 SQL RAC CPU Cache FusionCopyright 2011, Oracle . All rights RAC Oracle Clusterware RAC Copyright 2011, Oracle . All rights 34 RAC ACTIVEO racleInstanceOracleInstanceOracleInstanc e ACTIVEACTIVEC opyright 2011, Oracle . All rights 35 UNDO REDO REDO RACI nstance 1 Instance 2 Instance 3 Instance 1 Instance 2 Instance 3 REDO RAC REDO UNDO REDO REDO UNDO REDO REDO UNDO REDO REDO Copyright 2011, Oracle .

8 All rights reserved. ASM InstanceOracleInstancetnslsnrASM InstanceOracleInstancetnslsnrASM InstanceOracleInstancetnslsnrOracle Clusterware 36 Oracle ClusterwareOracle Clusterware Oracle Clusterware Oracle / Copyright 2011, Oracle . All rights reserved. RAC 37 / : ASM InstanceOracleInstancetnslsnrASM InstanceOracleInstancetnslsnrASM InstanceOracleInstancetnslsnrOracle ClusterwareOracle ClusterwareOracle ClusterwareCopyright 2011, Oracle . All rights reserved. RAC 38 ASM InstanceOracleInstancetnslsnrASM InstanceOracleInstancetnslsnrASM InstanceOracleInstancetnslsnrOracle ClusterwareOracle ClusterwareOracle Clusterware / : Copyright 2011, Oracle . All rights InstanceOracleInstancetnslsnrASM InstanceOracleInstancetnslsnrASM InstanceOracleInstancetnslsnr RAC 39 VotingDiskInterconnectNetworkOracle ClusterwareOracle ClusterwareOracle Clusterware ( ) : Copyright 2011, Oracle .

9 All rights InstanceOracle Instance RAC 40tnslsnrtnslsnrtnslsnrVotingDisk InterconnectNetworkOracle ClusterwareOracle ClusterwareOracle ClusterwareCopyright 2011, Oracle . All rights reserved. RAC 41tnslsnrtnslsnrVotingDiskOracle InstanceOracle Instance OS InterconnectNetworkOracle ClusterwareOracle ClusterwareOracle ClusterwareCopyright 2011, Oracle . All rights 42 RAC Oracle Clusterware RAC Copyright 2011, Oracle . All rights reserved. Copyright 2011, Oracle . All rights Real Application Clusters44 RAC CPU processprocessACTIVEO racleInstanceOracleInstanceOracleInstanc e ACTIVEACTIVE processprocessprocessprocessCopyright 2011, Oracle .

10 All rights OTN / Copyright 2011, Oracle . All rights ( )Database Database Database JavaWebLogicServer/ EPM/BI / 100 46 OTN Copyright 2011, Oracle . All rights reserved. 47 Pick UP etc. SQL etc. / !? 2011, Oracle . All rights 48oracletechViva!Developer / Oracle MASTER Oracle Database 2011, Oracle .