Session Title: Automate Data Guard Best Practices
Session Number: 614
Track: Database
Session Type: Lecture
Sub-Categorization: High Availability and Data Protection
Initial Submission: Oct 12, 2012 11:32 AM America/Arizona
Status: Submitted
Session Submitter: Charles Kim
Primary Presenter: Charles Kim [Oracle ACE Director – Viscosity North America]
Co-Presenter: Nitin Vengurlekar [CTO – Viscosity North America]
Co-Presenter 2: [Unassigned]
Co-Presenter 3: [Unassigned]
Last Update: Oct 12, 2012 11:58 AM America/Arizona
   
Abstract: Compliance to industry best practices can easily be achieved with automation. This session will disseminate fundamental Data Guard best practices and demonstrate how DBAs can automate setup, configuration, and monitoring of Data Guard environments with assistance from the Date Guard Toolkit (DG Toolkit).

The original Data Guard Menu (DG Menu) was presented and documented in the Oracle Data Guard 11g Handbook published with Oracle Press. We took the DG Menu to another level and now it is called the DG Toolkit. We included a dedicated set of options for building physical standby with best practices in mind and made this into a mature toolkit that anyone can download from http://dataguardbook.com website. We have significantly updated the monitoring and setup menu options as well.

Come see Data Guard best practices in action. The session concentrates on:
o Building the Physical Standby
o Monitoring and Maintaining the Physical Standby
o Configuring Data Guard Broker
o Performing Backup and Recovery with RMAN
o Setting Archive Retention
o Performing Switchovers and Failovers

   
Learning Objective #1: Most importantly, learn how to build the physical standby with ease and automation using the DG Toolkit
Learning Objective #2: Learn how to monitor the physical standby database with DG Toolkit
Learning Objective #3: Learn how to setup the Data Guard Broker with DG Toolkit
Outline / Content Structure: Perform preliminary check prior to starting the Data Guard Build
1. Perform assessments on the source database
2. Perform assessments on the physical standby

Perform detailed steps to build the physical standby database
1. Look at building the physical standby with easy menu steps
2. Look at duplicating the physical standby database

Configure the Data Guard Broker

Perform monitoring of the Data Guard Environment
1. Monitor the physical standby for performance
2. See how far behind we are

Perform RMAN to disk configuration options

# ————————————————————————- #
# Data Guard Menu System #
# Primary Host: prod1 Standby Host: drdb1 #
# Primary DB: DBATOOLS Standby DB: DRDBATOOLS #
# ————————————————————————- #
# 10. Launch Preliminary Check Submenu #
# ————————————————————————- #
# 20. Launch Build Standby Database Submenu #
# ————————————————————————- #
# 30. Launch the Data Guard Broker Submenu #
# ————————————————————————- #
# 40. Launch Monitor Physical Standby Data Guard Submenu #
# ————————————————————————- #
# 50. Launch Monitor Logical Standby Data Guard Submenu #
# ————————————————————————- #
# 60. Launch Automatic Diagnostic Repository (ADR) CLI Submenu #
# ————————————————————————- #
# 100. Launch RMAN Backup to Disk Submenu #
# ————————————————————————- #
# x. Exit #
# ————————————————————————- #

2nd Track: Manageability
Content Level: Mid-Level
Product Line: Active Data Guard, Oracle Database, Real Application Clusters
Company Type: Consultant
Have you presented at an IOUG event before?: Yes
Speaker Guidelines: Yes