This course takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a much deeper understanding of possibly the most important job of a DBA: backup and recovery.Learn To:Automate DBA tasks with the Scheduler.Diagnose and repair data failures with Flashback technology.Manage space to optimize database storage and to be able to respond to growing space requirements.Monitor and manage major database components, including as memory, performance and resources.Secure the availability of your database by appropriate backup and recovery strategies.Backup RecoveryExpert instructors will also help you explore the concepts and architecture that support backup and recovery. You'll become familiar with the steps of how to carry it out in various ways and situations. Gain the skills to define and test your own backup and recovery scenarios. Learn Performance Evaluation Tuning TasksThis course will also teach DBAs how to manage memory effectively. Learn how to perform some performance evaluation and tuning tasks, including using some of the advisors.You'll also learn about the different types of flashback technologies, scheduling jobs inside and outside of the database and controlling system resource usage.
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
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
Advanced knowledge and use of Oracle Enterprise Server technology and features
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.