Oracle 12c Database Administration II
Oracle 12c Database Administration II Course Details:
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).
No classes are currenty scheduled for this course.
Call (919) 283-1653 to get a class scheduled online or in your area!
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
*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
- 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)
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
- Data analysts
- Database administrators
- Systems administrators
- Network managers
- Technical support personnel