Curso Administración de la Base de Datos ORACLE v.12c

Cas Training Impartición

Curso en Madrid

Duración

3 Meses

A quién va dirigido

• Personas con conocimientos en Informática. • Formación Profesional. • Titulados Universitarios. • Profesionales que deseen actualizar sus conocimientos.

Sedes

Madrid
Noviembre 2018

Temario completo de este curso

1. Introduction
  • 1.1.Curriculum Context
  • 1.2.Assess your Recovery Requirements
  • 1.3.Categories of failures
  • 1.4.Oracle Backup and Recovery Solutions
  • 1.5.Oracle Maximum Availability Architecture
  • 1.6.Oracle Secure Backup
  • 1.7.Benefits of using Oracle Data Guard
  • 1.8.Basic Workshop Architecture

2. Getting Started
  • 2.1.Core Concepts of the Oracle Database, Critical for Backup and Recovery
  • 2.2.Oracle DBA Tools for Backup and Recovery
  • 2.3.Connecting to Oracle Recovery Manager (RMAN)
  • 2.4.Quick Start: A Problem-Solution Approach


3. Configuring for Recoverablility
  • 3.1.RMAN commands
  • 3.2.Configuring and managing persistent settings
  • 3.3.Using the Fast Recovery Area (FRA)
  • 3.4.Control File
  • 3.5.Redo Log File
  • 3.6.Archiving Logs

4. Using the RMAN Recovery Catalog
  • 4.1.Creating and Configuring the Recovery Catalog
  • 4.2.Managing Target Database Records in the Recovery Catalog
  • 4.3.Using RMAN Stored Scripts
  • 4.4.Maintaining and Protecting the Recovery Catalog
  • 4.5.Virtual Private Catalogs

5. Backup Strategies and Terminology
  • 5.1.Backup Solutions Overview and Terminology
  • 5.2.Balancing Backup and Restore Requirements
  • 5.3.Backing Up Read-Only Tablespaces
  • 5.4.Best Practices for Data Warehouse Backups
  • 5.5.Additional Backup Terminology

6. Performing Backups
  • 6.1.RMAN Backup Types
  • 6.2.Incrementally Updated Backups
  • 6.3.Fast Incremental Backup
  • 6.4.Block Change Tracking
  • 6.5.Oracle-Suggested Backup
  • 6.6.Reporting on Backups
  • 6.7.Managing Backups

7. Improving Your Backups
  • 7.1.Compressing Backups
  • 7.2.Using a Media Manager
  • 7.3.Creating RMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets
  • 7.4.Creating and Managing Archival Backups
  • 7.5.Backing Up Recovery Files
  • 7.6.Backing Up the Control File to a Trace File
  • 7.7.Cataloging Additional Backup Files
  • 7.8.Backing Up ASM Disk Group Metadata

8. Using RMAN-Encrypted Backups
  • 8.1.Creating RMAN-Encrypted Backups
  • 8.2.Using Transparent-Mode Encryption
  • 8.3.Using Password-Mode Encryption
  • 8.4.Using Dual-Mode Encryption

9. Diagnosing Database Failures
  • 9.1.Reducing Problem Diagnosis Time
  • 9.2.Automatic Diagnostic Repository
  • 9.3.Interpreting RMAN Message Output and Error Stacks
  • 9.4.Data Recovery Advisor
  • 9.5.Diagnosing Data File Loss (file system and ASM)
  • 9.6.Handling Block Corruption

10. Restore and Recovery Concepts
  • 10.1.Restoring and Recovering
  • 10.2.Instance Failure and Instance/Crash Recovery
  • 10.3.Media Failure
  • 10.4.Complete Recovery (Overview)
  • 10.5.Point-in-Time Recovery (Overview)
  • 10.6.Recovery Through RESETLOGS

11. Performing Recovery, Part 1
  • 11.1.RMAN Recovery in NOARCHIVELOG Mode
  • 11.2.Performing Complete Recovery (of critical and noncritical data files)
  • 11.3.Restoring ASM Disk Groups
  • 11.4.Recovery with Image Files
  • 11.5.Performing Point-in-Time (PITR) or Incomplete Recovery
  • 11.6.Table Recovery from Backups

12. Performing Recovery, Part 2
  • 12.1.Recovery of Server Parameter File, Control File
  • 12.2.Redo Log File Loss and Recovery
  • 12.3.Password Authentication File Re-creation
  • 12.4.Index, Read-Only Tablespace, and Tempfile Recovery
  • 12.5.Restoring the Database to a New Host
  • 12.6.Disaster Recovery
  • 12.7.Restoring RMAN Encrypted Backups

