Location
-
Format
What’s this? Ways to train
Classroom
Live, instructor-led training in a standard, professional classroom environmentVirtual
Live, instructor-led training conducted over the internet, with hands-on labsOnline
An online, HTML5, self-paced learning experience available for all coursesOn-site
Private training for your entire team, delivered at your location, a training center, or onlineVideo classroom
Learn more about our training formats
High-definition video of our most popular courses, streamed to your laptop or personal device
-
32 Hours
-
HRDF SBL Claimable
-
Certificate of Attendance available
-
90 days of access from date of activation
-
4 Days
-
All of our private classes are customized to your organization's needs.
-
Click on the button below to send us your details and you will be contacted shortly.
Already purchased this offering? Log in
Request more information
Inquiry for: Myself My Company
By providing your contact details, you agree to our Privacy Policy
Thank You
Our learning consultant will get back to you in 1 business day
Oracle Database 12c: Data Guard Administration
WHAT YOU WILL LEARN
This Oracle Database 12c: Data Guard
Administration Ed 1 training teaches you how to use Oracle Data Guard. Expert
Oracle University instructors will demonstrate how this solution protects your
Oracle database against planned and unplanned downtimes.
Learn To:
- Build highly available systems.
- Offload business processing needs to another system.
- Offload backup needs to another system.
Benefits to You
You'll walk away from this course with an
understanding of how Data Guard standby databases can be used to support
various production functions. These functions include reporting, querying and
testing, while in a standby role.
AUDIENCE
- Technical Consultant
- Database Administrators
- Support Engineer
PREREQUISITES
You'll walk away from this course with an
understanding of how Data Guard standby databases can be used to support
various production functions. These functions include reporting, querying and
testing, while in a standby role.
METHODOLOGY
This course will also teach you about the
new Oracle Data Guard 12c features and architecture. You'll get a chance to
explore topics like Oracle Active Data Guard, Far Sync, rolling upgrades and
snapshot standby databases. Furthermore, enrolling in this course will help you
learn how to manage and troubleshoot a Data Guard configuration.
COURSE OBJECTIVES
Upon completion of this program,
participants should be able to:
- Use Data Guard to achieve a highly available Oracle database
- Use Data Guard standby databases to support production functions such as reporting, querying, testing, and performing backups
- Create and manage physical and logical standby databases
- Use Enterprise Manager Cloud Control and the Data Guard command-line interface (DGMGRL) to maintain a Data Guard configuration
Modules
- What Is Oracle Data Guard?
- Types of Standby Databases
- Types of Data Guard Services
- Role Transitions: Switchover and Failover
- Oracle Data Guard Broker Framework
- Choosing an Interface for Administering a Data Guard Configuration
- Oracle Data Guard: Architecture(Overview)
- Primary Database Processes
- Networking Overview
- Listener.ora Configuration
- Statics vs. Dynamic Registration
- Static Entries for Database Duplication and SQL Maintenence
- Static Entries for Broker Operations
- Oracle Network Configuration Tuning
- Tnsnames.ora Configuration
- Steps to Create a Physical Standby Database
- Preparing the Primary Database
- FORCE LOGGING Mode
- Configuring Standby Redo Logs
- Creating Standby Redo Logs
- Using SQL to Create Standby Redo Logs
- Viewing Standby Redo Log Information
- Setting Initialization Parameters on the Primary Database to Control Redo Transport
- Oracle Data Guard Broker: Features
- Data Guard Broker: Components
- Data Guard Broker: Configurations
- Data Guard Broker: Management Model
- Data Guard Broker: Architecture
- Data Guard Monitor: DMON Process
- Benefits of Using the Data Guard Broker
- Comparing Configuration Management With and Without the Data Guard Broker
- Data Guard Broker: Requirements
- Data Guard Broker and the SPFILE
- Data Guard Monitor: Configuration File
- Data Guard Broker: Log Files
- Creating a Broker Configuration
- Defining the Broker Configuration and the Primary Database Profile
- Adding a Standby Database to the Configuration
- Enabling the Configuration
- Using Oracle Enterprise Manager to Create a Broker Configuration
- Creating a Configuration
- Creating a New Configuration
- Adding a Standby Database to an Existing Configuration
- Using the Add Standby Database Wizard
- Standby Database Creation: Processing
- Standby Database Creation: Progress
- Verifying a Data Guard Configuration
- Benefits of Implementing a Logical Standby Database
- Logical Standby Database: SQL Apply Architecture
- SQL Apply Process: Architecture
- Preparing to Create a Logical Standby Database
- Unsupported Objects
- Unsupported Data Types
- Checking for Unsupported Tables
- Checking for Tables with Unsupported Data Types
- Snapshot Standby Databases: Overview
- Snapshot Standby Database: Architecture
- Converting a Physical Standby Database to a Snapshot Standby Database
- Activating a Snapshot Standby Database: Issues and Cautions
- Snapshot Standby Database: Target Restrictions
- Viewing Snapshot Standby Database Information
- Using DGMGRL to View Snapshot Standby Database Information
- Converting a Snapshot Standby Database to a Physical Standby Database
- Oracle Active Data Guard
- Using Real-Time Query
- Checking the Standby’s Open Mode
- Understanding Lag in an Active Data Guard Configuration
- Monitoring Apply Lag: V$DATAGUARD_STATS
- Monitoring Apply Lag: V$STANDBY_EVENT_HISTOGRAM
- Setting a Predetermined Service Level for Currency of Standby Queries
- Configuring Zero Lag Between the Primary and Standby Databases
- Data Protection Modes and Redo Transport Modes
- Maximum Protection Mode
- Maximum Availability Mode
- Maximum Performance Mode
- Comparing Data Protection Modes
- Setting the Data Protection Mode by Using DGMGRL
- Setting the Data Protection Mode
- Role Management Services
- Role Transitions: Switchover and Failover
- Switchover
- Preparing for a Switchover
- Performing a Switchover by Using DGMGRL
- Performing a Switchover by Using Enterprise Manager
- Considerations When Performing a Switchover to a Logical Standby Database
- Situations That Prevent a Switchover
- Using Flashback Database in a Data Guard Configuration
- Overview of Flashback Database
- Configuring Flashback Database
- Configuring Flashback Database by Using Enterprise Manager
- Using Flashback Database Instead of Apply Delay
- Using Flashback Database and Real-Time Apply
- Using Flashback Database After RESETLOGS
- Flashback Through Standby Database Role Transitions
- Fast-Start Failover: Overview
- When Does Fast-Start Failover Occur?
- Installing the Observer Software
- Fast-Start Failover Prerequisites
- Configuring Fast-Start Failover
- Setting the Lag-Time Limit
- Configuring the Primary Database to Shut Down Automatically
- Automatic Reinstatement After Fast-Start Failover
- Understanding Client Connectivity in a Data Guard Configuration
- Understanding Client Connectivity: Using Local Naming
- Preventing Clients from Connecting to the Wrong Database
- Managing Services
- Understanding Client Connectivity: Using a Database Service
- Creating Services for the Data Guard Configuration Databases
- Configuring Role-Based Services
- Adding Standby Databases to Oracle Restart Configuration
- Using RMAN to Back Up and Restore Files in a Data Guard Configuration
- Offloading Backups to a Physical Standby
- Restrictions and Usage Notes
- Backup and Recovery of a Logical Standby Database
- Using the RMAN Recovery Catalog in a Data Guard Configuration
- Creating the Recovery Catalog
- Registering a Database in the Recovery Catalog
- Setting Persistent Configuration Settings
Course Reviews
0
0 Ratings