Oracle 11g - Database Administration Training Course Oracle DBA Part 2
| Course code: |
ORACADM2 |
| Details: |
|
| Onsite | Enquire about bringing this course to your offices |
| Who should attend: |
This course is designed for database administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle Database 11g. This course is also suitable for delegates who need to be able to monitor and improve the database performance. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. This course covers the main topics of the Oracle exam #1Z0-053 Oracle Database 11g: Administration II. |
| Prerequisite skills: |
A working knowledge of Oracle SQL and Oracle Database Administration. |
Course Outline
This can be obtained by attendance on the pre-requisite courses. Knowledge of PL/SQL would be beneficial. This course is designed for database administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle Database 11g. This course is also suitable for delegates who need to be able to monitor and improve the database performance. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. This course covers the main topics of the Oracle exam #1Z0-053 Oracle Database 11g: Administration II. Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.
Course Content
This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email sales@jbinternational.co.uk
Oracle 11g Database Administration (Oracle DBA Part 2) Training Course Outline
- Manage Memory
- Plan a Backup and Recovery Strategy
- Oracle Recovery Structures
- Create and Manage a RMAN Recovery Catalog
- Configure Backup Settings
- Use RMAN to Perform Backups
- Use RMAN to Restore and Recover
- Monitor and Tune RMAN
- Perform Tablespace Point-in-Time Recovery
- Create a Duplicate Database with RMAN
- Additional Recovery Issues
- Use Flashback Technology to Recover a Database
- Use Flashback to Recover from User Errors
- Diagnostic Sources
- Use ASM
- Manage Database Performance
- Monitor and Manage Storage with the Segment Advisor
- Control Database Resources using Resource Manager
- Automate Management Tasks with the Scheduler
- Administer the Scheduler
- Use Globalization
