Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Oracle 12c Database Administration II

GK# 7492 Vendor# OR203

Course Overview

TOP

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).

What You'll Learn

TOP
  • 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)

Outline

TOP
Viewing outline for:

Virtual Classroom Live Outline

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

Labs

TOP
Viewing labs for:

Virtual Classroom Live Labs

Lab 1: Recovery Manager Configuration

Lab 2: Recovery Manager Backups

Lab 3: Database Recovery using RMAN

Lab 4: Flashback Database

Lab 5: Flashback for User Errors

Lab 6: Dealing With Block Corruption

Lab 7: Automated Management Tools

Lab 8: Using the Scheduler

Lab 9: Managing Storage

Lab 10: Scheduler

Lab 11: Listener Security

Lab 12: Diagnostic Sources

Lab 13: Oracle Auditing

Lab 14: Performance Tuning

Prerequisites

TOP

Who Should Attend

TOP
  • Data analysts
  • Database administrators
  • Systems administrators
  • Network managers
  • Technical support personnel
Course Delivery

This course is available in the following formats:

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 5 day

Request this course in a different delivery format.
Enroll