Administration Workshop II

Giới Thiệu Khóa Học Administration Workshop II

In this course, 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 students learn to manage memory effectively and 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 covered. Topics are reinforced with hands-on practices.

Đối Tượng Tham Gia

This course is for Database Administrators, Support Engineers, Data Warehouse Administrators, and Technical Consultants.

Thời Lượng

40 giờ

Nội Dung Khóa Học Administration Workshop II

- Database Architecture and ASM
- Configuring for Recoverability
- Using the RMAN Recovery Catalog
- Configuring Backup Specifications
- Creating Backups
- Performing User-Managed Backup and Recovery
- Using RMAN to Perform Recovery
- Using RMAN to Duplicate a Database
- Performing Tablespace Point-in-time Recovery
- Monitoring and Tuning RMAN
- Using Flashback Technology
- Using Flashback Database
- Diagnosing the Database
- Managing Memory
- Managing Database Performance
- Using the Segment Advisor
- Managing Resources
- Automating Tasks with the Scheduler
- Administering the Scheduler
- Globalization.

Workshop II, Using the Segment Advisor, Managing Resources, Creating Backups