---

Through hands-on experience in administering an Oracle 10g database, you will learn advanced concepts and fully master Oracle database administration.

Highlights

• Configure for globalization support
• Secure the Oracle listener
• Configure and use Recovery Manager
• Identify and use diagnostic information
• Recover your database
• Use the new automation tools
• Manage database storage
• Manage memory and other database resources
• Use Scheduler to automate tasks
• Why to flashback a database

Course Outline

• Parameters affecting RMAN
• Flashback recovery area
• The CONFIGURE command
• Persistent settings
• Using RMAN
• Channel allocation
• Controlfile Autobackup
• Retention policies

2. Recovery Manager Operations

• Using the BACKUP command
• Creating backup sets and image copies
• Parallelization
• Compressed backups
• Whole database copying
• Incremental backups
• Block change tracking
• RMAN Backup Monitoring

3. Non-Critical Loss Recovery

• Password files
• Read-only tablespaces
• Temporary tablespaces
• Index tablespaces
• Redo log members

4. Database Recovery

• Recovering the control file
• Reasons for incomplete recovery
• Recovery after RESETLOGS
• Incomplete recovery using EM, RMAN, and SQL

5. Flashback Database

• When to use
• Configuration
• Monitoring

6. Flashback Database

• Using EM for Flashback Database
• Flash Recovery Area maintenance and monitoring

7. User Error Recovery

• The new recycle bin
• Flashback a dropped table using EM

8. Block Corruption Management

• DBVERIFY and ANALYZE
• DBMS_REPAIR
• Block Media Recovery
• DBMS_BLOCK_CHECKING parameter
• Using RMAN for block corruption

9. Automatic Database Management

• Automatic statistics collection
• Automated workload repository
• Database advisors
• SQL Tuning advisors
• SQL access advisors
• Automatic undo retention
• Adjusting thresholds for managed metrics

10. Globalization Support

• Timezones and datetimes
• Language-dependent behavior
• Locales and variants
• Case and accent insensitive sorts
• Linguistic sorting
• Querying GS configuration

11. Resource Management

• Resource Manager Configuration
• Resource Management Groups
• Resource plans and directives
• Directives for resource allocation
• Adaptive Consumer Group Mapping

12. Scheduler

• Creating jobs and job classes
• Schedules and windows
• Prioritizing jobs
• Scheduler component reuse
• Query Scheduler information

13. Storage Management

• Tuning archiving
• Redo Log Size Advisor
• Segment Advisor
• Managing resumable operations
• Proactive tablespace management
• Table/ index size estimation
• Optimizing storage options
• Online index rebuilds

14. Listener Security

• Password authentication
• Securing EXTPROC
• Controlling access

15. Diagnostic Sources

• Alert logs and trace files
• Enterprise Manager and Alerts
• Controlling trace file size
• Alert notification

16. Memory Management

• Memory structures
• Automatic shared memory management
• SGA configuration
• Automatic PGA memory management
• Memory Advisor

Space is limited. Register today to save your space!