Oracle DBA 11g

Course Content

Pre requisites : Basic SQL*plus script knowledge is needed
1. Introduction
• Different types of oracle products and features.
• New features in oracle 11g
• Differences among oracle9i, oracle 10g and oracle 11g features along with its importance.

2. Installing oracle database 10g software

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

3. Creation of an oracle database

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

4. Controlling the database
• 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 and architecture of Oracle 11g DBA
• Logical structure Vs Physical structure
• Defining the tablespaces and data files
• Create tablespaces
• Manage tablespaces
• Obtain tablespace information
• Managing Undo Data

7. File Management
• Control File Management
• Redo Log File Management
• Parameter File Management
• Obtain tablespace information

8. User Management
• Create and manage database user accounts
• Roles
• 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
• Testing Oracle Net connectivity
• Shared Server: Connection pooling

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
• Complete Recovery
• Incomplete Recovery
• Table Space Point in Time Recovery (TSPITR)
• Disaster Recovery

13. Cloning
• RMAN
• Manual

14. Logical Backup & Transporting data between databases
• 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. Oracle Enterprise Manager and Performance tuning
• New features and its analysis of statistics on performance Tuning

17. Proactive Maintenance
• Contents
• Optimizer statistics
• Automatic Workload Repository

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

19. Automatic Storage Management
• New features and implementation

20. Oracle Grid Control

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