Oracle 10g DBA II
Oracle 10g DBA II Course Details:
Through hands-on experience in administering an Oracle 10g database, you will learn advanced concepts and fully master Oracle database administration.
No classes are currenty scheduled for this course.
Call (919) 283-1653 to get a class scheduled online or in your area!
- 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
*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
- 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
Lab 1: Globalization Support
Lab 2: Listener Security
Lab 3: Configuring Recovery Manager
Lab 4: Using Recovery Manager
Lab 5: Managing Diagnostic Sources
Lab 6: Database Recovery
Lab 7: Flashback Database
Lab 8: User Error Recovery
Lab 9: Dealing with Corruption
Lab 10: Automated Management
Lab 11: Managing Storage
Lab 12: Managing Memory
Lab 13: Managing Resources
Lab 14: Scheduler
Data analysts, database administrators, systems administrators, network managers, and technical support personnel