Course details
Introduction
This course takes the database administrator beyond the basic tasks covered in the first workshop. The student begins by gaining a much deeper understanding of possibly the most important job of a DBA - backup and recovery. The concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios. Also, the DBA learns how to manage memory effectively and how to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are also covered. Participants will learn to how 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, and secure the availability of your database by appropriate backup and recovery strategies.
This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led in class or instructor-led online formats of this course will meet the Certification hainds-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.
Course Content
- Lesson 1: Core Concepts and Tools of the Oracle Database
- Lesson 2: Configuring for Recoverability
- Lesson 3: Using the RMAN Recovery Catalog
- Lesson 4: Configuring Backup Settings
- Lesson 5: Creating Backups with RMAN
- Lesson 6: Restore and Recovery Tasks
- Lesson 7: Using RMAN to Perform Recovery
- Lesson 8: Monitoring and Tuning RMAN
- Lesson 9: Diagnosing the Database
- Lesson 10: Using Flashback Technology I
- Lesson 11: Using Flashback Technology II
- Lesson 12: Performing Flashback Database
- Lesson 13: Managing Memory
- Lesson 14: Managing Database Performance
- Lesson 15: Managing Performance by SQL Tuning
- Lesson 16: Managing Resources
- Lesson 17: Automating Tasks with the Scheduler
- Lesson 18: Managing Space
- Lesson 19: Managing Space for the Database
- Lesson 20: Duplicating a Database
Course Location
About Torque IT
About Torque IT
With over 20 years of experience, Torque IT is recognised throughout the globe as the principal InformationCommunication Technology (ICT) training solutions provider to blue chip companies and the public sector.
The Torque IT business is based on a culture of customer service and an unwavering commitment to always providing the highest quality product and service available. Torque IT offers completely customizable training and enablement solutions that are tailored to your specific requirements whilst retaining the quality and credibility associated with standard vendor authorized training courses.
See all Torque IT courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- ZAR 232Duration: Upto 3 Hours
- Oracle APEX (Video-Based) UplatzZAR 232Duration: Upto 5 Hours
