1 / 27

Implementing Oracle9i Data Guard

Session id: 36226. Implementing Oracle9i Data Guard. Michael New Senior Technical Consultant ThinkSpark. Data Guard - Outline. Concepts Architecture Best practices Implementation. Concepts. Differentiate High Availability approaches Enhanced protection modes Maximum Protection

thisbe
Download Presentation

Implementing Oracle9i Data Guard

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Session id: 36226 Implementing Oracle9i Data Guard Michael NewSenior Technical Consultant ThinkSpark

  2. Data Guard - Outline • Concepts • Architecture • Best practices • Implementation

  3. Concepts • Differentiate High Availability approaches • Enhanced protection modes • Maximum Protection • Maximum Availability • Maximum Performance • Standby Redo Logs (SRLs) • Automatic gap resolution • Data Guard broker • Data Guard Manager (OEM) • Command-line interface (CLI)

  4. Concepts Protection Mode Data loss Divergence Maximum Protection Maximum Availability Maximum Performance None None None Some Minimal Yes

  5. Architecture Source: Oracle9i Data Guard Concepts and Administration

  6. Architecture • Log Transport (LGWR, ARC, FAL, RFS) • Archive log permissions, destinations, transmission, reception & transmission failure resolution • LGWR or ARC can write from primary to standby • Log Apply (MRP or LSP) • Managed recovery (not read-only) mode • SQL apply mode • Role Management • Primary or Standby • Switchovers, graceful or forced failovers • Data Guard Broker (DMON)

  7. FORCE LOGGING • Identical sites • init.ora • Oracle Net • SRLs • Monitoring Best Practices • FORCE LOGGING mode • Identical sites • Initialization parameters • Oracle network • Standby redo logs (SRLs) • Monitoring

  8. Æ • FORCE LOGGING • Identical sites • init.ora • Oracle Net • SRLs • Monitoring FORCE LOGGING Mode • New feature to Release 9.2 • Prevents unlogged direct writes from propagating to standby • Overrides NOLOGGING transactions

  9. FORCE LOGGING • Identical sites • init.ora • Oracle Net • SRLs • Monitoring Æ Identical Sites • Logical structures – partition names, directories/files, privileges, accounts, etc. • Network configurations • Oracle • O/S • Hardware environments

  10. FORCE LOGGING • Identical sites • init.ora • Oracle Net • SRLs • Monitoring Æ Initialization Parameters…. • Use SPFILE • Initialization settings (except 4) • No environment variables • STANDBY_ARCHIVE_DEST=LOG_ARCHIVE_DEST1 • LOG_ARCHIVE_DEST_3 = … ALTERNATE … • LOG_ARCHIVE_DEST_1 = … ARCH … • Disable ARCHIVE_LAG_TARGET • Unset DB_CREATE_ONLINE_LOG_DEST_n • Tune CONTROL_FILE_RECORD_KEEP_TIME

  11. FORCE LOGGING • Identical sites • init.ora • Oracle Net • SRLs • Monitoring Æ Initialization Parameters • LOG_ARCHIVE_DEST_2 attributes • OPTIONAL • LGWR • ASYNC • NOAFFIRM • REOPEN • MAX_FAILURE • DELAY • NET_TIMEOUT

  12. FORCE LOGGING • Identical sites • init.ora • Oracle Net • SRLs • Monitoring Æ Oracle Network… • Static SID registration • Connect-time failover • Alternate standby location • Session Data Unit (SDU) setting

  13. FORCE LOGGING • Identical sites • init.ora • Oracle Net • SRLs • Monitoring Æ Oracle Network • Same network file structure • Listeners • Database clients – stop stby lsnr • Redo log & DBA traffic • tnsnames.ora files • Local node • database clients • DBAs

  14. FORCE LOGGING • Identical sites • init.ora • Oracle Net • SRLs • Monitoring Æ Standby Redo Logs • SRLs on all sites • Same # SRLs on all sites • Same SRL names on all sites • Redo logs & SRLs the same size • # SRL groups = 1 + (# redo log groups) • SRL groups < MAXLOGFILES • SRL members < MAXLOGMEMBERS

  15. FORCE LOGGING • Identical sites • init.ora • Oracle Net • SRLs • Monitoring Æ Monitoring • OEM Data Guard Diag Pack events • Alert log ORA- errors • Alert log non ORA- errors • V$ views - scripts (White Paper, Appendix 3)

  16. Implementation…. • FORCE LOGGING • Identical sites • O/S clocks • /etc/hosts • Environment variables & DBA scripts • Initialization parameters (SPFILE) • Oracle network configuration files • ARCHIVELOG mode & automatic archiving • Backup primary database • Create standby control file

  17. Implementation • Copy backup to standby site • Recover standby database • Mount standby database • Create SRLs • Start new listeners • Recover standby • Place standby in managed recovery mode • Enable LOG_ARCHIVE_DEST_STATE_2 on primary • Set protection mode on primary • Verify standby works • Enable Data Guard broker

  18. Next Steps…. • Michael New, Michael.New@ThinkSpark.com, 800-846-4082, ext. 104 • Recommended sessions • Oracle Data Guard: Maximum Data Protection at Minimum Cost • Data Guard SQL Apply: Back to the Future • Recommended demos and/or hands-on labs • Using Data Guard Manager to Manage a Standby Database

  19. Next Steps…. • See Your Business in Our Software • Visit the DEMOgrounds for a customized architectural review, see a customized demo with Solutions Factory, or receive a personalized proposal. Visit the DEMOgrounds for more information. • Relevant web sites to visit for more information • Oracle High Availability Guidelines & Recommendations: M. Burke, 2003, ThinkSpark – info@thinkspark.com • Data Guard Overview: http://otn.oracle.com/deploy/availability/htdocs/odg_overview.html

  20. Next Steps • Relevant web sites to visit for more information • Data Guard Technical White Paper on OTN: http://otn.oracle.com/deploy/availability/pdf/DG92_TWP.pdf • Data Guard Technology Overview Presentation on OTN: http://otn.oracle.com/deploy/availability/pdf/DataGuardTechnologyOverview.pdf • Data Guard Primary Site & Network Configuration Best Practices: http://otn.oracle.com/deploy/availability/pdf/MAA_DG_NetBestPrac.pdf

  21. Reminder – please complete the OracleWorld online session surveyThank you.

  22. Q & Q U E S T I O N S A N S W E R S A

  23. Session id: 36226 Implementing Oracle9i Data Guard Michael NewSenior Technical Consultant ThinkSpark

  24. Implement B&R – DG is HA (not B&R) Solution • B&R addresses database integrity & recovery • DG is HA solution to reduce MTTR, premised on reliable B&R solution • Without B&R, data loss possible with DG because of • Primary / secondary loss of network communication • Standby maintenance downtime • Hardware failure due to multiple devices • Hardware failure during role reversal • logical corruption (if propagated to the standby)

  25. ThinkSparkThinkSpark For more than 15 years, ThinkSpark has been a world-class technology partner to those businesses that have invested in Oracle technologies and solutions. ThinkSpark has delivered unmatched Oracle database expertise, Oracle systems integration skills, Oracle education services and Oracle license management insights to thousands of businesses across the country and around the globe. Headquartered in Dallas, ThinkSpark's more than 100 professionals serve clients across all industries through facilities in Austin, Dallas, Houston, Las Vegas, Oklahoma City and San Antonio. For more information about ThinkSpark, call (888) 262-6043 from the U.S., Canada and Mexico or visit ThinkSpark on the World Wide Web at http://www.thinkspark.com/.

More Related