D79027GC10–Oracle Database 12c: Admin, Install and Upgrade Accelerated

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

D78850GC10 – Oracle Database 12c: Backup and Recovery Workshop

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

Oracle Database 12c: Managing Multitenant Architecture

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