• Categories
• Copia de seguridad
• Oracle Database
• SQL
• Bases de datos
• Ciencias de la Información

Citation preview

Oracle12c Database Administrator Upgrade

DESCRIPCIÓN El programa Oracle 12c Database Administrator permite al participantes actualizar sus conocimientos y habilidades técnicas basados en el material oficial de Oracle WDP y experiencia docente para tener los requisitos para la renovación de la certificación oficial OCA & OCP. Asimismo el programa permite consolidar una serie de habilidades tales como: Gestión del Sistema Operativo, Subsistemas de Almacenamiento, Redes y Seguridad como parte de la formación del programa.

OBJETIVO • Obtener grandes beneficios con las nuevas funcionales de sentencias SQL que ofrece la versión Oracle Database 12c. • Instalar y configurar la infraestructura de base de datos en Oracle Database 12c. • Administrar una instancia 12c y gestionar las estructuras de almacenamiento. • Implementar actualizaciones de base de datos versiones 10g/11g a 12c. • Administración de almacenamiento ASM (Automatic Storage Management). • Implementar procedimientos de respaldo y recuperación. • Crear, administrar, gestionar y auditar los usuarios y sus privilegios. • Supervisar el rendimiento del motor de base de datos Oracle Database 12c. • Utiliza flashbacks y duplicación de datos en procesos de respaldo y recuperación. • Asegurar la disponibilidad del servicio con estrategias de respaldo y recuperación. • Gestionar las bases de datos contenedoras de multi-usuarios. • Ejecutar procedimientos para copias de seguridad, recuperación y flashback para las bases de datos multiusuarios contenedoras y enchufables. • Administración de CDB y PDBs en configuraciones Data Guard y Database Vault. • Administración y gestión de recursos de base de datos con la finalidad de estabilizar el

INFORMES: Central: 633 5555 [email protected]

desempeño mediante Resource Manager. • Implementar tareas automáticas mediante Scheduler. • Gestión de manejo de incidencias y problemas mediante Workbench & Oracle Support.

DIRIGIDO • Profesionales TI. • Técnicos en TI. • Analistas y Programadores. • Administradores de Base de Datos.

PRE-REQUISITOS • Conocimiento Oracle Fundamentals (avanzado) • Conocimiento Oracle Workshop I y II (avanzado) • Conocimiento Ingles Técnico (Intermedio)

EGRESADO • Oracle 11g Database Administrator

SEDE MIRAFLORES Calle Diez Canseco Cdra. 2

SEDE INDEPENDENCIA Av. Carlos Izaguirre 233

COLEGIO SOPHIANUM Av. Salaverry 2100 - San Isidro

SEDE SAN MIGUEL Av. Federico Gallese 847

SEDE BREÑA Av. Brasil 714 – 792 (CC La Rambla piso 3)

UNIVERSIDAD CHAMPAGNAT Av. Mariscal Castilla 1270, Santiago de Surco

Oracle12c Database Administrator Upgrade

CERTIFICACIÓN

BENEFICIOS

Al finalizar y aprobar el programa, con nota mínima catorce (14), el participante obtendrá el certificado de Cibertec:

• 50% de descuento en exámenes de autoevaluación de conocimientos técnicos en Oracle Self Test Software Provider. • 25% de descuento en los exámenes de certificación Oracle. • Acceso al metalink (base de datos de conocimientos) técnico de Oracle. • 100% de descargas de productos acorde a la capacitación en Oracle Software Delivery Cloud.

CURSO

N°

CURSO 1

Oracle 12c Database Administrator Upgrade

PLAN CURRICULAR N°

CURSO

HORAS

1

Oracle Database 12c New Features for Administrators

45

2

Oracle Database 12c Backup and Recovery Workshop

45

TEMAS Enterprise Manager and Other Tools • Enterprise Manager (EM) Cloud Control home page. • Enterprise Manager Express home page versus Enterprise Manager Database Control. • SQL Developer with new functionalities. • OUI, DBCA Basics of Multitenant Container Database (CDB) • Benefits of the multitenant architecture. • Differences between the root container and pluggable database containers • Structure of the root. • Structure of Pluggable Database (PDB). • CDB_xxx and DBA_xxx views.

INFORMES: Central: 633 5555 [email protected]

