Duration: 45 days

Online  Fee: 15,000

Classroom Fee: 6000

     1. Introduction

  • What is DBA?
  • Why a Company needs a DBA?
  • Roles & Responsibilities of DBA
  • Identify the oracle product
  • Oracle Architecture
  • Physical and Logical Phase of Database

 

  1. Installing oracle database 11g software
  • System requirements.
  • Redhat Linux Installation
  • Install software with the Oracle Universal Installer on Linux Platform
  • Identify System Requirements
  • Discuss Oracle Base
  • Discuss Oracle Home

 

  1. Exploring The Oracle DatabaseArchitecture: General
  • More About Database Instances
  • What is Instance and SGA
  • General Database Architecture
  • Instance Background Processes
  • Discuss about New Feature Parameters
  • About PGA and Server Process

 

  1. Exploring The Oracle Database Physical Architecture:
  • Discuss about Control files
  • How to manage the Control files
  • Multiplexing the Control files
  • Multiplexing the online redo log files
  • Brief about online redo log files.
  • More About Datafiles concepts
  • Brief About Paramter files
  • Discuss about Password files.
  • How to create spfile and pfile
  • What is spfile?
  • Difference between spfile and pfile

     5.Create an oracle database

  • Database Configuration Assistant(DBCA)
  • Create A New Database
  • Configure An Existing Database
  • Drop A Database
  • Manually Create A Database
  • More About The Database Files

 

  1. Manually Starting and Stopping Database Services
  • Starting and Stopping Database Control
  • Different Startup Modes
  • Different Shutdown Modes
  • Starting and Stopping The Listener
  • Sysdba

 

  1. Manage Database Storage Structures: Tablespaces
  • What are segments?
  • What are extents?
  • What is Blocks?
  • Estimation of Extents
  • Dictionary Managed Table space
  • Locally Managed Table space
  • About Tablespaces
  • Tablespace Management
  • Autoextend Options
  • Drop Tablespace
  • Alter Tablespace
  • Tablespace Encryption

 

  1. Manage Database Storage Structures: Advanced Tablespaces
  • More About Bigfile Tablespaces
  • More About The Sysaux Tablespace

     9.Manage Database Storage Structures:

  • Managing Data Files
  • Managing Temp Files
  • Enable Oracle-Managed Files (OMF)
  • Renaming a data file
  • Temporary Groups

     10.Managing Undo Data

  • About Undo Space Management
  • Configure Undo Management
  • Undo_Management
  • Undo_Tablespace
  • Undo_Retention
  • Guarantee Undo Retention
  • Monitor Undo Space
  • Use The Undo Advisor

      11.Security: Administering User Security

 

  • Create and manage database user accounts
  • Create and manage roles
  • Grant and revoke privileges
  • Control resource usage by using Profiles
  • Create and Manage Database Accounts
  • Grant and Revoke Database Privileges
  • Resource Limits Via Profiles
  • Alter Profile
  • Drop Profile
  • Password Management Via Profiles
  • With Grant Option and Object Privileges
  • Alter User…Default Role
  • Set Role
  • Enhanced Default Security Settings

     12. 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
  • Start and stop Listener concepts
  • ora
  • ora
  • Concept about Database Links
  • Use the Oracle Net Manager to configure client and middle-tier connection
  • Use TNSPING to test Oracle Net connectivity

      13. Create indexes and views 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
  • Discuss New features concept 11g

     15. Oracle Backup & Recovery (User Managed)

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

 

  1. . Oracle Backup & Recovery (System  Managed: RMAN)
  • Introduction
  • RMAN Architecture & Rman commands
  • 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
  • RMAN 11g new features
  1. Cloning & Refresh
  • Database Refresh Using RMAN
  • Database refresh Using Manual
  • DB refresh Using Expdp and Empdp
  • Migration Using Expdp and Impdp
  • Migration Using Rman

 

  1. . Flashback Database Concept
  • Introduction
  • Configuration
  • Flashback Query/Table/Drop/Database
  • Flashback Version Query
  • Creating Restore Points
  • Flashback Archive(11g)

 

  1. . Patching Activity
  • Database Patch Management Introduction
  • Applying Interim and Patch set Patches
  • Patch History & Documentation

 

  1. . Data Guard Concept
  • Introduction
  • Architecture
  • Configuring Standby database
  • Types of Standby databases
  • Performing Switch Over and Fail Over
  • Monitoring & Troubleshooting
  • 11g New features in Data Guard
  • Types of Protection modes
  • Active standby/snapshot standby(11g)

 

  1. Automatic Storage Management

 

  • Oracle installation process
  • Patching Activity
  • Upgradation Process
  • Migration Process
  • Rman Refresh & cloning Process
  • Resume Preparation
  • Dataguard scenario
  • Project related scenario.
  • Real time scenario.