Oracle 12c: Database Administration II

COURSE OUTLINE:

Description

In this course, you will learn a wide variety of advanced concepts to let you fully master administration of an Oracle database.

This course includes a thorough discussion of new Oracle 12c automation features including flashback technologies, automated storage management, automated tuning tools, and automated management tools (such as the new scheduler).

Audience

  • Data analysts
  • Database administrators
  • Systems administrators
  • Network managers
  • Technical support personnel

Learning Objectives

  • Configure for globalization support
  • Secure the Oracle listener
  • Configure and use recovery manager
  • Identify and use diagnostic information
  • Recover your database
  • Flashback a database
  • Automation tools
  • Performance tuning tools
  • Manage database storage, memory, and other database resources
  • Use scheduler to automate tasks
  • Configure and use Automatic Storage Management (ASM)

1. Recovery Manager Configuration

  • Parameters Affecting RMAN
  • Use of a Flashback Recovery Area
  • The CONFIGURE Command
  • Persistent Settings
  • NOCATALOG / CATALOG Mode
  • Catalog Management / Virtual Catalog
  • Channel Allocation
  • Controlfile Autobackup
  • Retention Policies

2. Recovery Manager Operations

  • Using the BACKUP Command
  • Creating Backup Sets / Image Copies
  • Parallelization
  • Compressed Backups
  • Whole Database Copying / Cloning
  • Incremental Backups
  • Block Change Tracking
  • RMAN Backup Monitoring
  • REPORT and LIST Commands

3. Non-Critical Loss Recovery

  • Password and Network Files
  • Read-Only Tablespaces
  • Temporary Tablespaces
  • Index Tablespaces
  • Redo Log Members / Control Files

4. Database Recovery

  • Recovering the Control File
  • Reasons for Incomplete Recovery
  • Recovery after RESETLOGS
  • Incomplete Recovery Using EM
  • Incomplete Recovery Using RMAN
  • Incomplete Recovery Using SQL

5. Flashback Database

  • When to Use
  • Configuration and Use
  • Monitoring Flashback Database
  • Using EM for Flashback Database
  • Flash Recovery Area Maintenance
  • Flash Recovery Area Monitoring

6. User Error Recovery

  • The New Recycle Bin
  • Flashback a Dropped Table Using EM
  • Querying Dropped Tables
  • Flashback Versions Query
  • Flashback Transaction Query

7. Block Corruption Management

  • DBVERIFY and ANALYZE
  • DBMS_REPAIR
  • Block Media Recovery
  • DBMS_BLOCK_CHECKING Parameter
  • Using RMAN for Block Corruption

8. Automatic Database Management

  • Management and Advisory Framework
  • Automatic Statistics Collection
  • The Automated Workload Repository
  • Database Advisors
  • SQL Tuning Advisors
  • SQL Access Advisors
  • Active Session History (ASH)
  • Automatic Statistics Collection
  • Automatic Undo Retention
  • Adjusting Thresholds / Managed Metrics

9. Automatic Storage Management

  • ASM Architecture
  • ASM Initialization Parameters
  • ASM Filenames in SQL Commands
  • ASM Tablespaces
  • Disk Groups / Failure Groups
  • ASM Startup/Shutdown / ASMCMD
  • ASM Disk Group Administration

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 Consumer Groups
  • Resource Plans and Directives
  • Directives for Resource Allocation
  • Adaptive Consumer Group Mapping
  • Enabling and Switching Plans

12. Scheduler

  • Creating Jobs and Job Classes
  • Creating Schedules and Windows
  • Scheduler Programs
  • 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 / SGA_TARGET
  • Automatic PGA Memory Management
  • The Memory Advisor

17. Performance Tuning

  • Application Identification
  • Enterprise Manager Tools
  • SQL Tuning Advisor
  • SQL Access Advisor
  • DBMS_SQLTUNE
  • DBMS_ADVISIOR
  • Quick Tune

18. The Virtual Private Database