• Impacts in Security, Data Guard, Oracle Golden Gate, Oracle Streams, XStream, and Scheduler. Configuring and Creating CDB and PDBs • Tools: DBCA and SQL*Plus. • Configuration and creation of CDB. • Exploring the Structure (CDB_xxx views and EM) • Tools used: SQL Developer, DBCA and SQL*Plus. • Create a new PDB from PDB$SEED. • Create a PDB from a non-CDB. • Clone a PDB into the same CDB or into another CDB using DB links. • Plug in an unplugged PDB.

SEDE MIRAFLORES Calle Diez Canseco Cdra. 2

SEDE INDEPENDENCIA Av. Carlos Izaguirre 233

COLEGIO SOPHIANUM Av. Salaverry 2100 - San Isidro

SEDE SAN MIGUEL Av. Federico Gallese 847

SEDE BREÑA Av. Brasil 714 – 792 (CC La Rambla piso 3)

UNIVERSIDAD CHAMPAGNAT Av. Mariscal Castilla 1270, Santiago de Surco

Oracle12c Database Administrator Upgrade

Configuring and Creating CDB and PDBs • Tools: DBCA and SQL*Plus. • Configuration and creation of CDB. • Exploring the Structure (CDB_xxx views and EM) • Tools used: SQL Developer, DBCA and SQL*Plus. • Create a new PDB from PDB$SEED. • Create a PDB from a non-CDB. • Clone a PDB into the same CDB or into another CDB using DB links. • Plug in an unplugged PDB. Managing CDB and PDBs • Connect to CDB as administrator. • Connect to a PDB using a service name. • Start up a CDB. • Open / Close a PDB. (SQL*Plus, srvctl, EM) • Open / Close all PDBs. • Shut down a CDB. • Triggers ON PLUGGABLE DATABASE. • Change PDB state. Managing Tablespaces, Common and Local Users, Privileges and Roles • Create permanent tablespaces in the root and PDBs. • Manage common and local schemas and users in the root and PDBs. • Manage system and object privilegesto common and local grantees granted"commonly" or "locally" • Manage common and local rolesgranted "commonly" or "locally". Managing Backup / Recovery / Flashback and Migration • Backup a whole CDB. • Backup a PDB. • Recover CDB from redo log files,control files, undo datafiles loss. • Recover PDB from PDB datafiles loss. • Flashback at CDB level. Online Datafile Move and Automatic Data Optimization • Data classification in 12c: tablespace,group, object, row levels. • Configure heat map. • Automatic movement andcompression. • Compression levels and types. • Policy declaration: simple declarativeSQL extension.

INFORMES: Central: 633 5555 [email protected]

• Customized automated actionexecution with user-defined function. • Execution in scheduled maintenancewindows and by MMON. • Customized schedule with DBMS_ILMpackage. In-Database Archiving • Challenges of old data in tables and11g solutions. • In-database archiving new solutions. • Use ROW ARCHIVAL clause toenable row lifecycle state forapplications. • Set ROW ARCHIVAL VISIBILITY forsession level visibility control. • Temporal Validity versus Temporal History. (Transaction Time of FDA) • New clause of CREATE / ALTERTABLE to set a Temporal Validity:PERIOD FOR. • New SQL temporal data type. Auditing Enhancements • Review of 11g R2 audit trailimplementation. • Overview of the Unified Audit Trail. • Enabling the Unified Audit Trail. • Creating a separate tablespace for theunified audit trail. • Granting the AUDIT_ADMIN role to a user for audit trail configuration and management. • Configuring the Unified Audit Trail to set a tolerance level for loss of audit records • Creating audit policies. Privileges Enhancements • Implementing Separation of Duty for Database Administration Tasks. • Using Database Privilege Analysis. • Overview of Database Privilege Analysis. • Granting the CAPTURE_ADMIN role to enable management of privilege captures. • Creating and starting/stopping privilege captures. • Viewing privilege profile data. • Querying DBA_PRIV_CAPTURES. • Using mandatory INHERIT PRIVILEGES privilege to execute invoker's rights procedure. Oracle Data Redaction • Overview of Oracle Data Redaction. • Types of Masking Policies. • Administering the EXEMPT REDACTION POLICY system privilege to enable a user to view unmasked values.

SEDE MIRAFLORES Calle Diez Canseco Cdra. 2

SEDE INDEPENDENCIA Av. Carlos Izaguirre 233

COLEGIO SOPHIANUM Av. Salaverry 2100 - San Isidro

SEDE SAN MIGUEL Av. Federico Gallese 847

SEDE BREÑA Av. Brasil 714 – 792 (CC La Rambla piso 3)

UNIVERSIDAD CHAMPAGNAT Av. Mariscal Castilla 1270, Santiago de Surco

