RollingPig
ҽ
л
ҵBlog
¹鵵...
·...
ͳ...
վ...
Դ
===========================================================
Oracle RAC ʵʩ(zt)
===========================================================

www.oracle.com/technology/global/cn/pub/articles/haskins-rac-project-guide.html

ߣChristopher Haskins

塢ƺṩɹ Oracle RAC Ŀָϡ

2006 4 ·

Oracle ӦüȺ (RAC) RDBMS геݿ⼯ȺOracle RAC ѡΪ˾ṩ߿ԽĹ㷺ԡǣʹѡԺԳɹʵʩ

Ƕ塢ƺṩɹ Oracle RAC Ŀָϡϸ˼ٷպӳɹʵʩϸ衣⣬ͻʵʩ Oracle RAC Ŀпܻ᷸Ĵ󣬲ṩ˱ЩĽ顣

ƪ² Oracle RACв Oracle ʵʩĿáע⣬ָϽṩϢں£ɽΪѯ񡣣

ǿʼɣ

Oracle RAC ʵʩ֮һȷ(1)

Oracle RAC ʵʩ֮һȷ(2)

Oracle RAC ʵʩ֮һȷ(3)

Oracle RAC ʵʩ֮һȷ(4)

Oracle RAC ʵʩ֮һȷ(5)

Oracle RAC ʵʩܹ֮ƺ͹(1)

Oracle RAC ʵʩܹ֮ƺ͹(2)

Oracle RAC ʵʩ֮RAC ϵͳ(1)

Oracle RAC ʵʩ֮RAC ϵͳ(2)

Oracle RAC ʵʩ֮RAC ϵͳ(3)

Oracle RAC ʵʩ֮RAC ϵͳ(4)

Oracle RAC ʵʩ֮ģ

Oracle RAC ʵʩܽ


rollingpig :2006.07.03 15:37 ::: ( Oracle collections ) ::Ķ:(273) :: (0) :: (0)
===========================================================
Oracle RAC ʵʩ(ZT)
===========================================================

www.oracle.com/technology/global/cn/pub/articles/haskins-rac-project-guide.html

ߣChristopher Haskins

塢ƺṩɹ Oracle RAC Ŀָϡ

2006 4 ·

Oracle ӦüȺ (RAC) RDBMS геݿ⼯ȺOracle RAC ѡΪ˾ṩ߿ԽĹ㷺ԡǣʹѡԺԳɹʵʩ

Ƕ塢ƺṩɹ Oracle RAC Ŀָϡϸ˼ٷպӳɹʵʩϸ衣⣬ͻʵʩ Oracle RAC Ŀпܻ᷸Ĵ󣬲ṩ˱ЩĽ顣

ƪ² Oracle RACв Oracle ʵʩĿáע⣬ָϽṩϢں£ɽΪѯ񡣣

ǿʼɣ

Oracle RAC ʵʩ֮һȷ(1)

Oracle RAC ʵʩ֮һȷ(2)

Oracle RAC ʵʩ֮һȷ(3)

Oracle RAC ʵʩ֮һȷ(4)

Oracle RAC ʵʩ֮һȷ(5)

Oracle RAC ʵʩܹ֮ƺ͹(1)

Oracle RAC ʵʩܹ֮ƺ͹(2)

Oracle RAC ʵʩ֮RAC ϵͳ(1)

Oracle RAC ʵʩ֮RAC ϵͳ(2)

Oracle RAC ʵʩ֮RAC ϵͳ(3)

Oracle RAC ʵʩ֮RAC ϵͳ(4)

Oracle RAC ʵʩ֮ģ

Oracle RAC ʵʩܽ


rollingpig :2006.07.03 10:16 ::: ( Oracle collections ) ::Ķ:(172) :: (0) :: (0)
===========================================================
Windows OSD-04008O/S-Error: (OS 33) ijֿܵԭ򼰽
===========================================================

itpubиô˵ģ

֮ǰһʱݿⶼĺܺãһܣĪϵһضʱرգԭʱϣûʲʾ

alertﱨ

ORA-00345: redo log write error block 38023 count 2
ORA-00312: online log 3 thread 1: 'E:ORACLEORADATAAUPIDREDO03.LOG'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.

 鿴ȫ
rollingpig :2006.06.26 14:33 ::: ( Oracle collections ) ::Ķ:(3474) :: (0) :: (0)
===========================================================
How to unregister a database from rman catalog
===========================================================

How to unregister a database from rman catalog

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmrepos.htm#442604

 鿴ȫ

rollingpig :2006.05.19 16:47 ::: ( Oracle collections ) ::Ķ:(2288) :: (2) :: (0)
===========================================================
Oracle RAC ʵʩܽ
===========================================================

ܽ

ǰĿ׶Уȷ˺ĵĿĿꡢȷĿ󡢰תΪ淶˲Է⣬ȷ Oracle RAC ʵʩIJԵı׼Щһ Oracle RAC ʵʩĿ

÷һ޼۵ĹߣʵĿ꣬ʹһ·Ԥ⡣ʹķ ȷɹ Oracle RAC ʵʩ Ԥڰʱ


