Pular para o conteúdo

[email protected]
Contato

Curitiba 41 3204.1999 | Brasil 4007.2186
Tel

Whatsapp 41 98754.3534
Whatsapp
SoftSell
MENUMENU
  • HOME
  • TREINAMENTOS E CERTIFICAÇÕES
    • CALENDÁRIO DE TREINAMENTOS
    • Certificações em TI
    • Check Point
      • CCSA – Check Point Certified Security Administrator
      • CCSE – Check Point Security Engineering
      • Check Point CCSA+CCSE – Bundle R.80
    • Cisco
      • Cisco Digital Network Architecture Implementation Essentials (DNAIE) v2.0
      • Cisco SD-WAN Operation and Deployment (ENSDW) v1.0
      • Designing Cisco Enterprise Networks (ENSLD) v1.0
      • Implementing and Administering Cisco Solutions (CCNA) v1.0
      • Implementing and Configuring Cisco Identity Services Engine (SISE) v3.0
      • Implementing and Operating Cisco Enterprise Network Core Technologies (ENCOR) v1.0
      • Implementing and Operating Cisco Security Core Technologies (SCOR) v1.0
      • Implementing Cisco Application Centric Infrastructure (DCACI) v1.0
      • Implementing Cisco Catalyst 9000 Switches (ENC9K) v1.0
      • Implementing Cisco Enterprise Advanced Routing and Services (ENARSI) v1.0
      • Understanding Cisco Wireless Foundations (WLFNDU) v1.0
    • CompTIA
      • Linux+ CompTIA
      • Security+ CompTIA
      • Webinar – Cibersegurança e o Mercado de Trabalho
    • EC-Council
      • CASE JAVA Training & Certification
      • CEH v11
      • CHFI
      • CND v2
      • CSA - Certified SOC Analyst
      • CSCU Certified Secure Computer User
      • ECIH
      • Webinar CEH – Certified Ethical Hacker v10
    • Extreme Networking
      • Campus EXOS Switching and Routing
    • F5
      • Configuring F5 Advanced WAF (previously licensed as ASM)
      • F5 ADM BIG IP – Administering BIG-IP
      • F5 BIG-IP DNS (Antigo GTM)
      • F5 Configuring BIG-IP (AFM): Advanced Firewall Manager
      • F5 Configuring BIG-IP (APM): Access Policy Manager
      • F5 LTM – Configuring BIG-IP Local Traffic Manager
      • F5 Troubleshooting BIG-IP
    • Fortinet
      • FortiGate (I) Security v6
      • FortiGate (II) Infrastructure v6
      • NSE 5 – FortiAnalyzer
      • NSE 5 – FortiManager
      • NSE 7 - Enterprise Firewall
    • Furukawa
      • Data Cabling System & MCT Fluke Networks
      • FCP Fibras Ópticas
      • FCP Fibras Ópticas | Módulo Emendas Ópticas
      • FCP Fibras Ópticas | Módulo Medição em Redes Ópticas
      • FCP Fibras Ópticas | Módulo Redes Externas
      • FCP Master
      • FCP Update
      • FCP Professional
      • FTTx Conceitos e Projetos
      • FTTx Equipamentos | Módulo 1 Networking
      • Webinar
    • Infoblox
      • CDAT – Core DDI Advanced Troubleshooting 8.x
    • Java
      • Java Performance Tuning
      • Java SE 8 Fundamentals
      • Java SE 8 New Features
      • Java SE 8 Programming
      • OO Analysis & Design Using UML
    • Microsoft
      • 10990CC Analyzing Data With SQL Server Reporting Services
      • 20483 Programação em C#
      • 207031BC Administering System Center Configuration Manager
      • 20740CC Installation, Storage and Compute with Windows Server 2016
      • 20741BC Networking with Windows Server 2016
      • 20742BC Identity with Windows Server 2016
      • 20761 Querying Data with Transact-SQL
      • 20762C Developing SQL Databases
      • 20764 Administering a SQL Database Infrastructure
    • MySQL
      • MySQL Cluster
      • MySQL for Developers
      • MySQL for Administrators
      • MySQL for Beginners
      • MySQL Fundamentals
      • MySQL Performance Tuning
    • Oracle
      • Database 12c ASM Administration
      • Database 12c Clusterware Administration
      • Database 12c Data Guard Administration
      • Database 12c Novos Recursos Para Administradores
      • Database 12c Performance Management and Tuning
      • Database 12c RAC Administration
      • Database 12c R2 Administration Workshop
      • Database 12c R2 Backup & Recovery
      • Database 12c R2 Install and Upgrade Workshop
      • Database 12c R2 New Features for Adm 2
      • Database 18c Managing Multitenant Architecture
      • Database Coud for Oracle DBAs
      • Database Program with PL/SQL Ed 2
      • Database SQL and PL/SQL New Features Ed 1
      • Database SQL & PL/SQL Fundamentals
      • Database SQL Workshop II
      • Data Integrator 12c Integration and Administration Ed 3 NEW
      • Exadata Database Machine 12c Administration Workshop
      • Introduction to SQL
      • SQL Tuning for Developers
      • WebLogic Server 12c Adm 1
      • WebLogic Server 12c Adm 2
      • WebLogic Server 12c JMS Adm
      • WebLogic Server 12c Performance Tuning
      • WebLogic Server 12c Troubleshooting
    • Palo Alto Networks
      • PAN 210 – Firewall 9.1 Essentials: Configuration and Management
      • PAN 214 – Firewall 8.1: Optimizing Firewall Threat Prevention
      • PAN 220 – Palo Alto Panorama: Managing Firewalls at Scale v9
      • PAN 318 – Prisma Access Sase Security: Design and Operation
      • PAN 330 – Firewall: Troubleshooting v9
    • Salesforce
      • Salesforce ADX 201
      • Salesforce ADX 251
      • Salesforce ADX 261
      • Salesforce DEX 450
      • Salesforce EEB101 + JB101
    • SoftSell
      • Gerenciamento Win Server 2012
      • Gestão de Projetos
      • Gestão de Projetos na era da Indústria 4.0
      • Linux Essentials
      • Pentest for Red Teams - Buffer Overflow Windows e Linux
      • Pentest for Red Teams – Web Application
      • Redes e Novas Tecnologias
    • SonicWall
      • SonicWall Network Security Administrator (SNSA)
      • SonicWall Network Security Professional (SNSP)
    • Veeam
      • Veeam Certified Engineer V9
    • VMWare
      • VMware vSphere: Install, Configure, Manage v6.7 – VMware
  • SOLUÇÕES DE TI
    • Fábrica de Softwares e BI
    • Produtos e Equipamentos de TI
    • Serviços de TI
      • Computação em Nuvem
      • Gerenciamento de TI
      • IBM Cloud
      • Suporte Infraestrutura
  • INSTITUCIONAL
    • Sobre a SoftSell
  • BLOG
