Unit 1: Fundamentals and Oracle Database tools
Oracle Database fundamental concepts and ASM
Configuration and management of the DBA tools
Unit 2: Configuring for recovery
Starting and configuring RMAN
ARCHIVELOG mode and Fast Recovery Area
Multiple destinations for archive log files
Retention Policy
Unit 3: Using the RMAN Catalog for Recovery
Recovery Catalog and Control File for RMAN Repository
Creating, configuring and registering a Recovery Catalog
Synchronizing a Recovery Catalog
Using RMAN scripts
Virtual Private Catalog
Unit 4: Configuring backup parameters
Backup configuration with Enterprise Manager
Automatic backup of the control file
Backup locations, channels for tapes
Backup optimisation
Compressed and encrypted backup
Unit 5: Backing up with RMAN
Create an image copy, a whole backup and a full backup
Activate fast incremental backup
Backup the Backup Sets
RMAN Multi-sections backup
Long retention archive backup
Reporting and maintaining backups
Unit 6: Restoration and Recovery tasks
Main recovery operations
Control file backup and recovery
Redo Log File Group recovery
Unit 7: Recovery with RMAN
Complete recovery if critical data was lost
Complete recovery if non-critical data was lost
Recovery using incremental backup
Using image Copy for rapid recovery
Migration to another server
Recovery via control file backup
Unit 8: Monitoring and Tuning RMAN
Supervising RMAN jobs progression
Corresponding Asynchronous I/O and RMAN multiplexing
Backup speed versus recovery speed
MAXPIECESIZE, FILESPERSET, MAXOPENFILES parameters
BACKUPDURATION parameter
Unit 9: Database diagnostics
Detecting and repairing a corrupted database
Manipulating corrupted blocks
Automatic Diagnostic Repository
Performing Health Checks
Unit 10: Using Flashback Technology I
Flashback Query, Row Movement, Table Flashback
Transaction Flashback Query
Unit 11: Using Flashback Technology II
FlashbackData Archive
Flashback RecycleBin
Unit 12: Performing a Database Flashback
Configuration and execution
Unit 13: Managing the Memory
SGA components
Automatic Memory Management
Manual and automatic configuration
Unit 14: Managing the Database performance
Sessions and services performance supervision
Advantages of the Database replay
Unit 15: Managing the SQL Tuning performances
Identify and tune SQL instructions using the more resources
SQL Access Advisor to tune a Workload
Unit 16: Managing Resources
Database Resource Manager configuration
Accessing and creating the Resource Plan
Consumer Groups
Resource Consumers maps related to Plans
Resource Plan activation
Resource Manager monitoring
Unit 17: Automatization of tasks with the Scheduler
Creating a Job, a Program and Scheduler
Supervising a Job Execution
Notification by e-mail
Using a Job Chain to perform a series of related tasks
Describing the Job Scheduler on remote systems
Using the concept of Scheduler to prioritize jobs
Unit 18: Space management
Saving space by using Compression
Proactive supervision and Tablespace management
Delayed control segment
Segment Advisor
The segment Shrink functionality
Resumable Space Allocation
Unit 19: Managing space for the database
4 KB – Sector disks usage
Transportable Tablespaces
Unit 20: Duplicating a Database
Database Duplication methods
Duplicating a database with RMAN
Duplicating a database using the current running instance
Aequasys
Aequasys
