Seminarinhalt
Core Concepts and Tools of the Oracle Database
- ASM Storage Concepts
- Connecting to the Database and the ASM Instance
- DBA Tools Overview
Configuring for Recoverability
- Using the Recovery Manager (RMAN)
- Configuring your Database for BR Operations
- Configuring Archivelog Mode
- Configuring Backup Retention
- Configuring and Using a Flash Recovery Area (FRA)
Using the RMAN Recovery Catalog
- Setting up a Recovery Catalog
- Recording Backups
- Using RMAN Stored Scripts
- Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop and Virtual Private Catalog)
Configuring Backup Settings
- Configuring Autobackup of Control File
- Backup optimization
- Advanced Configuration Settings: Compressing Backups
- Configuring Backup and Restore for Very Large Files (Multisection)
Creating Backups with RMAN
- Creating and Using the following:
- - Backup Sets and Image Copies
- - Whole Database Backup
- - Fast Incremental Backup
- - Configure Backup Destinations
- - Duplexed Backup Sets
- - Archival Backups
Restore and Recovery Task
- Causes of File Loss
- Automatic Tempfile Recovery
- Recovering from the Loss of a Redo Log Group
- Recovering from a Lost Index Tablespace
- Re-creating a Password Authentication File
- Complete and Incomplete Recovery
- Other Recovery Operations
Using RMAN to Perform Recovery
- Recovering Image Copies and Switching Files
- Restore and Recovery of a Database in NOARCHIVELOG Mode
- Incomplete Recovery
- Performing Recovery with a Backup Control File
- Restoring from Autobackup: Server Parameter File and Control File
- Restoring and Recovering the Database on a New Host
Monitoring and Tuning RMAN
- Balance Between Speed of Backup Versus Speed of Recovery
- RMAN Multiplexing
- Synchronous and Asynchronous I/O
- Explaining Performance Impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION
Diagnosing the Database
- Block Corruption
- Automatic Diagnostic Repository (ADR)
- Health Monitor
- The ADR Command-Line Tool, ADRCI
Using Flashback Technology I
- Using Flashback Technology to Query Data
- Flashback Table
- Flashback Transaction Query
- Performing Flashback Transaction Backout
Using Flashback Technology II
- Flashback Drop and the Recycle Bin
Performing Flashback Database
- Performing Flashback Database Operations
- Monitoring Flashback Database
Managing Memory
- Oracle Database Memory Parameters
- Using Automatic Memory Management
- Automatic Shared Memory Management
- Using Memory Advisors
- Using Data Dictionary Views
Managing Database Performance
- Using Statistic Preferences
- Optimizer Statistics Collection
- Monitor the Performance of Sessions and Services
- Automatic Workload Repository (AWR)
- Describing the Benefits of Database Replay
Managing Performance by SQL Tuning
- Using SQL Tuning Advisor
- SQL Access Advisor
- SQL Performance Analyzer Overview
Managing Resources
- Accessing and Creating Resource Plans
- Creating Consumer Group
- Specifying Resource Plan Directives, including:
- - Limiting CPU Utilization at the Database Level
- - Instance Caging
- Activating a Resource Plan
- Monitoring the Resource Manager
Automating Tasks with the Scheduler
- Creating a Job, Program, and Schedule
- Using Time-Based, Event-Based, and Complex Schedules
- Describing the Use of Windows, Window Groups, Job Classes, and Consumer Groups
- Multi-Destination Jobs
Managing Space in Blocks
- Monitoring Space
- Compressing Data
Managing Space in Segments
- Additional Automatic Space-Saving Functionalit
- Shrinking Segments
- Segment Advisor
- Managing Resumable Space Allocation
Managing Space for the Database
- Transporting Tablespaces
- Transporting Databases
Duplicating a Database
-
Using RMAN to Create a Duplicate Database
-
Cloning a Database from a Backup
-
Duplicate a Database Based on a Running Instance
-
Targetless Duplicating a Database
Zielgruppe
Datenbank Administratoren, Technische Berater, Data Warehouse Administratoren, Entwickler
Voraussetzungen
Oracle Database 11g: Administration Workshop I