Oracle 10G DBA Training (60 Hours)

1. Introduction

• Identify the oracle product
• Describe the basic concept of a relational database

2. Installing oracle database 10g software

• System requirements.
• Redhat Linux Installation
• Install software with the Oracle Universal Installer on Linux Platform

3. Create an oracle database

• Oracle Database Architecture
• Oracle instance architecture
• Oracle Read Consistency and Concurrency

4. Controlling the database

• Start and stop the agent
• Start and stop the enterprise manager database console
• Start and stop the listener
• Startup and shutdown the database

5. Database Creation

• Manual
• Database Configuration Assistant(DBCA)

6. Storage Structures

• Defining the table spaces and data files
• Create table spaces
• Manage table spaces
• Obtain table space information

7. File Management

• Control File Management
• Redo Log File Management
• Parameter File Management
• Obtain table space information

8. Administering users

• Create and manage database user accounts
• Create and manage roles
• Grant and revoke privileges
• Control resource usage by using Profiles

9. Oracle Net Services

• Understand Oracle Net concepts
• Use Oracle Net Manager to create and configure listeners
• Use the listener control utility to control the Oracle Net Listener
• Use the Oracle Net Manager to configure client and middle-tier connection
• Use TNSPING to test Oracle Net connectivity

10. Managing schema objects

• Create and modify tables
• Define constraints
• View the attributes of a table
• View the contents of a table
• Create indexes and views

11. Oracle Backup & Recovery (User Managed)

• Introduction
• Design, Testing, Implementation Strategies
• Offline(cold)/Online(hot) backups
• Performing Complete Recovery
• Performing Incomplete Recovery

12. Oracle Backup & Recovery (System Managed: RMAN)

• Introduction
• RMAN Architecture
• Configuration
• Setting up Catalog
• Online/Offline Backup using RMAN
• Backups Options
• Incremental Backups,
• Scripts,
• Complete Recovery
• Incomplete Recovery
• Table Space Point in Time Recovery (TSPITR)
• Disaster Recovery
• Recovery of Corrupted DB-Blocks

13. Cloning

• RMAN
• Manual

14. Logical Backup & Restore

• Introduction Data pump (expdp, impdp) Utilities
• Exporting/Importing Tables
• Exporting/Importing Schemas
• Exporting/Importing Table space
• Exporting/Importing Database
• Transportable Table space within & across the database and platforms

15. High Availability(HA)

• Database Patch Management Introduction
• Applying Interim and Patch set Patches
• Patch History & Documentation

16. Log Miner

• Contents
• Reading / Extracting the Content of Redo Logs (Online/archived) for recovery or auditing purpose

17. Flashback

• Introduction
• Configuration
• Flashback Query/Table/Drop/Database
• Flashback Version Query
• Creating Restore Points

18. Automatic Storage Management

• Introduction
• Configuration of an ASM Instance
• ASM Processes & Parameters
• Managing the ASM Disk groups using asmcmd Utility
• Moving Non ASM Instance to ASM Instance

19. Data Guard

• Introduction
• Architecture
• Configuring Standby database
• Performing Switch Over and Fail Over
• Monitoring & Troubleshooting

20. Oracle Performance Tuning

• Introduction
• Proactive Vs Reactive Tuning
• Tuning through effective DB Configurations
•  Health Management/Periodical Checkup
• DB Defragmentation
• Configuring and using Oracle Parallel Processing Feature
• Tuning Memory, Disk I/O
• Resource Intensive SQL
• Managing the DB Statistics ( for CBO)
• Managing the AWR Snapshots
• Generating/ Interpreting the AWR Report

21. Oracle Grid Control

• Introduction
• Architecture
• Installation & Configuration
• Managing the multiple database nodes using OEM grid control