Máster Administración de la Base de Datos Oracle v.12c - Oracle Certified Professional

Descripción

• INTRODUCTION
  • Course Objectives.
  • Course Schedule.
  • Overview of Oracle Database 12c.
  • Overview of Oracle Cloud.
  • Overview of the HR Schema.
• EXPLORING THE ORACLE DATABASE ARCHITECTUR.
  • Oracle Database 12c Introduction.
  • Oracle Database Architecture: Overview.
  • Oracle Database Instance Configurations.
  • Connecting to the Oracle Database Instance.
  • Oracle Database memory Structures (overview).
  • Process Architecture (description).
  • Process Structures.
  • Process Startup Sequen.
• ORACLE SOFTWARE INSTALLATION BASICS
  • Planning Your Installation.
  • Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM.
  • Operating System Groups and Users.
  • Environment Variables.
  • Configuring the Oracle Software Owner Environment.
  • Using Oracle Universal Installer (OUI).
  • Installation Option: Silent Mode.
• INSTALLING ORACLE DATABASE SOFTWARE
  • System Requirements for Oracle Database.
  • Operating.
  • Types of Installations.
• CREATING AN ORACLE DATABASE BY USING DBCA
  • Planning the Database Storage Structure.
  • Types of Databases (based on workload).
  • Choosing the Appropriate Character Set.
  • Understanding How Character Sets are Used.
  • Setting the NLS_LANG Initialization Parameter.
  • Using the Database Configuration Assistant (DBCA).
• ORACLE DATABASE MANAGEMENT TOOLS
  • Introducing Oracle Database Management Tools.
  • Using SQL*Plus.
  • Using SQL Developer.
  • Logging in to Oracle Enterprise Manager Database Express.
  • Using the Enterprise Manager Database Express Home Pag.
  • Understanding the Enterprise Manager Cloud Control Framework.
  • Using Enterprise Manager Cloud Control.
• MANAGING THE DATABASE INSTANCE
  • Initialization Parameter Files.
  • Starting an Oracle Database Instance.
  • Shutting Down an Oracle Database Instance.
  • Viewing Log Files.
  • Using Trace Files.
  • Using the Dynamic Performance Views.
  • Data Dictionary.
• CONFIGURING THE ORACLE NETWORK ENVIRONMENT
  • Oracle Net Services Overview.
  • Oracle Net Listener Overview.
  • Establishing Oracle Network Connections.
  • Connecting to a Server.
  • Tools for Configuring and Managing the Oracle Network.
  • Using the Listener Control Utility.
  • Using Oracle Net Configuration Assistant.
  • Using Oracle Net Manager.
• ADMINISTERING USER SECURITY
  • Database User Accounts (overview).
  • Predefined Administrative Accounts.
  • Creating a User.
  • Authentication.
  • Unlocking a User Account and Resetting the Password.
  • Privileges.
  • Roles.
  • Profiles.
• MANAGING DATABASE STORAGE STRUCTURES
  • Understanding Storage of Data.
  • Database Block contents.
  • Exploring the Storage Structure.
  • Creating a New Tablespace.
  • Overview of Tablespaces Created by Default.
  • Managing Tablespaces.
  • Viewing Tablespace Information.
  • Using Oracle Managed Files.
• MANAGING SPACE
  • Space Management Overview.
  • Block Space Management.
  • Row Chaining and Migration.
  • Free Space Management Within Segments.
  • Types of Segments.
  • Allocating Extents.
  • Allocating Space.
  • eating Tables Without Segments.
• MANAGING UNDO DATA
  • Undo Data Overview.
  • Transactions and Undo Data.
  • Storing Undo Information.
  • Comparing Undo Data and Redo Data.
  • Managing Undo.
  • Configuring Undo Retention.
  • Guaranteeing Undo Retention.
  • Changing an Undo tablespace to a Fixed Size.
• MANAGING DATA CONCURRENCY
  • Overview of Locks.
  • Locking Mechanism.
  • Data Concurrency.
  • DML Locks.
  • Enqueue Mechanism.
  • Lock Conflicts.
• IMPLEMENTING ORACLE DATABASE AUDITING
  • Separation of Responsibilities.
  • Database Security.
  • Monitoring for Compliance.
  • Standard Database Auditing.
  • Unified Audit Data Trail.
  • Separation for Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles).
  • Configuring the Audit Trail.
  • Specifying Audit Options.