Oracle Database 12c: Data Guard Administration
Publicada em 30 de julho de 2018 na categoria
Slider
logo_oracle

Database 12c Data Guard Administration

Sobre este Treinamento

This Oracle Database 12c: Data Guard Administration Ed 1 training teaches you how to use Oracle Data Guard. Learn how it protects your Oracle database against planned and unplanned downtimes. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

Learn To:

  • Build highly available systems.
  • Offload business processing needs to another system.
  • Offload backup needs to another system.
  • Gain an understanding of Oracle Database Exadata Cloud Service.

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.

Oracle Data Guard 12c

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.

Carga Horária: 4 dias

GARANTIR MINHA VAGA!

Pré-requisito

Suggested Prerequisite:
Basic understanding of PL/SQL and Triggers

Required Prerequisite:
Oracle Database 11g: Administration Workshop I Ed 2
Oracle Database 11g: Administration Workshop II Ed 2
Database Administration
Linux operating system fundamentals

Administrator
Database Administrator
Implementer

Público-alvo

Conteúdo

Tópicos Principais:

  • 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
  • Use Data Guard to achieve a highly available Oracle database
  • Gain an understanding of Oracle Database Exadata Cloud Service

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

Oracle Data Guard Broker: Overview

  • 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

Creating a Data Guard Broker Configuration

  • 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

