Oracle Database : Administration Workshop II

    Oracle Database 11g: Administration Workshop II 

Screen Shot 2016-09-05 at 1.49.02 PM

 What you will learn :

This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Learn To:

Diagnose and repair data failures with Flashback technology.
Manage space to optimize database storage so you can respond to growing space requirements.
Monitor and manage major database components, including memory, performance and resources.
Secure the availability of your database through appropriate backup and recovery strategies. Automate DBA tasks with the Scheduler.
Database Administrators, Support Engineer, Technical Administrator, Technical Consultant.
Required Prerequisites
Oracle Database 11g Database Administration
Oracle Database 11g: Administration Workshop I Release 2
Course Objectives :
Configure the Oracle Database for optimal recovery
Configure the database instance such that resources are appropriately allocated among sessions and tasks
Schedule jobs to run inside or outside of the database
Use compression to optimize database storage and duplicate a database
Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
Use an appropriate and flexible memory configuration for your database
Identify burdensome database sessions and poorly performing SQL
Course Topics :
Core Concepts and Tools of the Oracle Database
Configuring for Recoverability
Using the RMAN Recovery Catalog
Configuring Backup Settings
Creating Backups with RMAN
Restore and Recovery Task
Using RMAN to Perform Recovery
Monitoring and Tuning RMAN
Diagnosing the Database
Using Flashback Technology I
Using Flashback Technology II
Performing Flashback Database
Managing Memory
Managing Database Performance
Managing Performance by SQL Tuning
Managing Resources
Automating Tasks with the Scheduler
Managing Space in Blocks
Managing Space in Segments
Managing Space for the Database
Duplicating a Database
All Rights Reseved ©