1 100 247 2 I TInformation Te c h n o l o g y / 2 4 7 247 247 247 247 DBA (Data Base Administrator, ) O r a c l e D B A O r a c l e 8O r a c l e 8 i D B A O r a c l e 7 O r a c l e 8 100 247 2 O r a c l e 7O r a c l e 8 99. 99 100 O r a c l e 7 O r a c l e 8 90
2 90 90 2. 4 10 36. 5 247 247 90 9 247 247 / 1.1 247 247 1.1.1 247 247 A u t l b s t a t / u t l e s t a t 10 ( ) D B A D B A CIO ( ) i n i t. o r a U N I X D ATAI N D E X 16 6
1 3 1 4 C I O 247 247 Wo o d r i d g e B ( ) 247 O r a c l e U N I X 10 1-1 247 2 1-1 B 08 : 001 8 : 00 60 18 : 002 0 : 00 15 20 : 002 2 : 00 6 22 : 000 0 : 00 2 0 0 : 0 00 4 : 0 0 0 4 : 0 00 7 : 0 0 07 : 000 8 : 00 10 A 247 B 247 247 1. 247 2 47 (1) /
4 VA L I D ATE STRUCTURE / b u g b u g O r a c l e m a l l o c () f r e e ( O r a c l e 247 O r a c l e O r a c l e O r a c l e (2) 1-1 RAID 0 RAID / RAID 1 I / O U N R E C O V E R A B L E N O L O G G I N G U N R E C O V E R A B L E / N O L O G G I N G
1 5 C R E ATE INDEX U N R E C O V E R A B L E N O L O G G I N G U N R E C O V E R A B L E C H E C K P O I N T 90% 99.999% 1-1 U N R E C O V E R A B L E / N O L O G G I N G O r a c l e 8 i D M L O r a c l e 8 i 1-2 1-3 1 1-2 UNRECOVERABLE/NOLOGGING U N R E C O V E R A B L E / N O L O G G I N G 30 30 30 90
6 1-3 RECOVERABLE/LOGGING 2 R E C O V E R A B L E / L O G G I N G 40 30 70 U N R E C O V E R A B L E R E C O V E R A B L E 247 247 / 7 D B A S TO R A G E 247 (3) 1-2
1 7 1-2 I T 247 85 I T / / 2. 247 2 4 2 4 18 247 ( (replication) O r a c l e Advanced Replication O r a c l e Advanced Replication R r e p l i c a t i o n O r a c l e Advanced Replication )
8 19 247 247 247 / 247 247 3. / /
1 9 247 / $5 000 $1000 000 Order Entry (Bill of Materials) ( A c c o u n t i n g ) 247 1.1.2 D B A 1-3 D B A DBMS O r a c l e
10 OS D B M S DBMS 1-3 O r a c l e Raw Iron 247 D B A O r a c l e O r a c l e O r a c l e NT D B A O r a c l e O r a c l e O r a c l O r a c l e D B M S O r a c l e
1 11 D B A D B A D B A D B A We b 247 O r a c l e (swap, ) DBMS D B M S b u g 22 247 D B M S O r a c l e 1.1.3
12 1. CIO ( ) D B A 2. / b u g b u g b u g b u g U N I XN T / D B A M T B FMean Ti m e Between Failure M T B F M T B M T B F 500 000 247 57 3. D B A
1 13 4. 247 247 247 1.2 247 247 1.2.1 247 247 2 47 247
14 24 7 247 247 2 247 247 247 2 1.2.2 S L AService Level Agreement S L A S L A S L A / S L A S L A S L A S L A S L A S L A
1 15 V PC E O S L A S L A S L A S L A S L A 1. S L A S L A 200 S L A 2. S L A X Y S L A XY S L A S L A B A B C D 3. S L A S L S L A S L A S L S L A S L A S L A S L A
16 G u e s t S L A S L A S L S L A S L 4. S L A S L A S L A 1-4 150 10 15 30 S L A 1-4 0 8 : 0 01 8 : 0 0 1 8 : 0 02 3 : 0 0 2 3 : 0 00 4 : 0 0 0 4 : 0 00 8 : 0 0 D B A D B A 5. S L A S L S L A 247 S L A
1 17 6. S L A M T B F M T T R M T B F 600 M T B F6 00 M T B F M T B F M T B F M T B F M T B F M T B F M T B F M T B F M T B F M T B F A B C S u n Enterprise 4000 O r a c l e 8 EMC 3100 R A I D - S M T B F250 000 32 M T B F 7 800 250 00 / 32 7 800 / 10 7 800 / 24 / 3 10 A B C M T B F 10 M T B F M T B C P U M T B F M T B F M T B M T T RMean Time to Recover M T T R O r a c l e 8 2 4 3 11 8 1-5 M T T R 8
18 1-5 6 30 42 3 14 7 2 / 14 15 8 30 8 M T B F M T T R S L A S L A 1.2.3 90 90 90 9 10 9 247 1-6 90 2. 4 10 1 36. 5 90
1 19 1-6 90. 0 35 12 99. 0 3 15. 5 9 9. 9 9 9 9. 9 9 5 0 9 9. 9 9 9 5 1.2.4 / 247 proactive maintenance (extent, ) MAXEXTENTS reached O r a c l e Optimal Flexible ArchitectureO FA D ATA 3 M B 5 M O R A - 1540Unable to allocate 5242880 bytes in tablespace (DATA D 5242880 C I O D ATA c a t c h - 22 15 18
20 S L A 1-7 S L A 1-7 1-7 Ye s Ye s N o Ye s N o / N o u t l b s t a tu t l e s t a t N o F R E E L I S T S I N I T R A N SP C T U S E DP C T F R E E i n i t. o r a Ye s N o Ye s N o N o N o Ye s / N o
1 21 1.3 1.3.1 247 2 47 24 7 1.3.2 247 D B A D B A D B A / 247 D B A 247 1-8 We b We 80 G B 1-8 1-8 D B A 1-8 07 : 001 5 : 00 Susan MD B A Marty GD B A Joe A Michelle P Rob F Dave S Brain G
22 07 : 00 ~ 15 : 00 Peter H / Sam J D B A Bill K 15 : 001 9 : 00 Sam J D B A Lucas SD B A Thomas A Vladimir P Bill T Patti N Susan MD B A Rob F 19 : 002 3 : 00 Sam J D B A Lucas SD B A Thomas A Vladimir P Patti N / Marty G D B A Joe A 23 : 000 7 : 00 John LD B A Lisa W Lucas SD B A Vladimir P 247 19 21 D B A D B A
1 23 D B A 1-8 Susan M 7 15 20 S u s a n 247 C I O O M B o b C I OJ e ff O M J e ff C I O L i s a O M L i s a 20 C I O J e ff O M J e ff J o e 1.3.3 1-9 1-9 D B A 0. 5 J e ff A 0. 5 Christine L 1. 0 Sheila P C I O 1. 0 Greg S V P 2. 0 Timothy S V P 2. 0 Leslie G C E O V P
24 C E O C E O D B A 1.3.4 We b 24 48 1.4 247 S L A