Oracle 10g DBA II

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

Ready to Jumpstart Your IT Career?

CONTACT US NOW!