Creating a Physical Standby Database by Using Enterprise Manager Cloud Control

  • 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

Creating and Managing a Snapshot Standby Database

  • 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

Using Oracle Active Data Guard

  • 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

Configuring Data Protection Modes

  • 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

Performing Role Transitions

  • 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

  • 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

Enabling Fast-Start Failover

  • 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

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
  • 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

Patching and Upgrading Databases in a Data Guard Configuration

  • Upgrading an Oracle Data Guard Broker Configuration
  • Upgrading Oracle Database in a Data Guard Configuration with a Physical Standby Database
  • Upgrading Oracle Database in a Data Guard Configuration with a Logical Standby Database
  • Using DBMS_ROLLING to Upgrade the Oracle Database
  • Requirements for Using DBMS_ROLLING to Perform a Rolling Upgrade
  • Leading Group Databases and Leading Group Master
  • Trailing Group Databases and Trailing Group Master
  • Performing a Rolling Upgrade by Using DBMS_ROLLING

Monitoring a Data Guard Broker Configuration

  • Monitoring the Data Guard Configuration by Using Enterprise Manager Cloud Control
  • Viewing the Data Guard Configuration Status
  • Monitoring Data Guard Performance
  • Viewing Log File Details
  • Enterprise Manager Metrics and Alerts
  • Data Guard Metrics
  • Managing Data Guard Metrics
  • Viewing Metric Value History

Optimizing a Data Guard Configuration

  • Monitoring Configuration Performance by Using Enterprise Manager Cloud Control
  • Optimizing Redo Transport Services
  • Setting the ReopenSecs Database Property
  • Setting the NetTimeout Database Property
  • Optimizing Redo Transmission by Setting MaxConnections
  • Setting the MaxConnections Database Property
  • Compressing Redo Data by Setting the RedoCompression Property
  • Delaying the Application of Redo

Oracle Database Exadata Cloud Service Overview

  • Introducing Exadata Cloud Service
  • Service Configuration, Connection, Architecture & Availability
  • Data Security & Management Responsibilities
  • Storage Configuration & Management Details
  • Simple Web-Based Provisioning & Management
  • REST APIs
  • Backup and Recovery
  • Migrating to Exadata Cloud Service
Acesse o Calendário de Treinamentos

Atendimento Personalizado

Para saber mais sobre os treinamentos, certificações e soluções de TI da SoftSell, entre em contato com a gente.
É só escolher o seu canal preferido e aguardar breve resposta em horário comercial:

Curitiba: 41 3204.1999
Demais localidades: 4007.2186
WhatsApp : 41 98754.3534
Email: [email protected]
 

ENDEREÇO
Rua Emiliano Perneta, 680 – 9º Andar
Centro – Curitiba – Paraná – 80420-080

    Relacionado

    TREINAMENTOS E CERTIFICAÇÕES

    • Treinamentos e Certificações
    • Certificações em TI
    • Inscrições

    INFRAESTRUTURA DE TI

    • Software e BI
    • Serviços
    • Produtos e Equipamentos

    SOFTSELL

    • Sobre a SoftSell
    • Trabalhe Conosco

    ATENDIMENTO

    Telefone SoftSell Curitiba 41 3204.1999

    Telefone SoftSell Demais localidades 4007.2186

    Whatssap SoftSell WhatsApp 41 98754.3534

    Contato SoftSell [email protected]

     


    Rua Emiliano Perneta, 680 – 9º Andar – Centro – Curitiba – Paraná – 80420-080

    Siga-nos

    • Ver perfil de softsell no Facebook
    • Ver perfil de softsell.treinamentos no Instagram
    • LinkedIn

    SoftSell – Todos os Direitos Reservados | Desenvolvido por Pontodesign

    Pontodesign
    © 2021 SoftSell • Distribuído por GeneratePress
    Voltar ao topo