Training Categories Oracle 12c Troubleshooting and Maintenance for Administrators

Oracle 12c Troubleshooting and Maintenance for Administrators

Oracle 12c Troubleshooting and Maintenance for Administrators Course Details:

In this course, you will learn how to troubleshoot and maintain an Oracle 12c database. This course is designed to equip the database administrator with essential maintenance and troubleshooting tools.

    No classes are currenty scheduled for this course.

    Call (919) 283-1674 to get a class scheduled online or in your area!

1. Basic Oracle Architecture

  • Architecture Overview
  • Database Structures
  • Process Structures
  • Memory Structures - SGA and PGA

2. Starting and Stopping the Database

  • Connecting as a Privileged User
  • Password File Authentication
  • Starting a Database
  • Shutting Down a Database
  • Reading the Alert Log / Trace Files
  • Quiescing the Database
  • SPFILE / Parameter Management

3. Logical Components

  • Basic Definitions
  • Blocks / Extents / Segments / Tablespaces
  • Fragmentation / Deallocation
  • Managing Undo Segments
  • Automatic Undo Management
  • Managing Sort Activity
  • Managing Data Segments
  • Managing Index Segments
  • Monitoring Database Segments
  • Tablespace Overview
  • System Tablespace
  • Types of Tablespaces
  • Creating Additional Tablespaces
  • Altering Tablespaces

4. Oracle Database Files

  • Basic Structures of an Oracle RDBMS
  • Data Files
  • Redo Log Files / Archived Redo Logs
  • Control Files
  • Oracle-Managed Files (OMF)

5. Users and Security

  • Managing Database Users
  • System / Object Privileges
  • Managing Roles / Profiles
  • Resource and Password Management

6. Physical NOARCHIVELOG Mode Backups

  • Oracle Database Backups
  • Automatic Recovery Architecture
  • NOARCHIVELOG / ARCHIVELOG Physical Backups
  • Closed Backups

7. Configuring Archivelog Mode

  • Physical ARCHIVELOG Mode Backups
  • Establishing Multiple Archiving Destinations
  • Open backups in ARCHIVELOG Mode
  • Controlfile Backup

8. Complete Recovery

  • Recovery Structures and Processes
  • Recovery in NOARCHIVELOG and ARCHIVELOG Mode

9. Incomplete Recovery

  • What is Incomplete Recovery?
  • Recovering from Loss of Current Redo Log Files

10. Recovery Manager Configuration

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

11. Recovery Manager Operations

  • Using the BACKUP Command
  • Compressed Backups
  • Whole Database Copying
  • Incremental Backups
  • Block Change Tracking
  • RMAN Backup Monitoring
  • REPORT and LIST Commands

12. Non-Critical Loss Recovery

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

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

14. Flashback Database

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

15. User Error Recovery

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

16. Block Corruption Management

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

17. Diagnostic Sources

  • Alert Logs and Trace Files
  • Enterprise Manager and Alerts
  • Controlling Trace File Size
  • Alert Notification

18. Performance Tuning

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

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
  • Oracle server architecture
  • Start and stop an Oracle database
  • Manage all Oracle file structures
  • Manage security
  • Perform appropriate backups
  • Perform complete and incomplete recoveries
  • Configure and use recovery manager
  • Identify and use diagnostic information
  • Flashback a database
  • Use the new automation tools
  • Use the new performance tuning tools
  • Manage other database resources

Lab 1: Architecture

Lab 2: Database Startup and Shutdown

Lab 3: Using and Managing SPFILES and Parameters

Lab 4: Users and Security

Lab 5: Advanced Memory Management

Lab 6: Oracle Database Files

Lab 7: Backup and Archivelog Mode

Lab 8: Complete Recovery

Lab 9: Incomplete Recovery

Lab 10: Recovery Manager Configuration

Lab 11: Recovery Manager Backups

Lab 12: Database Recovery using RMAN

Lab 13: Flashback Database

Lab 14: Flashback for User Errors

Lab 15: Dealing With Block Corruption

Lab 16: Automated Management Tools

Lab 17: Diagnostic Sources

Lab 18: Performance Tuning

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

Ready to Jumpstart Your IT Career?

CONTACT US NOW!