Oracle Database 11g × Hitachi Storage Solutionsのベストプラクティス

Size: px

Start display at page:

Download "Oracle Database 11g × Hitachi Storage Solutionsのベストプラクティス"

ようたちゅうか
5 years ago
Views:

1 - 1 -

2 ORACLE11G DATABASE REPLAY DB DATABASE REPLAY DB ORACLE DATABASE 11G DATABASE REPLAY Database Replay Database Replay HITACHI STORAGE SOLUTIONS Hitachi Universal Storage Platform V Hitachi Adaptable Modular Storage ShadowImage Copy-on-Write Snapshot DATABASE REPLAY DB DATABASE REPLAY DB DATABASE REPLAY PSR DB

3 A A A B. DB B B C. DATABASE REPLAY C C2. AWR D. DATABASE REPLAY 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 -

4 1-4 -

5 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 DB DB DB DB - 5 -

6 DB Oracle Recovery ManagerRMAN DB DB 100GByte TByte DB I/O 3. DB DB DB DB 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 DB DB ShadowImage ShadowImage DB DB DB DB ShadowImage DB DB DB DB Copy-on-Write SnapshotCopy-on-Write Snapshot DB Copy-on-Write Snapshot DB - 6 -

7 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 -

8 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 Database Replay Database Replay 1. DB DB Database Replay DB DB 2. Database Replay 3. Database Replay DB DB - 8 -

9 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 Database Replay 1 # 1 / Commit Commit Commit RAC CPU 2 3 () 4 Single RAC - 9 -

2000AMS2000 USP V AMS2000 ShadowImageCopy-on-Write Snapshot 3.2.1 Hitachi Universal Storage Platform V

10 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 Hitachi Universal Storage Platform V Hitachi Universal Storage Platform VHitachi Universal Storage Platform(USP) Hitachi Adaptable Modular Storage 2000 Hitachi Adaptable Modular Storage 2000 SAS SATA

11 3.2.3 ShadowImage ShadowImage ShadowImage ShadowImage 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

12 -restore

13 3.2.4 Copy-on-Write Snapshot Copy-on-Write Snapshot ShadowImage ShadowImage Copy-on-Write Snapshot Copy-on-Write Snapshot AMS At-time LU a single point in time 3Copy-on-Write Snapshot 3 Copy-on-Write Snapshot

14 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

15 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

16 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

17 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 I/O DB DB Copy-on-Write Snapshot Oracle DB Flashback Database Oracle DB I/O Snapshot ShadowImage Flashback 6Copy-on-Write Snapshot TPC-C CPU 100% Copy-on-Write Snapshot 6% Copy-on-Write Snapshot 20 Copy-on-Write Snapshot Copy-on-Write Snapshot

18 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 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

19 DB DB

20 5.2 Client Shadow Image () ShadowImage USP V 8 4 DB

21 Client Shadow Image () Copy-on-Write Snapshot Copy-on-Write Snapshot USP V

22 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

23 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

24 7 Oracle Database 11g Database Replay Database Replay 2 ShadowImage DB DB Database Replay Copy-on-Write Snapshot DB Database Replay Oracle Database

25 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

26 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 -

27 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

28 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

29 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

30 Phase 2 () Phase ShadowImage Step 2-1 Enterprise Manager Top

31 Step 2-2 Enterprise Manager

32 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

33 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

34 Phase 4 () Copy-on-Write Snapshot Copy-on-Write Snapshot DB Step 4-1 Step 4-2 ShadowImage DB ENTERPRISE MANAGER

35 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

36 Phase 5 () Enterprise Manager Step 5-1 Enterprise Manager

37 Step 5-2 Step 5-3 $> wrc mode=replay rplaydir=

Phase 7 Step 6-1 DB ASM DB ASM Step 6-2 Copy-on-Write Snapshot

38 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

39 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

40 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

41 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

42 C. Database Replay Database Replay AWR C1. DB SQL () /

43 () SQL

44 C2. AWR AWR AWR AWR AWR () AWR ()

45 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

46 D-1 # ID ID ID ID 1 update TBL_A set ID = ID ## 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; / update TBL_A set ID = 2; ## 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

47 Microsoft, Windows, Windows NT Microsoft Corporation OracleJD EdwardsPeopleSoft Siebel

オラクルのバックアップとリカバリの必須要件

オラクルのバックアップとリカバリの必須要件 WHITE PAPER 1 WHITE PAPER...3...3...4 NetBackup Oracle...6...7 VERITAS NetBackup Oracle Agent...7 VERITAS NetBackup Oracle Agent...8 VERITAS NetBackup Oracle...8...9 GUI RMAN...9 VERITAS NetBackup Oracle