Oracle 12c Database Administration II

5 Day | Instructor Led

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

Inquire About:
Oracle 12c Database Administration II

Ideal Candidates for Oracle 12c Database Administration II Class

Data analysts
Database administrators
Systems administrators
Network managers
Technical support personnel

Oracle 12c Database Administration II Prerequisites

Oracle 12c SQL & SQLPLUS Express Introduction
Oracle 12c PL/SQL Introduction

What You'll Get in Oracle 12c Database Administration II

What You'll Learn in Oracle 12c Database Administration II

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)

No Certification Test Available For This Course

No Certification Test Available For This Course

Oracle 12c Database Administration II Outline

1. Recovery Manager Configuration

  • Parameters Affecting RMAN
  • Use of a Flashback Recovery Area
  • The CONFIGURE Command
  • Persistent Settings
  • 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

  • Block Media Recovery
  • 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
  • Quick Tune

18. The Virtual Private Database


A. Erlich


I just wanted to say your presentation on Social Media Technology and Security was the finest I have ever attended.

Wilder Guerra

US Navy Reserve

This course is definitely an eye opener. With how much social media has taken over, it is important to be fully aware of the capabilities along with all the risks it brings. It is important to get this course because social media is the new norm.

Rebekah Coughlin


The Social Media and Security Training course offered by UKI is a great and beneficial course combining technical training to fully understand TCP IP networking, DNS, and the harms of malware and cross-site scripting; as well as practical training that allowed attendees to play with open source social intelligence gathering solutions. This is the perfect class for those involved in IT security and interested in social media and identity theft.

Top Related Courses

In this course, you will receive a hands-on introduction to advanced SQL concepts, especially as they relate to Oracle's implementation of the SQL Language. Topics necessary to the development and administration of an Oracle 12c database are covered. This course is specifically designed for those who know generic SQL but are not familiar with SQL*Plus and more importantly, Oracle's implementation of SQL.

In this course, you will learn about the Oracle Server architecture, expand the size of the database, implement security, and how to perform specific database administration tasks.

You will receive a hands-on introduction to SQL Basics and SQL*Plus and learn about relational databases and how to access them through SQL and SQL*Plus.

© 2019 Ultimate Knowledge Insitute | All Rights Reserved
GSA# GS-35F-0469W