Course Details

Oracle Database Administration I

COURSE CONTENT:
EXPLORING THE ORACLE DATABASE ARCHITECTURE
• Explain the Memory Structures
• Describe the Process Structures
• Overview of Storage Structures PREPARING THE DATABASE ENVIRONMENT
• Identify the tools for Administering an Oracle Database
• Plan an Oracle Database installation
• Install the Oracle software by using Oracle Universal Installer (OUI) CREATING AN ORACLE DATABASE
• Create a database by using the Database Configuration Assistant (DBCA) MANAGING THE ORACLE INSTANCE
• Setting database initialization parameters
• Describe the stages of database startup and shutdown
• Using alert log and trace files
• Using data dictionary and dynamic performance views CONFIGURING THE ORACLE NETWORK ENVIRONMENT
• Configure and Manage the Oracle Network
• Using the Oracle Shared Server architecture
MANAGING DATABASE STORAGE STRUCTURES
• Overview of tablespace and datafiles
• Create and manage tablespaces
• Space management in tablespaces ADMINISTERING USER SECURITY
• Create and manage database user accounts
• Grant and revoke privileges
• Create and manage roles
• Create and manage profiles MANAGING DATA AND CONCURRENCY
• Monitor and resolve locking conflicts
• Manage data using DML MANAGING UNDO DATA
• Overview of Undo
• Transactions and undo data
• Managing undo IMPLEMENTING ORACLE DATABASE SECURITY
• Database Security and Principle of Least Privilege
• Work with Standard Database Auditing DATABASE MAINTENANCE
• Use and manage optimizer statistics
• Use and manage Automatic Workload Repository (AWR)
• Use advisory framework
• Manage Alerts and Thresholds PERFORMANCE MANAGEMENT
• Use Automatic Memory Management
• Use Memory Advisors
• Troubleshoot invalid and unusable objects MOVING DATA
• Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
• Explain the general architecture of Oracle Data Pump
• Use Data Pump Export and Import to move data between Oracle databases
SQL TUNING
• SQL Tuning Process
• Oracle Optimizer
• Optimizer Statistics
• SQL Plan Directives
• SQL Tuning Advisor
• SQL Access Advisor
• SQL Performance Analyzer ORACLE DATABASE RESOURCE MANAGER
• Oracle Database Resource Manager: Overview
• Resource Manager Elements
• Using Resource Manager to Allocate Resources
• Creating a Simple Resource Plan
• Creating a Complex Resource Plan

Oracle Database Administration II
COURSE CONTENT:
EXPLORING THE ORACLE DATABASE ARCHITECTURE
• Explain the Memory Structures
• Describe the Process Structures
• Overview of Storage Structures 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 BACKUP STRATEGIES AND TERMINOLOGY
• Backup Solutions Overview and Terminology
• Balancing Backup and Restore Requirements
• Backing Up Read-Only Tablespaces PERFORMING BACKUPS
• RMAN Backup Types
• Incrementally Updated Backups
• Fast Incremental Backup
• Block Change Tracking
• Managing Backups IMPROVING YOUR BACKUPS
• Compressing Backups
• Using a Media Manager
• Backup and Restore for Very Large Files
• 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 USING RMAN-ENCRYPTED BACKUPS
• Creating RMAN-Encrypted Backups
• Using Transparent-Mode Encryption
• Using Password-Mode Encryption
• Using Dual-Mode Encryption
DIAGNOSING FAILURES
• Reducing Problem Diagnosis Time
• Automatic Diagnostic Repository
• Data Recovery Advisor
• 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 with the RESETLOGS Option PERFORMING RECOVERY
• Recovery of Server Parameter File, Control File (One and All)
• 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
• Performing Complete Recovery (of critical and noncritical data files)
• Performing Point-in-Time (PITR) or Incomplete Recovery 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 DUPLICATING A DATABASE
• Using a Duplicate Database
• Duplicating Database with "push" an"pull" techniques
• Choosing Database Duplication Techniques
• Creating a Backup-up Based Duplicate Database
• Understanding the RMAN Duplication Operation CONTAINER AND PLUGGABLE DATABASE ARCHITECTURE
• Challenges and Benefits
• Multitenant Architecture
• Provisioning PDBs CDB AND PDB CREATION
• Configuring and Creating a CDB
• Creating PDBs
• Dropping 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