Oracle12c Database Administrator Upgrade

• Managing Masking Policies. • Best practices for defining policy expressions. • Understanding Masking of Statements Containing Subqueries. • Viewing Information About Masking Policies by Querying REDACTION_POLICIES and REDACTION_COLUMNS. General RMAN New Features and FDA Enhancements • Making Database Connections With RMAN. • Using the SYSBACKUP Privilege. • Using SQL, DESCRIBE Command, Duplication Operation with the NOOPEN option. • Backing up and Restoring Very Large Files • Creating Multisection Backups. • Transporting Data Across Platforms. • Prerequisites and Limitations. • Transporting Data: Processing steps. Monitoring DB Operations Overview • Use cases. • Current Tools. • Define a DB operation. • Monitoring: Bracketing an Operation. • Monitoring the Progress of Operations. • DB Operation Tuning. • DB Operation Active Report.

Resource Manager and Other Performance Enhancements • Manage resources between PDBs. • Manage resources within a PDB. • Manage resources with CDB and PDBs plans. • Manage runaway querie.s • Automated maintenance tasks. • Describe the Multi-process Multi-threaded Oracle architecture. • Learn how to use this architecture in Oracle 12c Database. • Demonstrate the changes to shutdown procedures. Index and Table Enhancements • Multiple indexes on the same set of columns as long as some characteristic is different • Create table with INVISIBLE columns • Support for invisible columns • Advanced Row Compression • Describe online redefinition supports • ExplainLOCK timeout during FINISH_REDEF_TABLE • Using DDL statements in an online manner

Schema and Data Changes • Explain the Schema Change Plan flow. • Change requests. • Schema synchronization. • Explain the Data Comparison flow. • DBMS_COMPARISON package. • Guidelines and steps. • Comparison job and results. SQL Tuning • Adaptive Execution Plans. • SQL Plan Directives. • Statistics Gathering Performance Improvements. • Histogram Enhancements. • Enhancements to Extended Statistics. • Adaptive SQL Plan Management.

INFORMES: Central: 633 5555 [email protected]

Real-Time ADDM and Compare Period Advisor • Emergency Monitoring. • Real time ADDM. • Use cases. • Goals. • Define Workload dimensions. • Reported items. • Root Causes. • Requirements for a report.

ADR and Network Enhancements • ADR file types • New File types • New File locations • New commands for ADRCI • Improve performance by Compression • Setup Compression Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements • Use FULL Transportable export and import • Oracle Data Pump enhancements • SQL*Loader enhancements • SQL*Loader and External table common enhancements • SQL*Loader Express Mode usage

SEDE MIRAFLORES Calle Diez Canseco Cdra. 2

SEDE INDEPENDENCIA Av. Carlos Izaguirre 233

COLEGIO SOPHIANUM Av. Salaverry 2100 - San Isidro

SEDE SAN MIGUEL Av. Federico Gallese 847

SEDE BREÑA Av. Brasil 714 – 792 (CC La Rambla piso 3)

UNIVERSIDAD CHAMPAGNAT Av. Mariscal Castilla 1270, Santiago de Surco

Oracle12c Database Administrator Upgrade

Partitioning Enhancements • Move a partition online • ALTER TABLE ... SPLIT PARTITION, ALTER TABLE ... MERGE PARTITION, ALTER TABLE...ADD PARTITION Clauses: Overview • Split Partition Operation Enhancement • ALTER TABLE SPLIT SUBPARTITION • Merge Partition Operation • Add Partition Operation • Drop Partition Operation • ALTER TABLE DROP SUBPARTITION SQL Enhancements • Enumerate Increase in the length limits for VARCHAR2, NVARCHAR2, and RAW data types in Oracle SQL to 32767 (32k) byte • Enumerate miscellaneous enhancements • Using SQL Row limiting clause in a query Introduction • Curriculum Context • Assess your Recovery Requirements • Categories of failures • Oracle Backup and Recovery Solutions • Oracle Maximum Availability Architecture • Oracle Secure Backup • Benefits of using Oracle Data Guard • Basic Workshop Architecture Getting Started • Core Concepts of the Oracle Database, Critical for Backup and Recovery • Oracle DBA Tools for Backup and Recovery • Connecting to Oracle Recovery Manager (RMAN) • Quick Start: A Problem-Solution Approach Configuring for Recoverablility • RMAN commands • Configuring and managing persistent settings • Using the Fast Recovery Area (FRA) • Control File • Redo Log File • Archiving Logs Using the RMAN Recovery Catalog • Creating and Configuring the Recovery Catalog • Managing Target Database Records in the Recovery Catalog • Using RMAN Stored Scripts • Maintaining and Protecting the Recovery Catalog • Virtual Private Catalogs

