Recovery Manager 2005 7
Recovery Manager... 3 Recovery Manager... 4 Recovery Manager... 4... 4... 5... 5... 5... 6... 6... 6... 7... 7... 8... 9 I/O I/O... 9... 10... 12... 12... 12... 13... 14 /... 14... 15... 15... 16... 17... 18 Recovery Manager 2
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 R10.1.0.3 CPU CPU used by this session#12 v$sesstat Recovery Manager CPU : Oracle Recovery Manager 3
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
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
3 2 1 1 Recovery Manager Oracle Database 2 filesperset 0 1 1 BS BS CPU 8 702320 97727 132 39.42 4 658221 97727 110 36.92 2 132773 97727 82 29.92 1 97730 97727 74 25.62 1: filesperset filesperset MML filesperset Recovery Manager 6
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
MAXOPENFILES MAXOPENFILES Kb 1 MB 1 8192 1024 16 1 16 2 8192 1024 8 2 16 3 8192 1024 5 3 15 4 8192 512 8 4 16 5 8192 512 6 5 15 6 8192 512 5 6 15 7 8192 512 4 7 14 8 8192 512 4 8 16 9 8192 128 4 9 4.5 10 8192 128 4 10 5 3: 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: 1 3 1 1Mb 2 Recovery Manager 8
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=524288 ; I/O I/O 100 131,072 60564 6174 1,048,576 7571 5959 2,097,152 3786 5053 5: 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
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
% 100% 64000 8 22 50% 64000 31678 31 <0.79% 64000 63496 49 6: 49 8 45% 2GB Oracle Database 10g 0 DML 1 1 404160 404160 36567 156 404160 72832 37215 35 7: v$backup_data USED_CHANGE_TRACKING Recovery Manager 11
Recovery Manager Recovery Manager db_block_checksum Recovery Manager NOCHECKSUM SYSTEM Recovery Manager db_block_checking BACKUP CHECK LOGICAL CPU 825920 623.67 227.08 825920 622.33 229.93 825920 624.67 245.81 8: 8 DB_BLOCK_CHECKSUMS init.ora TRUE Recovery Manager Recovery Manager CHECK LOGICAL Recovery Manager Recovery Manager 12
Recovery Manager CPU 825920 559 210.53 825920 559 211.14 825920 610 218.53 9: Oracle Database 10g RMAN Oracle Database 10g 50% CPU MMLRecovery Manager Recovery ManagerMML Recovery ManagerMMLCPU CPU Mb CPU 778109 6079 559 209.37 778109 517 1133 1093.37 10: Recovery Manager CPU 2 Recovery Manager Recovery Manager Recovery Manager 13
0 Recovery Manager / Recovery Manager Recovery Manager ARCHIVELOG REDO ARCHIVELOG 0 DML 10 20 0 Recovery Manager 0 Recovery Manager RECOVER AUTOMATIC DATABASE SQL*Plus 789 46 Recovery Manager 14
REDO REDO 10 100 Oracle9i 102,400 8Kb 0 TPCC 34,113 10 941 145 99 925 155 991 937 219 5000 922 616 10000 938 1156 11: 11 10% 10,000 Recovery Manager MML Recovery Manager 15
20 2 100 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
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
1 Recovery Manager REDO REDO Recovery Manager 18
SLA Recovery Manager 19
Recovery Manager 2005 7 : Stephan Haisley : RMAN Development Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. : : +1.650.506.7000 : +1.650.506.7200 www.oracle.com Copyright 2005, Oracle. All rights reserved. Oracle Oracle Corporation