This Database 11g Administration training teaches you to perform backup and recovery, and diagnose and repair data failures. Manage major database components like memory, performance and resources using Oracle Database 11g.

Learn To

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.

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

Audience

• Administrator

• Database Administrator

• Implementer

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