Course Content
Managing the Oracle Instance
- Initialization Parameters
- Memory Management
- Automatic Shared Memory Management (ASMM)
- Database Startup and Shutdown
- Viewing the Alert History
- Using Trace Files
- Data Dictionary: Overview
Managing Database Storage
- Managing Tables / Data Storage.
- Setting Storage Parameters
- Managing Tablespaces / Data Files
- Automatic Storage Management (ASM)
- SYSTEM and SYSAUX Tablespaces.
- Creating Additional Tablespaces
- Adding Data Files to a Tablespace
- Tablespace Online / Offline
- Locally Managed Tablespaces
- Multiple Block sizes
- Bigfile Tablespaces
- Temporary Tablespaces
- Database Default Tablespaces
- Renaming Tablespaces
- Renaming and Relocating Data Files
- Dropping Tablespaces and Data Files
Managing Undo Data
- Managing Rollback Segments
- Setting up Automatic Undo Management
- Monitoring Undo Segments
- Undo Tablespace & Sizing
- Undo Advisor
Redo Logs and Control Files
- Managing Redo Logs
- Types of Redo Log
- Archiving Modes
- Log Switches and Checkpoints
- Creating Online Redo Log Groups
- Creating Log Group Members
- Renaming/Relocating Redo Log Members
- Dropping Redo Log Groups / Members
- Archiving Redo Logs
- Specifying Archived Log Destinations
- Manual Archiving of Redo Logs
- Control Files
- Creating/Dropping Control Files
Database Security*
- Key Concepts
- Connecting as SYSDBA/SYSOPER
- Password Management
- Schemas and Synonyms
- Dropping Users
- Profile Management
- Creating / Altering/ Dropping Roles
- Enabling and Disabling Roles
- Granting / Revoking System Privileges and Roles.
- Granting / Revoking Object Privileges
EXPORT, IMPORT & DATAPUMP*
- Introduction to Utilities
- EXP: Runtime EXPORT Command
- EXP Parameters and Operation Notes
- Restrictions on Export
- IMP: Runtime IMPORT Command
- nIMP Parameters & Operation Notes
- Using Data Pump Features
- Transportable Tablespaces
SQL Loader*
- Conventional path
- Types of file
- The control file
Backup and Recovery Procedures
- Basic Concepts
- Backup Guidelines
- Performing Full / Partial Back-ups
- Control File Backups in ARCHIVELOG mode
- Online Backup
- Recovery Mechanisms
- Types of failure
- Appropriate Recovery Procedures
- Restoring Damaged Data Files
- Restoring Archived Redo Log Files
- Restoring a Full Backup
- Closed Database Recovery
- Open Database Recovery
- Incomplete Media Recovery
Optimisation*
- Introduction to Database Tuning
- Gathering Tuning Statistics
- Tuning Memory
- Balancing Disk I/O
- Resource Contention
- Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Monitor (ADDM)
Network Architecture
- Basic configuration
- Oracle Net Manager
- Listener administration
- Using and configuring Oracle Names
- Networking Wizard
Shared Server*
- Using shared server
- Configuration
- Restrictions
Database Architecture* and ASM
- Oracle Database Architecture Overview.
- ASM General Architecture
- Creating an ASM Instance
- ASM Storage Concepts
- The ASMCMD Utility
Configuring for Recoverability*
- Backup and Recovery Functionality
- Typical Backup and Recovery Tasks.
- Oracle Backup and Recovery Solutions.
- Causes of File Loss
User-Managed Backup & Recovery
- Restoring and Recovering
- Critical Versus Non-critical
- Recovering from a TEMPFILE Loss
- Recovering a Read-Only Tablespace
Configuring RMAN
- Using RMAN to Create Backups
- Configuring Persistent RMAN Settings.
- Control File Auto-backups
- Configuring and Allocating Channels for Use in Backups
- Configuring Backup Optimization
Creating Backups
- Creating an Oracle-Suggested Backup.
- Creating Backup Sets & Image Copies.
- Creating a Whole Database Backup
- RMAN Backup Types.
- Monitoring Block Change Tracking
- Archival Backups: Concepts
Using RMAN Recovery Catalog*
- RMAN Repository Data Storage: Comparison of Options
- Storing Information in the Recovery Catalog.
- Registering a Database in the Recovery Catalog
- Resynchronization: Concepts
- Using RMAN Stored Scripts
- Backing Up and Recovering the Recovery Catalog
Using RMAN to Perform Recovery*
- Using RMAN RESTORE and RECOVER Commands
- Performing Recovery Using Enterprise Manager
- Recovery Using Incrementally Updated Backups
- Perform a Fast Switch to Image Copies
- Restoring and Recovering the Database on a New Host
- Performing Disaster Recovery
Using RMAN to Duplicate a Data*
- Creating a Duplicate Database
- Creating an Initialization Parameter File for the Auxiliary Instance.
- Allocating Auxiliary Channels
- Understand RMAN Duplication
- Using EM to Clone a Database
- Cloning a Running Database
Point-in-time Recovery*
- Tablespace Point-in-Time Recovery (TSPITR) Concepts.
- TSPITR Architecture.
- When to Use TSPITR.
- Determining the Tablespaces for the Recovery Set.
- Using Enterprise Manager to Perform TSPITR.
- Understanding TSPITR Processing.
- Troubleshooting RMAN TSPITR
Monitoring and Tuning RMAN*
- Monitoring RMAN Sessions
- Interpreting RMAN Message Output
- Using the DEBUG Option
- Tuning RMAN
- RMAN Multiplexing
- Comparing Synchronous and Asynchronous I/O
- Tape Subsystem Performance Rules
Using Flashback Technology*
- Transactions and Undo
- Guaranteeing Undo Retention
- Preparing Your Database for Flashback
- Flashback Drop and the Recycle Bin
- Using Flashback Technology to Query Data
- Flashback Transaction Wizard
Using Flashback Database*
- Flashback Table
- Enabling Row Movement on a Table
- Flashback Database Architecture
- Configuring Flashback Database
- Performing Flashback Database Using EM
- Flashback Database Considerations
- Flashback Data Archive
Diagnosing the Database*
- Automatic Diagnostic Workflow & Repository.
- Location for Diagnostic Traces
- Viewing the Alert Log Using Enterprise Manager
- The Support Workbench and Oracle Configuration Manager
- Create a Service Request
- Package and upload diagnostic data to Oracle Support
- Incident Packaging Configuration
- Health Monitor Overview & Data Recovery Advisor
Managing Memory*
- Oracle Memory Structures
- Automatic Memory Management (AMM) Overview
- Oracle Database Memory Parameters
- Auto Memory Parameter Dependency
- Automatic Shared Memory Management (ASMM) Overview
- Automatic PGA Memory Management
- Using the Memory Advisor to Size the SGA
- Memory Tuning Guidelines for the Library Cache
Managing Database Performance
- Tuning Activities
- Performance Planning & Tuning Methodology
- Instance Tuning
- Troubleshoot and Tune Views
- Automatic Workload Repository
- SQL Tuning & SQL Advisors
- Using the SQL Tuning Advisor
- SQL Access Advisor: Overview
Using the Segment Advisor*
- Space Management: Overview
- Proactive Tablespace Monitoring
- Thresholds and Resolving Space Problems
- Monitoring Tablespace Space Usage
- Shrinking Segments
- Space Reclamation with ASSM
- Automatic Segment Advisor
- Minimum Compatibility Level
Scheduler*
- Simplifying Management Tasks
- Key Components and Steps
- Programs
- Schedules
- Jobs and Job classes
- Windows