rollingpig :2006.05.16 16:06 ::: ( Oracle collections ) ::Ķ:(310) :: (2) :: (0)
===========================================================
Oracle RAC ʵʩ֮ģ
===========================================================

ʲôʱʹϵͳ

ǰĿ׶μصIJϵͳԵIJԡĺ˶Եȡվ㣬ͨôٿ԰塢ơ Oracle RAC ʵʩ

ȷȡɵ졢Ŀճδʣʱ䡢ϵͳǰ״̬µȶԡȡĿ

һʵ׶κͲһϸĿһɵIJԷһ裿УȷǷȷʵҪضʹϵͳ Ƿϵͳ󽫸ض

˵

ɣ

ȷ

ȷĿΧ

ȷĿĸ߼ҵĿ

ȷĿŶ

ȷĿŶ

ȷȼ

ȷȼ

ȷ

ȷ

֤

ʹĿŶӳϤ漰ļȷĿճԼΪƺ͹׶׼

ȷĿճ

ȷĿճ

ƺ͹

ܹƺ͹

Ӳ淶

ȷĿҪʹõӲ

֤

֤Ӳѡ

Ӳ

Ӳ

ϵͳ

װòϵͳ

Ԫ

Խڵ㵥Ԫڰװ Oracle ݿǰʹ CVU Ԥ֤ã

ϵͳԪ

OS Ԫڰװ Oracle ݿǰʹ CVU ֤ OS ã

絥Ԫ

Խڵ㵥Ԫڰװ Oracle ݿǰʹ CVU ֤ã

Oracle

װ Oracle ݿ

ɲ

ȷӲУͨһ Oracle RAC ݿ

ΪѹԺʹ׼ϵͳ

ɲ

ȷӦó Oracle RAC

Oracle RAC ϵͳ

ѹ

ģ Oracle RAC ϵͳϵ


rollingpig :2006.05.16 16:05 ::: ( Oracle collections ) ::Ķ:(315) :: (0) :: (0)
===========================================================
Oracle RAC ʵʩ֮RAC ϵͳ 4
===========================================================

ѹ

ѹҲΪزԻϵͳԣһģ⶯̬صĶ˵˲ԡȷϵͳǷԳʹõȼǷȼԼռݡԤ⵱ǰδʹͨԷؿ϶ĽʱԼȫӲӦóִѹԡһҪĿ̱˽ΪһĿ׶Ρ

˵

Ŀ׶

ô

ѹ

ģϵͳϵһ̬

ѹ

ȷϵͳѿ

ķ 9 ԻķѴʱͽǮԱִвԴ׶ηϵͳϵķգϸȨԷijͶ̴


rollingpig :2006.05.16 16:05 ::: ( Oracle collections ) ::Ķ:(275) :: (0) :: (0)
===========================================================
Oracle RAC ʵʩ֮RAC ϵͳ 3
===========================================================

ɲ

ɲ԰ȷ϶ӲӦóģɹͬСɲȷϵͳǷ񰴹涨С

˵

Ŀ׶

ô

ɲ

ԶӲԼӦóͬ

ܹ

  • Ӳ
  • OS
  • Oracle ݿ

ȷϼɵģɹͬ


rollingpig :2006.05.16 16:04 ::: ( Oracle collections ) ::Ķ:(273) :: (0) :: (0)
===========================================================
Oracle RAC ʵʩ֮RAC ϵͳ 2
===========================================================

Ԫ

Ԫ԰һӲԼһӦóӦóģԡЩIJȷһģǷִҪС

Oracle 10g 2 һΪ Cluster Verification Utility (CVU) ֤ʵóһڶ Oracle RAC ڵӲýвԵĹߡʹøʵó֤ Oracle RAC ڵáϵͳԼá

ԪԵһҪԪؾƻԲԡ롣ԱͨƻԲģ쳣ԼͼƻϵͳOracle RAC еһƻԲʾΪƻ Oracle Cluster Registry (OCR)ȻִлָϵͳIJ衣IJԻĿԱϵͳıڣӶӦ׼

˵

Ŀ׶

ô

Ԫ

ԸӲӦóƻԲԡϵͳı

ܹ

  • Ӳ
  • OS
  • Oracle ݿ

ȷϵģ


rollingpig :2006.05.16 16:03 ::: ( Oracle collections ) ::Ķ:(377) :: (0) :: (0)
===========================================================
Oracle RAC ʵʩܹ֮ƺ͹(2)
===========================================================

2 C ִй淶

˶Ե󣬾Ҫ Oracle RAC ˡ

Щ

  1. ÷Ӳ
    1. װ CPUڴͱش
    2. װ HBA
    3. Ӳ
    4. װô洢豸洢
  2. òϵͳ
    1. װϵͳ
    2. òϵͳں˲
    3. the hangcheck-timer ģ
    4. ϵͳûû
    5. ù洢豸
    6. װԭʼ Oracle Ⱥļϵͳ
    7. ðȫ Shell (SSH)
  3. Oracle
    1. װ Oracle Clusterware
    2. װ Oracle
    3. Զ洢 (ASM)
    4. ݿ
    5. ݿʵ
    6. Oracle Clusterware Ӧóļ
    1. ִݼ
    2. ִ
    3. OS ݿⱸ
    4. /Oracle Data Guard
    5. װܼʵó
      Oracle Enterprise Manager Grid Control

