Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Oracle DBA - Essentials

( Duration: 5 Days )

The Oracle DBA Essentials training course is designed to provide database administrators practical experience in setting up, administering and troubleshooting an Oracle R1 or R2 database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server and will be able to ensure integrity and availability of a company's data. The course also covers monitoring the performance of the database and basic backup and recovery tasks.

This Oracle DBA Fundamentals Essentials workshop is an essential toolkit for all Database Administrators covering the practical skills needed by the DBA to perform the Oracle database administration function within their enterprise.

Have an understanding of relational database concepts and good operating system knowledge. Attend a training on SQL Essentials or equivalent practical experience. Knowledge of PL/SQL would be beneficial.

This Oracle DBA Essentials class is ideal for:

  • Analyst / Designers
  • Analyst / Programmers
  • Technicians

COURSE AGENDA

1

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
2

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
3

Managing Undo Data

  • Managing Rollback Segments
  • Setting up Automatic Undo Management
  • Monitoring Undo Segments
  • Undo Tablespace & Sizing
  • Undo Advisor
4

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
5

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
6

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
7

SQL Loader

  • Conventional path
  • Types of file
  • The control file
8

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
9

Optimization

  • Introduction to Database Tuning
  • Gathering Tuning Statistics
  • Tuning Memory
  • Balancing Disk I/O
  • Resource Contention
  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor (ADDM)
10

Network Architecture

  • Basic configuration
  • Oracle Net Manager
  • Listener administration
  • Using and configuring Oracle Names
  • Networking Wizard
11

Shared Server

  • Using shared server
  • Configuration
  • Restrictions
12

Database Architecture and ASM

  • Oracle Database Architecture Overview
  • ASM General Architecture
  • Creating an ASM Instance
  • ASM Storage Concepts
  • The ASMCMD Utility
13

Configuring for Recoverability

  • Backup and Recovery Functionality
  • Typical Backup and Recovery Tasks
  • Oracle Backup and Recovery Solutions
  • Causes of File Loss
14

User-Managed Backup & Recovery

  • Restoring and Recovering
  • Critical Versus Non-critical
  • Recovering from a TEMPFILE Loss
  • Recovering a Read-Only Tablespace
15

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
16

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
17

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
18

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
19

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
20

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
21

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
22

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
23

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
24

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
25

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
26

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
27

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
28

Scheduler

  • Simplifying Management Tasks
  • Key Components and Steps
  • Programs
  • Schedules
  • Jobs and Job classes
  • Windows

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X