INFORMES: Central: 633 5555 [email protected]

Backup Strategies and Terminology • Backup Solutions Overview and Terminology • Balancing Backup and Restore Requirements • Backing Up Read-Only Tablespaces • Best Practices for Data Warehouse Backups • Additional Backup Terminology Performing Backups • RMAN Backup Types • Incrementally Updated Backups • Fast Incremental Backup • Block Change Tracking • Oracle-Suggested Backup • Reporting on Backups • Managing Backups Improving Your Backups • Compressing Backups • Using a Media Manager • Creating RMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets • Creating and Managing Archival Backups • Backing Up Recovery Files • Backing Up the Control File to a Trace File • Cataloging Additional Backup Files • Backing Up ASM Disk Group Metadata Using RMAN-Encrypted Backups • Creating RMAN-Encrypted Backups • Using Transparent-Mode Encryption • Using Password-Mode Encryption • Using Dual-Mode Encryption Diagnosing Database Failures • Reducing Problem Diagnosis Time • Automatic Diagnostic Repository • Interpreting RMAN Message Output and Error Stacks • Data Recovery Advisor • Diagnosing Data File Loss (file system and ASM) • Handling Block Corruption Restore and Recovery Concepts • Restoring and Recovering • Instance Failure and Instance/Crash Recovery • Media Failure • Complete Recovery (Overview) • Point-in-Time Recovery (Overview) • Recovery Through RESETLOGS

SEDE MIRAFLORES Calle Diez Canseco Cdra. 2

SEDE INDEPENDENCIA Av. Carlos Izaguirre 233

COLEGIO SOPHIANUM Av. Salaverry 2100 - San Isidro

SEDE SAN MIGUEL Av. Federico Gallese 847

SEDE BREÑA Av. Brasil 714 – 792 (CC La Rambla piso 3)

UNIVERSIDAD CHAMPAGNAT Av. Mariscal Castilla 1270, Santiago de Surco

Oracle12c Database Administrator Upgrade

Using Flashback Technologies • Flashback Technology: Overview and Setup • Using Flashback Technology to Query Data • Flashback Table • Flashback Transaction (Query and Backout) • Flashback Drop and the Recycle Bin • Flashback Data Archive

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

Using Flashback Database • Flashback Database Architecture • Configuring Flashback Database • Performing Flashback Database • Best Practices for Flashback Database • Managing Backup Space or Transporting Data • Transporting Tablespaces • Transporting Databases

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

Duplicating a Database • Using a Duplicate Database • Choosing Database Duplication Techniques • Creating a Backup-up Based Duplicate Database • Understanding the RMAN Duplication Operation • Using Cloud Control to Clone a Database

RMAN and Oracle Secure Backup • Oracle Secure Backup Overview • Oracle Database Disk and Tape Backup Solution • Backing Up the Fast Recovery Area to Tape • Defining Retention for RMAN Backups • RMAN and Oracle Secure Backup Basic Process Flow • Integration with Cloud Control • RMAN Database Backup to Tape

RMAN Performance and Tuning • Tuning Principles • RMAN Multiplexing • Diagnosing Performance Bottlenecks • Restore and Recovery Performance Best Practices Backup and Recovery Workshop • Workshop Structure • Workshop Approach to Solving Failure Scenarios • Business Requirements for Database Availability and Procedures

Performing Tape Backups and Restores • Scheduling Backups with EM • Oracle-Suggested Backup • RMAN and OSB Process Flow • RMAN and Oracle Secure Backup Jobs • Managing Database Tape Backups • Performing Database Recovery • RMAN Automatic Failover to Previous Backup

FECHA DE INICIO:

PRÓXIMO INICIO:

SEDE: HORARIO: PRECIO:

INFORMES: Central: 633 5555 [email protected]

SEDE MIRAFLORES Calle Diez Canseco Cdra. 2

SEDE INDEPENDENCIA Av. Carlos Izaguirre 233

COLEGIO SOPHIANUM Av. Salaverry 2100 - San Isidro

SEDE SAN MIGUEL Av. Federico Gallese 847

SEDE BREÑA Av. Brasil 714 – 792 (CC La Rambla piso 3)

UNIVERSIDAD CHAMPAGNAT Av. Mariscal Castilla 1270, Santiago de Surco