| Oracle 10g DBA Online TrainingCourse Duration - 60hrs |
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
Overview
13.Cloning.
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 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
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
|