13. RMAN and Oracle Secure Backup
  • 13.1.Oracle Secure Backup Overview
  • 13.2.Oracle Database Disk and Tape Backup Solution
  • 13.3.Backing Up the Fast Recovery Area to Tape
  • 13.4.Defining Retention for RMAN Backups
  • 13.5.RMAN and Oracle Secure Backup Basic Process Flow
  • 13.6.Integration with Cloud Control
  • 13.7.RMAN Database Backup to Tape

14. Performing Tape Backups and Restores
  • 14.1.Scheduling Backups with EM
  • 14.2.Oracle-Suggested Backup
  • 14.3.RMAN and OSB Process Flow
  • 14.4.RMAN and Oracle Secure Backup Jobs
  • 14.5.Managing Database Tape Backups
  • 14.6.Performing Database Recovery
  • 14.7.RMAN Automatic Failover to Previous Backup

15. Using Flashback Technologies
  • 15.1.Flashback Technology: Overview and Setup
  • 15.2.Using Flashback Technology to Query Data
  • 15.3.Flashback Table
  • 15.4.Flashback Transaction (Query and Backout)
  • 15.5.Flashback Drop and the Recycle Bin
  • 15.6.Flashback Data Archive

16. Using Flashback Database
  • 16.1.Flashback Database Architecture
  • 16.2.Configuring Flashback Database
  • 16.3.Performing Flashback Database
  • 16.4.Best Practices for Flashback Database

17. Managing Backup Space or Transporting Data
  • 17.1.Transporting Tablespaces
  • 17.2.Transporting Databases

18. Duplicating a Database
  • 18.1.Using a Duplicate Database
  • 18.2.Choosing Database Duplication Techniques
  • 18.3.Creating a Backup-up Based Duplicate Database
  • 18.4.Understanding the RMAN Duplication Operation
  • 18.5.Using Cloud Control to Clone a Database

19. RMAN Performance and Tuning
  • 19.1.Tuning Principles
  • 19.2.RMAN Multiplexing
  • 19.3.Diagnosing Performance Bottlenecks
  • 19.4.Restore and Recovery Performance Best Practices

20. Backup and Recovery Workshop
  • 20.1.Workshop Structure
  • 20.2.Workshop Approach to Solving Failure Scenarios
  • 20.3.Business Requirements for Database Availability and Procedures 
Ver más

Más cursos relacionados de Bases de datos

SELECT BUSINESS SCHOOL

Máster Analítica Web y Big Data

SELECT BUSINESS SCHOOL - Máster online
1. INSTALACIÓN DE SISTEMAS OPERATIVOS Y GESTORES DE DATOS EN SISTEMAS ERP-CRM UNIDAD DIDÁCTICA 1. SISTEMAS OPERATIVOS EN SISTEMAS ERP-CRM. 1. Tipos
Precio Lectiva

3.880 € 1.940 
Core Networks, S.L.

Curso Superior de Bases de Datos oficial de Oracle

Core Networks, S.L. - Curso en Madrid
Oracle Database 12c R2: Administration Workshop Ed 3 (50 h) Explorando la arquitectura de la base de datos Oracle Administrar instancias de base de datos

2.550 
Grupo Cei

Curso DPD: Delegado/a de Protección de Datos (Esquema AEPD)

Grupo Cei - Curso semipresencial
Dominio 1 - NORMATIVA GENERAL DE PROTECCIÓN DE DATOS. Cumplimiento normativo del reglamento europeo, normativa nacional, directiva europea sobre

1.200 
+ IVA
Grupo Atrium

MASTER CERTIFICADO EXPERTO® EN BB.DD ORACLE 12C TELEPRESENCIAL

Grupo Atrium - Máster online
TEMARIO : 1. Introducción a Oracle: SQL 2.- Desarrollo con PL/SQL 3.- Administración Básica – DBA I 4.- Estrategias de Backup y Recuperación- DBA II

895 
TOKIO New Technology School

Administrador de Bases de Datos Oracle. OCP

TOKIO New Technology School - Curso en Madrid y 51 sedes más
Modeler • Oracle Application Express Módulo 2 Oracle 12c – Administración e instalación básica • Introducción • Arquitectura de Bases de Datos

Precio a consultar
Ver más