- 1 -
1... 4 2... 5 2.1 ORACLE11G DATABASE REPLAY... 5 2.1.1 DB... 5 2.1.2... 6 2.2 DATABASE REPLAY... 6 2.2.1 DB... 6 2.2.2... 6 3... 8 3.1 ORACLE DATABASE 11G DATABASE REPLAY... 8 3.1.1 Database Replay... 8 3.1.2 Database Replay... 9 3.1.3... 9 3.1.4... 10 3.2 HITACHI STORAGE SOLUTIONS... 10 3.2.1 Hitachi Universal Storage Platform V... 10 3.2.2 Hitachi Adaptable Modular Storage 2000... 10 3.2.3 ShadowImage...11 3.2.4 Copy-on-Write Snapshot... 13 4 DATABASE REPLAY... 14 4.1 DB... 14 4.2 DATABASE REPLAY... 15 4.3 DB... 15 4.4... 16 5... 19 5.1... 19 5.2... 20 6 DATABASE REPLAY... 22 6.1... 22 6.2... 22 6.3 PSR... 23 6.4 DB... 23 7... 24-2 -
A.... 25 A1.... 25 A2.... 27 B. DB... 40 B1.... 40 B2.... 41 C. DATABASE REPLAY... 42 C1.... 42 C2. AWR... 44 D. DATABASE REPLAY... 45 DB DB DB RAC RAT PSR USP V AMS Database Oracle Real Application Clusters Oracle Database DB 1 Oracle Real Application Testing Oracle Database 11g Enterprise Edition Option 11g Patch Set Release Oracle Database Hitachi Universal Storage Platform V Hitachi Adaptable Modular Storage - 3 -
1-4 -
2 IT IT DB DB DB DB DB DB SQL DB DB DB DB DB DB 2.1 Oracle11g Database Replay Oracle Database 11g DB DB Database Replay Database Replay DB DB SQL DB A B Database Replay DB DB A B DB Database Replay SQL SQL Database Replay DB DB DB DB SQL DB SQL 2.1.1 DB DB DB DB - 5 -
DB Oracle Recovery ManagerRMAN DB DB 100GByte TByte DB 1. 2. I/O 3. DB DB DB DB 2.1.2 Database Replay PSR DB DB DB DB Oracle Flashback Database DB 2 DB Flashback Database Flashback Database DB Flashback Database 1. DB I/O DB DB DB DB 2.2 Database Replay Database Replay 2.2.1 DB DB ShadowImage ShadowImage DB DB DB DB ShadowImage DB DB DB DB 4.3 2.2.2 Copy-on-Write SnapshotCopy-on-Write Snapshot DB Copy-on-Write Snapshot DB - 6 -
DB I/O Copy-on-Write Snapshot DB 4.4 Database Replay ShadowImage Copy-on-Write Snapshot DB Oracle Database 11g Database Replay Database Replay ShadowImageCopy-on-Write Snapshot 4-7 -
3 Oracle Database 11g Database Replay ShadowImageCopy-on-Write Snapshot 3.1 Oracle Database 11g Database Replay Oracle Database 11g Database Replay 1 DB DB 1 Database Replay 3.1.1 Database Replay Database Replay 1. DB DB Database Replay DB DB 2. Database Replay 3. Database Replay DB DB - 8 -
3.1.2 Database Replay Database Replay Step 1. DB DB DB DB DB DB DB DB DB DB Step 2. DB ID Step 3. Step 4. DB SQL Step 5. 3.1.3 Database Replay 1 # 1 / Commit Commit Commit RAC CPU 2 3 () 4 Single RAC - 9 -
3.1.4 Database Replay DB SQL 1 2 C 3.2 Hitachi Storage Solutions Hitachi Universal Platform VUSP V Hitachi Adaptable Modular Storage 2000AMS2000 USP V AMS2000 ShadowImageCopy-on-Write Snapshot 3.2.1 Hitachi Universal Storage Platform V Hitachi Universal Storage Platform VHitachi Universal Storage Platform(USP) 128 4 1152 3.2.2 Hitachi Adaptable Modular Storage 2000 Hitachi Adaptable Modular Storage 2000 SAS SATA - 10 -
3.2.3 ShadowImage ShadowImage ShadowImage ShadowImage 1. 2. RAID I/O 3. At-time LU a single point in time LU 2ShadowImage 1 RAID Manager VOL VOL ShadowImage 2 ShadowImage ShadowImage Write I/O 1 RAID Manager ShadowImage - 11 -
-restore - 12 -
3.2.4 Copy-on-Write Snapshot Copy-on-Write Snapshot ShadowImage ShadowImage Copy-on-Write Snapshot Copy-on-Write Snapshot 1. 2. 1 32 AMS 15 3. At-time LU a single point in time 3Copy-on-Write Snapshot 3 Copy-on-Write Snapshot - 13 -
4 Database Replay DB 4.1 DB 4DB DB AP / AP / AP / 4 DB AP SQL DB DB PSR PSR 1 PSR 4 DB RAC DB - 14 -
Oracle Database DB Database Replay DB DB DB DB 4.2 Database Replay Database Replay DB DB Database Replay 1. DB DB DB DB 2. DB DB ShadowImageCopy-on-Write Snapshot 2ShadowImageCopy-on-Write Snapshot 2 Database Replay DB DB DB Flashback Database I/O DB Shadow Image Copy -on-write Snapshot DB I/O DB DB 4.3 DB Database Replay DB DB DB DB DB ShadowImage ShadowImage DB DB - 15 -
5Oracle Oracle Recovery ManagerRMAN DB ShadowImage DB DB 26GByte 10 B RMAN DB ShadowImage DB 100GByte TByte DB 5DB 2 RMAN DB ShadowImage DB DB 4.4 DB DB DB DB DB DB 1. RMAN 2. ShadowImage 3. Oracle Flashback Database 4. Hitachi Copy-on-Write Snapshot 1 RMAN 2 ShadowImage DB DB 2 ShadowImage - 16 -
DB DB ShadowImage DB DB 1 3 Flashback Database DB Flashback Database DB Flashback Database Flashback Database 1 3 Flashback Database Flashback I/O CPU DB DB Flashback Database DB DB Flashback Database DB DB Database Replay Flashback 4 Copy-on-Write Snapshot DB Copy-on-Write Snapshot DB 1 3.3 I/O DB DB Copy-on-Write Snapshot Oracle DB Flashback Database Oracle DB I/O Snapshot ShadowImage Flashback 6Copy-on-Write Snapshot 20 20 TPC-C CPU 100% Copy-on-Write Snapshot 6% Copy-on-Write Snapshot 20 Copy-on-Write Snapshot Copy-on-Write Snapshot 3-17 -
6 Copy-on-Write Snapshot Database Replay ShadowImage Copy-on-Write Snapshot DB DB Copy-on-writer Snapshot Hitachi AMS 2000 Hitachi Adaptor Modular Storage 2000AMS2000ShadowImage ShadowImage Copy-on-Write Snapshot 2009 1 AMS2000 ShadowImage Copy-on-Write Snapshot 1. DB TrueCopy DB AMS2000 DB TrueCopy TrueCopy Copy-on-Write Snapshot 2. Flashback Database Copy-on-Write Snapshot Flashback Database - 18 -
5 5.1 7 3 DB DB 7 3-19 -
5.2 Client Shadow Image () ShadowImage USP V 8 4 DB - 20 -
Client Shadow Image () Copy-on-Write Snapshot Copy-on-Write Snapshot USP V 9-21 -
AP1AP2AP3 AP3 6 Database Replay 4 Oracle Database Database Replay 6.1 DB DB AP1AP2AP3 DB AP1 Database Replay Database Replay DB 10 Database Replay DB AP2 AP3 AP1 AP2AP3 AP1 Client AP2AP1 Replay 10 Database Replay 6.2 Oracle Database 10g SQL SQL Oracle DB - 22 -
Database Replay DB 5.2 Step DB Copy-on-Write Snapshot DB 6.3 PSR PSR Database Replay Database Replay Oracle Database Replay Database Replay Oracle Database 11g Oracle Database 9i Release2 10g Release2 11g Database Replay 6.4 DB DB Database Replay RAC REDO Flashback Database Flashback I/O Partitioning Option Advanced Security Option Advanced Compression Option - 23 -
7 Oracle Database 11g Database Replay Database Replay 2 ShadowImage DB DB Database Replay Copy-on-Write Snapshot DB Database Replay Oracle Database - 24 -
Database Replay ShadowImage DB A. A1. DB DB ASM DiskGroup 1 ( REDO ) ASM DiskGroup 1 ( REDO ) ASM DiskGroup 2 (SYSTEMSYSAUX UNDO,,TEMP, ) ShadowImage () ASM DiskGroup 2 (SYSTEMSYSAUX UNDO,,TEMP, ) Copy-on-Write Snapshot ASM DiskGroup 3 ( REDO ) ShadowImage () ASM DiskGroup 3 ( REDO ) () ShadowImage () Copy-on-Write Snapshot (ASM DiskGrup2 USP-V () () A-1 ShadowImage Copy-on-Write Snapshot A-1-25 -
DB DB DB DB DB ASM DiskGroup 1 Online Redo ShadowImage A-1 A-1 ASM DiskGroup 1 # 1 REDO ShadowImage DB REDO 2 ASM DiskGroup 2 SYSTEM SYSAUX UNDO TEMP ShadowImage Copy-on-Write Snapshot ASM DiskGroup 3 REDO ShadowImage Database Replay ShadowImage Copy-on-Write Snapshot (ASM DiskGroup 2 ) ASM DiskGroup 2 Copy-on-Write Snapshot Copy-on-Write Snapshot DB Copy-on-Write Snapshot ASM DiskGroup2-26 -
A-2 ShadowImage Copy-on-Write Snapshot # 1 DB DB ASM DiskGroup 2 ASM DiskGroup 2 2 ShadowImage ASM DiskGroup 3 ASM DiskGroup 3 3 DB Copy-on-Write Snapshot ASM DiskGroup 2 Copy-on-Write Snapshot (ASM DiskGroup2 ) A2. Phase Phase 0 Phase 1 DB () Phase 2 () Phase 3 DB () Phase 4 () Phase 5 () Phase 6 DB () Phase 7 Phase Phase 0 Phase Phase Step 0-1 Disk ShadowImage Disk Step 0-2 DB Step 0-3 DB Oracle Database DB Oracle Database Step 0-4 DB ASM ASM DiskGroup DB dbca ASM ASM DiskGroup 13 Step 0-5 DB DB ShadowImage Step 0-6 DB DB DB dbca DB DB () DB DB DB - 27 -
DB DB ASM Step 0-7 Oracle Database Oracle Database Step 0-8 DB ShadowImage ShadowImage DB (ASM DiskGroup 23) Disk () ShadowImage Phase1 A-3 A-3 Phase1 # DB DB 1 ASM 2 DB 3 4 ASM DiskGroup 1 DiskGroup REDO DiskGroup REDO 5 ASM DiskGroup 2 DiskGroup ShadowImage ShadowImage 6 ASM DiskGroup 3 DiskGroup Redo ShadowImage 7 ( ) 8 Copy-on-Write Snapshot (ASM DiskGroup 2 ) ShadowImage ShadowImage ShadowImage Phase 1 DB () Phase DB DB Phase Step 1-1 DB ShadowImage DB (ASM DiskGroup23) Disk ShadowImage I/O Step 1-2 ASM ASM ASM_POWER_LIMIT 0 ASM Disk Step 1-3 DB Step 1-4 DB ShadowImage - 28 -
ShadowImage (ASM DiskGroup 2) Disk Step 1-5 Step 1-3 DB Step 1-6 REDO REDO REDO Step 1-7 RMAN Step 1-8 DB ShadowImage ShadowImage REDO (ASM DiskGroup 3) Disk Step 1-9 ASM Step 1-2 ASM_POWER_LIMIT Step 1-10 Step 1-7 - 29 -
Phase 2 () Phase ShadowImage Step 2-1 Enterprise Manager Top - 30 -
Step 2-2 Enterprise Manager - 31 -
Step 2-3 Enterprise Manager AWR AWR Step 2-4 AWR AWR Enterprise Manager Step 2-5 DB Step 2-6 ShadowImage Disk ShadowImage Step 2-7 ShadowImage Step 2-6 Disk ShadowImage Step 2-8 DB Step 2-5 Phase 3 DB () ShadowImage DB DB ShadowImage DB DB Step 3-1 Step 3-2 ASM ASM - 32 -
Step 3-3 DB nomount Step 1-7 Step 3-4 DB DB mount REDO DB REDO TEMP Step 3-5 DB DB resetlogs Step 3-6 Enterprise Manager emca Enterprise Manager dbcontrol - 33 -
Phase 4 () Copy-on-Write Snapshot Copy-on-Write Snapshot DB Step 4-1 Step 4-2 ShadowImage DB ENTERPRISE MANAGER - 34 -
Step 4-3 Step 4-4 DB ASM DB ASM Step 4-5 Copy-on-Write Snapshot DB Step 4-6 ASM ASM Step 4-7 DB mount RMAN Step 4-6 DB DB - 35 -
Phase 5 () Enterprise Manager Step 5-1 Enterprise Manager - 36 -
Step 5-2 Step 5-3 $> wrc sysman/password@ratsol mode=replay rplaydir= - 37 -
Step 5-3 Enterprise Manager Step 5-4 Step 5-5 Step 5-6 Enterprise Manager Phase 6 DB () Phase DB DB Phase 5 Phase Phase 7 Step 6-1 DB ASM DB ASM Step 6-2 Copy-on-Write Snapshot Step4-5 DB Step 6-3 ASM ASM Step 6-4 DB nomount Step 4-7 Step 6-5 DB - 38 -
DB mount DB Step 6-6 DB DB resetlogs Phase 7 Phase Phase1 Step 7-1 DB ASM EnterpriseManagerDB ASM Step 7-2 Copy-on-Write Snapshot DB ShadowImage Step 7-2 DB Database ReplayShadowImage - 39 -
B. DB Database Replay DB DB DB ShadowImage DB ShadowImage B1. DB HA8000/270 ASM ASM DiskGroup +REDO REDO, TEMP ASM DiskGroup +DATA SYSTEM SYSAUX,UNDO ASM DiskGroup +REDO REDO, TEMP ASM DiskGroup +DATA SYSTEM SYSAUX,UNDO 20G Byte LU 20G Byte LU 20G Byte LU 20G Byte LU 20G Byte LU 20G Byte LU Hitachi AMS2300 ShadowImage B-1 B-1 B-1 # 1 DB 26GByte 2 11GByte 3 4 5-40 -
B2. ShadowImage DB RMAN DB DB B-2 # 1 ( ) 2 DB B-2 DB DB RMAN ShadowImage RMAN ASM RMAN DB REDO ShadowImage DB ASM RMAN REDO DB nomount DB nomount DB DB DB DB DB B-2 RMAN DB ShadowImage Disk B-2 DB DB 26G DB B-2 DB DB - 41 -
C. Database Replay Database Replay AWR C1. DB SQL () / - 42 -
() SQL - 43 -
C2. AWR AWR AWR AWR AWR () AWR () - 44 -
D. Database Replay Database Replay 1. DB Database Replay DB DB DB DB DB SQL 2. Database Replay pro*c SELECT DML D-1 #4 SELECT DML SELECT SELECT DML SQL fetch 3. Database Replay 2 Commit Commit Commit Commit DB fetch fetch - 45 -
D-1 # ID ID ID ID 1 update TBL_A set ID = ID + 1 1 2 11 12 2 ## PL/SQL ### declare v_id number; begin select ID int v_id from TBL_A; v_id := v_id + 1; update TBL_A set ID = v_id; end; / 2 12 3 update TBL_A set ID = 2; 2 2 4 ## PRO*C ### 2 long v_id; EXEC SQL select ID into :v_id from TBL_A; EXEC SQL update TBL_A SET ID := v_id +1; EXEC SQL COMMIT; 2 update - 46 -
Microsoft, Windows, Windows NT Microsoft Corporation OracleJD EdwardsPeopleSoft Siebel - 47 -