Course Overview
This hands-on course will teach students how to exploit the capabilities of Data Guard (back-ported to earlier releases when necessary) with insight into how best to use the various features. The course provides in-depth coverage of Data Guard for all releases: the current release is used for exercises and demonstrations, and the content is back-ported as necessary for previous releases.
There is emphasis on Data Guard being more than a zero data loss solution. For example, it can give you performance (logical standby), development and testing systems (snapshot standby), and is a vital part of distributed Oracle database environments.
Target audiences
- This course is designed for database administrators, though IT Management will also find the content valuable for planning and infrastructure design purposes.
Curriculum
- 1 Section
- 12 Lessons
- 3 Days
Expand all sectionsCollapse all sections
- Topics12
- 1.1Data Guard capabilities Data availability: zero data loss Improving performance Platform migration Zero downtime upgrade Enabling technology for distributed systems
- 1.2Types of standby databases Physical standby Logical standby Snapshot standby Real-Time Query standby Far-sync standby Database roles in the configuration
- 1.3Physical standby management Creation Oracle Net configuration Standby logfile and archive logfile management Switchover and failover Configuring and monitoring redo transport and apply Data protection modes Role transitions
- 1.4Logical standby management Creating from a physical standby Managing non-maintained objects Tuning data structures Use as a data warehouse Monitoring and tuning the SQL apply processes
- 1.5Real-time query Licensing implications Query offload A read-mostly environment Use in distributed systems Tolerance for stale query DML and DDL in the standby
- 1.6Snapshot standby Conversion from and reverting to a physical standby Managing multiple streams of redo Use for test and development environments
- 1.7Flashback technologies The importance of Database Flashback in a Data Guard configuration Database Flashback and Point In Time recovery Using Flashback to re-instate a failed primary Flashback query, flashback drop, and transaction flashback
- 1.8Backup and recovery Database backup: primary and standbys Archivelog backup and removal at all sites Restore from backup Restore from another database Recovering restored datafiles Creation and use of an RMAN Recovery Catalog
- 1.9The Data Guard Broker Starting the Data Guard Broker Use the DGMGRL command line tool Create a Broker configuration Use the broker for role transitions Start the Observer process Enable fast-start failover Monitor automatic failover and database reinstatement
- 1.10Manage client connectivity and session failover Use non-deterministic connect strings Enable session failover with TAF Create services appropriate to different database roles Manage services with PL/SQL and with Grid Infrastructure
- 1.11Distributed systems Cascading standbys Real-time cascade Far-sync standbys and zero data loss Use an archive logfile repository
- 1.12Maintenance activities Tuning and monitoring a Data Guard configuration Standby-first patching Platform migration Minimal downtime upgrade: the physru script Integration with RAC: Maximum Availability Architecture
Instructor
