Simplify your Job Automatic Storage Management DB TSC

Size: px

Start display at page:

Download "Simplify your Job Automatic Storage Management DB TSC"

주현 한
5 years ago
Views:

2 Simplify your Job Automatic Storage Management DB TSC

3 1. DBA Challenges 2. ASM Disk group 3. Mirroring/Striping/Rebalancing 4. Traditional vs. ASM 5. ASM administration 6. ASM Summary

4 Capacity in Terabytes Disk Capacity Capacity /DB Adm Mgmt Gap Strategic Research Corporation

5 DBA

6 (Automatic Storage Management, ASM) Automatic Storage Management, cluster file system volume manager file system Cluster database

7 ASM Tables Tables Tablespace Files File System Logical Vol Tablespace Files File System Logical Vol Oracle ASM Disks Disk Group

8 Application Application Application Application Database Database File System Volume Manager Operating System

9 File 2 File 1 F1 F1 F1 F1 F1 F1 F1 F1 F1 F1 F1 F1 F1 F1 F1 F1 F1 F1

10 ASM Disk Groups Disk Group

11 ASM Disk Groups (M bytes, Extent) Disk Group

12 ASM Disk Groups (M bytes, Extent) Disk group Disk Group

13 ASM Disk Groups (M bytes, Extent) Disk group Coarse / fine grain Disk Group

14 ASM Disk Groups Disk Group (M bytes, Extent) Disk group Coarse / fine grain OMF(Oracle Managed Files)

15 Disk Groups & Failure Groups Controller 1 Controller 2 Failure Group 1 Failure Group 2 Disk Group Disk Group Failure Group Disk Group ASM Disk Group DBA Failure Group, Extent Failure group Failure Groups DBA ASM

16 ASM Disk group redundancy External: hardware Normal: 2-way High: 3-way / dirty region logging

17 ASM Extent Primary & Mirror extent

18 ASM Extent Primary & Mirror extent

19 ASM hot spare disk load I/O load

20 ASM Array NVRAM (data redundancy)

21 ASM Coarse striping Fine Grained striping

22 Name Archivelog Autobackup Controlfile Datafile Flashback Onlinelog ParameterFile Tempfile Stripe Coarse Coarse Fine Coarse Fine Fine Coarse Coarse Redundancy Normal Normal Normal Normal Normal Normal Normal Normal

23 ASM (!!) Disk Group

24 ASM (!!) Disk Group

25 ASM (!!) I/O Disk Group

26 ASM (!!) Disk Group

27 ASM (!!) Disk Group

28 ASM (!!) Disk Group

29 ASM (!!) Disk Group

30 ASM ASM Instance Non RAC Database Oracle DB Instance Server Pool of Storage Disk Group

31 ASM ASM Instance ASM Instance RAC Database Clustered Servers Clustered Pool of Storage Oracle DB Instance Oracle DB Instance Disk Group

32 ASM ASM Instance ASM Instance RAC Database Clustered Servers Clustered Pool of Storage Oracle DB Instance Oracle DB Instance Disk Group Disk Group

33 ASM ASM Instance ASM Instance ASM Instance ASM Instance RAC or Non RAC Databases Oracle DB Instance Oracle DB Instance Oracle DB Instance Oracle DB Instance Oracle DB Instance Clustered Servers Clustered Pool of Storage Disk Group Disk Group

34 ASM Volume Manager, File 2. ASM System 3. Disk Group 3. hot spot 4. s/w 4. Logical volumes 5. File system 6. s/w 5. 7.

35 ASM 1. OS 1. OS 2. Volume Manager 2. Add Disk volume 3. volume File System I/O

36 ASM Drop disk File system OS 6. I/O

37 ASM 1. OS 1. OS Add disk 3. Drop 3. Volume Manager Disk volume File system OS 8. I/O

38 ASM I/O 1. I/O This space intentionally left 2. hot spot blank 3. hot spots hot spot

39 ASM 1. This space intentionally left blank 2. Fragmentation 3. Fragmentation Fragmentation

40 ASM = OSM

41 EM ASM

42 ASM Diskgroups Disks Files

43 ASM diskgroups Redundancy External ( ) Normal (2-way ) 2 failure groups High (3-way ) 3 failure groups

44 ASM diskstring Scan ( ) /dev/rdsk* /dev/sd[a-f] osm_diskstring OS specific default /dev/raw/raw* on Linux \\.\PhysicalDrive[1-9]* on Windows

45 ASM init.ora instance_type=asm RDBMS osm_diskgroup=<diskgroup1>, <diskgroup2> Diskgroup startup mount, alter diskgroup mount all

46 Diskgroup #1 create diskgroup group1 disk /dev/raw/raw1 ; create diskgroup group2 external redundancy disk /dev/raw/raw2 ;

47 Diskgroup #2 Create diskgroup dgroup3 failgroup controller0 disk /dev/c0t*, failgroup controller1 disk /dev/c1t* ;

48 V$osm_diskgroup select name, state from v$osm_diskgroup; NAME STATE GROUP1 MOUNTED

49 Diskgroup Drop diskgroup group1; Drop diskgroup group2 including contents;

50 ASM administration Diskgroups Disks Files

51 V$osm_disk osm_diskstring ASM OS device Redundancy

52 V$osm_disk select name, total_mb, free_mb from v$osm_disk; NAME TOTAL_MB FREE_MB GROUP1_

53 Disk alter diskgroup group1 add disk /dev/raw/raw9, /dev/raw/raw10 ;

54 / osm_power_limit=[1-11] alter diskgroup group1 drop disk group1_0000 rebalance power 4;

55 V$osm_operation Mbyte Select sofar, est_rate, est_minutes from v$osm_operation; SOFAR EST_RATE EST_MINUTES

56 ASM administration Diskgroups Disks Files

57 ASM file ASM file (OMF ) create tablespace data datafile +group1/data ; File alter diskgroup group1 drop file +group1/data ;

58 File (3-way, 2-way, None) Coarse (1MB) Fine-grained (8x128k)

59 V$osm_template Select name, redudnancy, stripe from v$osm_template where name=datafile; NAME REDUND STRIPE DATAFILE NORMAL COARSE

60 ASM init.ora instance_type=asm osm_diskstring=/dev/raw/raw* osm_diskgroup=group1 osm_power_limit=1

61 ASM Fixed Tables V$osm_disk V$osm_diskgroup V$osm_file V$osm_alias V$osm_template V$osm_operation V$osm_client

62 Nbr Steps Install Add Storage Remove Storage 4 Migrate Storage Tune I/O 0 0 Manage Space ASM Traditional

63 ASM - File system / Volume manager solution Disk group I/O ( ) Fine / Coarse grain

64 ASM - Software dirty region logging hot spare disk I/O ASM I/O direct I/O(not OS buffering) I/O Mainframe

65 . ASM Grid Computing

66 Q U E S T I O N S A N S W E R S

오라클 데이터베이스 10g 핵심 요약 노트

오라클 데이터베이스 10g 핵심 요약 노트 1 10g 10g SYSAUX 10g 22 Oracle Database 10g, 10g. 10g. (Grid), 10g.. 10g SYSAUX (ASM, Automatic Storage Management) 10g 10g. g. (DBA).,., 1).,..? 10g,.. (Larry Ellison).. (Leverage Components), (ASM) (