rollingpig :2006.05.16 16:02 ::: ( Oracle collections ) ::Ķ:(341) :: (0) :: (0)
===========================================================
Oracle RAC ʵʩ֮RAC ϵͳ 1
===========================================================

RAC ϵͳ

Oracle RAC ԲӦֲٰԣ֤ԡԪԡɲԼزԡ

òԲԲһϽ׶εִеĹܣһɵȷơȽ׶еһ̡

òǿֲԣȷÿֲӦĿ׶Ρ

֤

֤ǶԸԵIJԡ¼ܹӲIJԡ֤ʹĿŶӿԲĿߵЧԣӶʹǿԿйĿҪߡ֤ͨ񼶱󡱺ܹ͡ƺ͹ִС

˵

Ŀ׶

ô

֤

ȷĿߵЧԣӲߵЧ

  • ȷȼ
  • ܹƺ͹

ʹĿŶӿǴǵĿ


rollingpig :2006.05.16 16:02 ::: ( Oracle collections ) ::Ķ:(420) :: (0) :: (0)
===========================================================
Oracle RAC ʵʩ֮һȷ(5)
===========================================================

4 C ȷĿճ

ȷ󡱽׶εһȷĿճ̡Ҫȷ㹻ʱ佨 Oracle RAC ϶ճ̰ŶĿɰҪ

ճ̰漰ϵͳΪÿʱ䡢ŵ˳ϸڡ

ķ 5 ڰĿճ̵ĹУӦŬʹÿĿԱʱƣ 1 ѯÿŶӳԱ׼ȷ͹滮Ŀճ̡

ʱĿճͬʱִжزаͨᰴʱĿʡĿɱ

һ߼ Oracle RAC ճʾչʾ Oracle RAC оִе

ڼ

ʼʱ

ʱ

ǰ

1

Ӳ

2

2005 12 1

2005 12 2

2

1

2005 12 1

2005 12 1

3

OS װ

1

2005 12 5 һ

2005 12 5 һ

1

4

1

2005 12 6 ڶ

2005 12 6 ڶ

3

5

Oracle ݿװ

1

2005 12 7

2005 12 7

4

6

ݿ⹹

2

2005 12 8

2005 12 9

5

7

ݼ

5

2005 12 12 һ

2005 12 16

6

8

Ԫ

2

2005 12 19 һ

2005 12 20 ڶ

7

9

ѹ

5

2005 12 21

2005 12 29

8

10

л

2

2005 12 30

2005 1 3 ڶ

9

11

ָ

19

2006 12 12

2005 1 4

5

12

ϵͳ

5

2006 1 5

2006 1 11

11

һϸĿճ̿ʹ Oracle RAC ŶӸĿĽȣճ̳ӦҪճʱһҪȷȫ¼иġĿճ̺͸øıΪԺĿճ̵ƶṩҪIJο

ķ 6 ÿͬʱִеĶĿճУע Task #11 Task #7 Task #10 ͬʱеġ

ȷͼ¼ĿΧĿŶӡȼԼĿճ̺󣬲һǿĸĿƻơϸģѳɱԤڣʹĿճ̽С


rollingpig :2006.05.16 15:47 ::: ( Oracle collections ) ::Ķ:(228) :: (0) :: (0)
===========================================================
Oracle RAC ʵʩܹ֮ƺ͹(1)
===========================================================

ܹƺ͹

ɹ RAC ʵʩĵڶҪ׶ȷʵʩ Oracle RAC ļܹ淶ܹ˽ϵͳӲõϸڴ Oracle RAC ʵʩڴӵʵֲ Oracle RAC ʵûǵӦóݿ⣬ڸý׶ƺ͹ Oracle RAC

вνתΪõơ

1 C ȷӲ淶

ò˽涨ķȼͲȻЩתΪӲ淶ӲļԣضIJϵͳҪԼ Oracle RAC ض

ʹӲ/עΪ˶Եڼ¼ڱоĸʵʩдĿʹõӲ

дñʱش

  • Ƿȼ
  • Ƿ
  • ǷӲԼǷ񾭹֤Ӳһʹã
  • ǷϵͳԼǷ񾭹֤ϵͳһʹã
  • Ƿ Oracle RAC
  • Ƿ֤֧ Oracle RAC ڸϣ

ķ 7 ȷ Oracle RAC ĿŶ֪ Oracle RAC ϵͳÿĹܺԣԼ֤ͨһʹáͨʵļѵ͸֤ Oracle RAC Ŀķա

Ŀ

OS

Oracle RAC

Ӳ

Ӳ

ڵ

ÿڵ CPU

ڴ棨ÿڵ GB

HBA

ÿڵ

ش̣ÿڵ GB

SAN/洢GB