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.
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
Monitor and manage major database components, including memory, performance and
Secure the availability of your database through appropriate backup and recovery strategies.
Automate DBA tasks with the Scheduler.
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