RAC?? ? Backup

1
RAC?? ? Backup
2
? ?

• RAC ???

• Oracle File ??

• Backup ??

3
1. RAC ???
1.1 RAC ???
?? 2
?? 1
Instance 1
Instance 2
SGA
SGA
Dictionary Cache
Log Buffer
Buffer Cache
Dictionary Cache
Log Buffer
Buffer Cache
Distributed Lock Area
Library Cache
Distributed Lock Area
Library Cache
DBWR
LGWR
LCK
LGWR
DBWR
LCK
SMON
PMON
SMON
PMON
?? ?? ??
?? ?? ??
??? ?? ? ??? ??
???? ?? ??
???? ?? ??
?????(Shared Disk )
4
2. Oracle File ??
2.0 ??? ?? File

• Control File
• Data File
• Redo Log File
• Archive Log File
• init Parameter File
• Table ?? Backup File

5
2. Oracle File ??
2.1 Control File

• ?? DB ??, Datafile, Redo Log File ?? ? ??,
  Checkpoint ??, Archive ???.
• Size 100 M
• ?? ?? ?? ?? ??? ??? 3? ??? ???? Disk Fail ?
  ????.

6
2. Oracle File ??
2.2 Redo Log File

• ?? DB ? ?? ?? ??? ????. Commit ? Data File ?
  ?? ?? ?? Redo Log File ? ??? ?? ??. ? ? ???? ???
  Data File ? write ?? ?? ???? DBMS ? down ? ?? ?
  ??? ??? recovery ? ?? ??.
• ?? ? ). 3 Group, 2?? Disk ? mirror

Group 2
Group 3
Group 1
Disk 1
Member
Disk 2
Member
7
2. Oracle File ??
2.2 Redo Log File

• Size ?? ??
• Redo Log ??? ? Data ???. ( 20 byte ??? 40 byte
  ??? redo log ??)
• Redo Log Switch ?? 30?? 1?. ?, ???? ??? ??.
• ? ??? ? ??? peak ?? ??? ???? ?? ?? ??. ? ?? ??
  transaction ? 8?? ???? ?? ? ???? 24 ??? ????
  ??? ?? ?????.
• ?) ? Redo Log ??? 160 Gbytes ? ????
  8 ??. ?? Size
  160 / (82) 10G
• Group ?? Log Switch ? ?? Log File ? Archive ?
  ???? ?? ????? ??? ?? ??. ?
  ??? 5?? ??? ????? 10G ? Archive ??? ??? 2?? ?
  ?? ????? ??.
• Group ? Member ?? ?? ??? ??? ?? File ??? ?? ??
  ???? 3? ? ??
  ???? Disk Fail ? ????.

8
2. Oracle File ??
2.3 Archive Log File

• ?? Redo Log ?? ? ??? ? ???? ?? ? ? ?? ???? ??
  Backup ? ??? ? ??? ??? Archive Log
  File ?? ???? ???? ????.
• ?? ?? RAC ? Instance ?? ?? ??? ????.
• Size Backup ?? ??? ??? ?? Archive ? ??? ? ???
  ????. Data File Hot Backup ?? ???
  Archive ? Tape Device ??? ????. ?) Hot
  Backup ?? 1? 1? Redo ??? 20G
  Archive Log ?? ?? 20G ???.

9
2. Oracle File ??
2.4 Data File

• ?? ?? Data ? ???? ????.
• ?? ?? Disk Fail ? ??? ???? RAID ?? Disk
  Solution ? ????.
• Size Business Requirement ??? ????.

10
2. Oracle File ??
2.5 Sample init.ora
db_nameCORERTL instance_nameCORERTL1
Cache and I/O
(10GBytes)
db_block_size8192 db_cache_size10737418240
db_file_multiblock_read_count16
Cluster
Database
cluster_database_instances2 cluster_databaset
rue CORERTL1.instance_nameCORERTL1 CORERTL2.insta
nce_nameCORERTL2 CORERTL1.instance_number1 CORER
TL2.instance_number2 CORERTL1.thread1 CORERTL2.t
hread2
Redo Log and Recovery
fast_start_mttr_target300

Security and Auditing
remote_login_passwordfileEXCLUSIV
E
System Managed Undo and Rollback
Segments
undo_managementAUTO undo_retention10800 undo_
tablespaceUNDOTBS1
11
2. Oracle File ??
2.5 Sample init.ora

Sort (10M)
sort_area_size10485760
Processes and
Sessions
processes3000
Cursors and Library
Cache
open_cursors1000
Pools (1GBytes)
shared_pool_size1073741
824 HPUX_SCHED_NOAGE178
12
2. Oracle File ??
2.6 Table ?? Backup File ( Export File or SAM
File )

• Export
• Test ?? 2,214,592,512 Byte Table ? 2,051,716,096
  
• Index ??? Data Size ? 92.6
• SAM File
• Test ?? 2,214,592,512 Byte Table ? 1,725,159,800
• Index ??? Data Size ? 77.9
• ?, ? ? ?? ? ??? ??? Size ? ??? ? ??.
• 1 Tera ??
• Export 926 GBytes
• SAM 778 Gbytes
• Export or SAM ??? ???? Machine ? File System ??
  Mount ??? ?.

13
2. Oracle File ??
2.7 Tablespace ???

• ?? Option
• EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
  SEGMENT SPACE MANAGEMENT AUTO
• Disk ??
• Index ? Table Data ? ?? ?? Disk ??? ?????
  tablespace ? ????.
• Disk Contention ??? ??.
• ?? ??? Tablespace ? ??? ?? ??? ??? Tablespace ?
  ??? ??? ??.
• ?? ??? Backup Recovery ?? ???? ??
• ?) ?? Table Data ? DATA_TS01
  Index Data ? INDX_TS01 ?? Table Data ?
  DATA_TS02 Index Data ?
  INDX_TS02 ?? Table Data ? DATA_TS03
  Index Data ? INDX_TS03
• UNDO Tablespace ?? 10G

14
3. Backup ??
3.1 ?? ??

• ??? Reference ??? ?? ??
• ? ?? SKT, KT ? ??? BCV ? ?? Set ? ???.

15
3. Backup ??
3.2 Exp / SAM File ?? ??.

• Test Machine ??
• Model RP 8400 , CPU 8
• Memory 12G, Disk Hitachi XP128
  (4.5TBytes2)
• Test ??.
• ?? Table CIFHST_TRT, Size 2,214,592,512 Bytes

Size ?? ?? ??
Export (Single Process) 2,051,716,096 117? 18 MB/Sec
Export (Parallel 2?) x 2 124? 34 MB/Sec
Export (Parallel 3?) x 3 127? 50 MB/Sec
Export (Parallel 4?) x 4 140? 60 MB/Sec
Dumper (SAM) 1,725,159,800 434? 4.8 MB/Sec

• 4 ??? ??? ?? Backup ?? 72.8 MB/Sec
• Export ? Parallel ? ? ?? ??? ? ??? ?? ? ??? Test
  ?? ?.
• ??) SAM ?? ?? load ?? ?? 195?,
• ??) export ?? ?? import ?? ?? 500?, import ?
  2.5 ? ?? ??