Recovery Managerのバックアップおよびリカバリの最適化

Size: px

Start display at page:

Download "Recovery Managerのバックアップおよびリカバリの最適化"

としみいちぞの
5 years ago
Views:

1 Recovery Manager

2 Recovery Manager... 3 Recovery Manager... 4 Recovery Manager I/O I/O / Recovery Manager 2

3 Recovery Manager Oracle Database 10g DURATION Recovery Manager Recovery Manager 6 Recovery Manager RMAN Oracle RMAN SUSE Linux Enterprise Server 2Way Intel Oracle Database 10g R CPU CPU used by this session#12 v$sesstat Recovery Manager CPU : Oracle Recovery Manager 3

4 Recovery Manager Recovery Manager DBA Oracle Oracle8 Oracle Recovery Manager RDBMS Recovery ManagerOracle Database Recovery Manager : I/O V$BACKUP_SYNC_IO I/O V$BACKUP_ASYNC_IO Recovery Manager DBA Recovery Manager SPFILE SPFILE Recovery Manager MML Recovery Manager Recovery Manager 4

5 I/O I/O Mb/Sec = min Mb/s Mb/s Recovery Manager type= INPUT effective_bytes_per_second sar OS type= OUTPUT effective_bytes_per_second I/O MML 1 Recovery Manager 1 1 MML 2 3 Recovery Manager 5

6 Recovery Manager Oracle Database 2 filesperset BS BS CPU : filesperset filesperset MML filesperset Recovery Manager 6

7 1 Recovery Manager Recovery Manager 1 1: Oracle Database < 4 =1Mb 16Mb 4 8 =512k 16Mb > 8 =128k 4 512Kb 2: MAXOPENFILES Recovery Manager 8 Recovery Manager 7

8 MAXOPENFILES MAXOPENFILES Kb 1 MB : SELECT set_count, device_type, type, filename, buffer_size, buffer_count, open_time, close_time FROM v$backup_async_io ORDER BY set_count,type, open_time, close_time; Oracle v$backup_async_io 3 DISK 4 1Mb 4Mb SBT 4 256Kb 1Mb 4: Mb 2 Recovery Manager 8

9 Smaller buffer ( 32k * 4 = 128Kb buffer): configure channel device type sbt parms= BLKSIZE=32768'; Larger buffer ( 512k * 4 = 2Mb buffer): configure channel device type sbt parms='blksize= ; I/O I/O , ,048, ,097, : I/O I/O PGA I/O I/O I/O LARGE_POOL_SIZE I/O I/O I/O I/O BACKUP_TAPE_IO_SLAVES I/O Recovery Manager 9

10 1 / : Recovery Manager SELECT set_count, set_stamp, file#, data file_blocks, blocks BACKUP_BLOCKS FROM v$backup_data file ORDER BY set_count, file#; 500Mb Recovery Manager 10

11 % 100% % <0.79% : % 2GB Oracle Database 10g 0 DML : v$backup_data USED_CHANGE_TRACKING Recovery Manager 11

12 Recovery Manager Recovery Manager db_block_checksum Recovery Manager NOCHECKSUM SYSTEM Recovery Manager db_block_checking BACKUP CHECK LOGICAL CPU : 8 DB_BLOCK_CHECKSUMS init.ora TRUE Recovery Manager Recovery Manager CHECK LOGICAL Recovery Manager Recovery Manager 12

13 Recovery Manager CPU : Oracle Database 10g RMAN Oracle Database 10g 50% CPU MMLRecovery Manager Recovery ManagerMML Recovery ManagerMMLCPU CPU Mb CPU : Recovery Manager CPU 2 Recovery Manager Recovery Manager Recovery Manager 13

14 0 Recovery Manager / Recovery Manager Recovery Manager ARCHIVELOG REDO ARCHIVELOG 0 DML Recovery Manager 0 Recovery Manager RECOVER AUTOMATIC DATABASE SQL*Plus Recovery Manager 14

15 REDO REDO Oracle9i 102,400 8Kb 0 TPCC 34, : 11 10% 10,000 Recovery Manager MML Recovery Manager 15

16 PARALLEL_AUTOMATIC_TUNING init.ora Oracle REDO DBWR REDO Oracle CPU RECOVER REDO SCN REDO REDO SCN IPC v$session_wait v$system_event PX Deq REDO CPU CPU sar u CPU init.ora PARALLEL_AUTOMATIC_TUNING FALSE 2,148 PARALLEL_AUTOMATIC_TUNING TRUE Recovery Manager 16

17 4096 PARALLEL_EXECUTION_MESSAGE_SIZE init.ora MAA I/O REDO OS v$filestat I/O DBWR DBWR DBWR DBWR free buffer waitsi/o DBWR OS I/O I/O DBWR CPU REDO lru CPU CPU CPU CPU CPU Recovery Manager 17

18 1 Recovery Manager REDO REDO Recovery Manager 18

19 SLA Recovery Manager 19

20 Recovery Manager : Stephan Haisley : RMAN Development Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA U.S.A. : : : Copyright 2005, Oracle. All rights reserved. Oracle Oracle Corporation

Oracle Database 10gのOracle Data Guard

Oracle Database 10gのOracle Data Guard Oracle Database 10g Oracle Data Guard 2004 Oracle Data Guard... 3... 3... 3 Oracle Data Guard... 4 Oracle Data Guard... 4 Oracle Data Guard... 4 Oracle Data Guard... 5 Oracle Data Guard... 6 Oracle Data