• BACKUP AND RECOVERY CONCEPTS
  • Categories of Failures.
  • Flashback Technology.
  • Understanding Instance Recovery.
  • Phases of Instance Recovery.
  • Tuning Instance Recovery.
  • Using the MTTR Advisor.
  • Comparing Complete and Incomplete Recovery.
  • Oracle Data Protection Solutions.
• BACKUP AND RECOVERY CONFIGURATION
  • Configuring for Recoverability.
  • Configuring the Fast Recovery Area.
  • Multiplexing the Control File.
  • Online Redo Log File.
  • Multiplexing the Online Redo Log File.
  • Archived Redo Log Files.
  • Archiver Process.
  • Archived Redo Log File Naming and Destinations.
• PERFORMING DATABASE BACKUPS
  • Backup Solutions Overview.
  • Oracle Secure Backup (overview).
  • User Managed Backup (overview).
  • Backup Terminology and Types of Backups.
  • Using Recovery Manager (RMAN).
  • Configuring Backup Settings.
  • Oracle-Suggested Backup.
  • Backing Up the Control File to a Trace File.
• PERFORMING DATABASE RECOVERY
  • Data Recovery Advisor.
  • Loss of a Control File.
  • Loss of a Redo Log File.
  • Loss of a Datafile in NOARCHIVELOG Mode.
  • Loss of a Noncritical Datafile in ARCHIVELOG Mode.
  • Loss of a System-Critical Datafile in ARCHIVELOG Mode.
• MOVING DATA
  • Moving Data: General Architecture.
  • Oracle Data Pump.
  • SQL*Loader.
  • External Tables.
• PERFORMING DATABASE MAINTENANCE
  • Database Maintenance (overview).
  • Viewing the Alert History.
  • Terminology.
  • Automatic Workload Repository (AWR).
  • Statistic Levels.
  • Automatic Database Diagnostic Monitor (ADDM).
  • Advisory Framework.
  • Enterprise Manager and Advisors.
• MANAGING PERFORMANCE
  • Performance Monitoring.
  • Tuning Activities.
  • Performance Planning.
  • Instance Tuning.
  • Performance Tuning Methodology.
  • Performance Tuning Data.
  • Monitoring Performance.
  • Managing Memory.
• MANAGING PERFORMANCE: SQL TUNING
  • SQL Tuning.
  • Oracle Optimizer.
  • SQL Plan Directives.
  • Adaptive Execution Plans.
  • SQL Advisors.
  • Automatic SQL Tuning results.
  • Implement Automatic Tuning Recommendations.
  • SQL Tuning Advisor.

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

• INTRODUCTION
  • Course Objectives.
  • Course Schedule.
  • Tools.
• CONTAINER AND PLUGGABLE DATABASE ARCHITECTURE
  • Challenges and Benefits.
  • Multitenant Architecture.
  • Provisioning PDBs.
  • Terminology.
• CDB AND PDB CREATION
  • Using Tools.
  • Configuring and Creating a CDB.
  • Creating PDBs.
  • Dropping PDBs.
  • Migrating PDBs.
• MANAGING A CDB AND PDBS
  • Connection.
  • Managing a CDB and PDBs.
  • Managing PDBs Open Mode and Settings.
  • Configuring CDB and PDBs Initialization Parameters.
• MANAGING STORAGE IN A CDB AND PDBS
  • Managing Permanent Tablespaces in CDB and PDBs.
  • Managing Temporary Tablespaces in CDB and PDBs.
• MANAGING SECURITY IN A CDB AND PDBS
  • Managing Common and Local Users.
  • Managing Common and Local Privileges.
  • Managing Common and Local Roles.
  • Understanding Shared and Non-Shared Objects.
  • Managing Common and Local Profiles.
• MANAGING AVAILABILITY
  • Managing Backups.
  • Managing Recovery Operations.
  • Managing Flashback Database.
  • Duplicating PDBs.
  • Special Situations and Views.
• MANAGING PERFORMANCE
  • Managing Performance.
  • Managing Resource Allocation.
  • Maximizing Consolidated Database Replay.
• MISCELLANEOUS
  • Exporting and Importing Data.
  • Loading Data.
  • Auditing Operations.
  • Scheduling Jobs.
  • Using Other Products .