Oracle Database RAT Upgrade Aug2017 Copyright 2015 Oracle

Oracle Database RAT를 통한 Upgrade 방법론 Aug-2017 / 나래인포시스템즈 Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Agenda Oracle Real Application Testing(RAT) What is RAT ? 적용 가능 DB 버전 및 분야 구성도 RAT 실제 적용 결과 및 리포트 Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 2

What is RAT ? Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 3

Oracle RAT - Database Replay End-to-end testing with real workloads Create Test 데이터베이스 변경에 대한 위험을 사전에 감소 Capture Workload System 테스트에 필요한 비용/시간을 대폭 절감 실제 운영 환경의 부하를 캡쳐하여 테스트에서 재생 데이터베이스 통합을 위한 부하 분석 제공 부하 Capture, Replay 및 보고서에 대한 자동화 된 프로세스 제공 Replay Workload Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Deploy Replay Clients

적용 가능 DB 버전 및 분 야 Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 7

Oracle RAT - DB Replay 지원 DBMS 버전 Upgrade From Upgrade To 11 g R 2 or 12 c 11 g R 1 (one-off patch 8712466 + 9373986) 11 g R 2 or 12 c 10 g R 2 (one-off patch 9373986) 11 g or 12 c 9. 2. 0. 8 11 g or 12 c Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT - DB Replay 적용 가능 분야 AS-IS TO-BE Lower DB Version Higher DB Version . UNIX Linux . Lower OS Version Higher OS Version . Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

구성도 (Testbed) Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 10

Oracle RAT – 구성도(Testbed) Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

RAT 실제 적용 결과 및 리포 트 Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 12

Oracle RAT - Database Replay DB 변경 전후의 결과분석 실 운영 서버의 전체 부하를 테스트 서버에서 재생 실질적인 부하테스트가 빠르면 일주일 이내에 완료됨 Capture Application Workload DB Replay 실행 Flow EM ① 테스트서버 구축 ② 운영서버에서 부하 Capture ③ Capture 파일 테스트 서버로 이동 ④ Capture 파일 전처리 (Pre-Processing) Upgrade Pre-process ⑤ 테스트 서버에서 Replay ⑥ Capture와 Replay의 Workload 분석 및 리포팅 Workload Replay Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Enterprise Manager Cloud Control 12 c Oracle RAT를 완벽히 사용하기 위해서는 Oracle Enterprise Manager Cloud Control을 사용하여야 함. Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Add Host Server EMCC에 Host Node에 Agent를 설치 또는 배포 합니다. Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Add Oracle DB Instance & Listener EMCC에 등록된 Host Node를 검색하여 DB Instance와 Listener를 EMCC에 등록 함. Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Add Oracle DB Instance & Listener Performance DB Re. Play 선택하여 캡쳐를 진행 Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Capture Node Workload SCN을 기반으로 Workload를 캡쳐 함. Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Replay Workload 사전에 만들어 놓은 12 c DB에 Capture된 Workload를 재생 Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Generate Report Replay가 종료 되면 EMCC가 자동으로 Report를 생성 Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Report (Database Replay Report) Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Report (Compare Period ADDM Report) Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Report (SQL Performance Analyzer Report_1) Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Report (SQL Performance Analyzer Report_1) Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Report (Replay Compare Period Report) Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Report (AWR Compare Period Report) Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Report (Replay ASH Analytics Report) Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Report (ASH Analytics Report by Wait Class) Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Oracle RAT – Report (ASH Analytics Report by Service) Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Q&A Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 30