HBFITES Data Center, Collaboration, Security, Storage, Wireless, Telepresence Training +91-9886770046 info@hbfites.com

Oracle 10g Database Administration II - Release 2

Course Details

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

Course Prerequisites

  • Knowledge of SQL, Introduction to Oracle 10g SQL and SQL* Plus, or equivalent experience
  • Introduction to Oracle 10g PL/SQL or equivalent experience is highly recommended

Course Agenda

  • 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