2002 - Oracle 12c Database Administration II


2002 - Oracle 12c Database Administration II


Price
Length : 5 days
$2,695.00

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

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

Who Needs to Attend

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

Prerequisites

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

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

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

Class Dates:

Classes being scheduled,
call 1-800-755-0142 or

Contact Us with your request.

On Site Class Available

ExpertONE Learning Solutions Provider Microsoft Certified Partner Logo GSA Advantage