Loading...
Kiknek javasoljuk?  Data Guard standby adatbázis üzemeltetőknek
Mit nyújtunk ezzel?  Data Guard standby környezetek üzemeltetéséhez szükséges alapismereteket
Szükséges alapképzettség Adatbázis adminisztrátori ismeretek I.
Milyen képzettséget eredményez? Data Guard konfiguráció felépítése, üzemeltetése
Hossz 16 óra (2 nap)

Tematika

  • Introduction to Oracle Data Guard
    • 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 for Oracle Data Guard
    • 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
  • Creating a Physical Standby Database by Using SQL and RMAN Commands
    • 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
  • Performing Role Transitions
    • Role Management Services
    • Role Transitions: Switchover and Failover
    • Switchover
    • Preparing for a Switchover
    • Performing a Switchover by Using DGMGRL
    • Considerations When Performing a Switchover to a Logical Standby Database
    • Situations That Prevent a Switchover
  • Managing Client Connectivity
    • 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
  • • Backup and Recovery Considerations in an Oracle Data Guard Configuration
    • Using RMAN to Back Up and Restore Files in a Data Guard Configuration
    • Offloading Backups to a Physical Standby
    • Restrictions and Usage Notes
    • 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