DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad

Oracle 11g DBA Course Contents

a) LINUX Administration

b) Oracle SQL and PL/SQL

c) OPERATING SYSTEM INSTALLATIONS

Oracle Enterprise Linux 4 (OEL 4) Installations (Both Automatic and Manual using Graphic mode)Oracle Enterprise Linux 4 (OEL 4) Installations (Both Automatic and Manual using Text mode)

Oracle Enterprise Linux 5 (OEL 5) Installations (Both Automatic and Manual using Graphic mode)Oracle Enterprise Linux 5 (OEL 5) Installations (Both Automatic and Manual using Text mode)

d) ORACLE INSTALLATIONS

Oracle Manual database Installations on OEL 4 Oracle Basic Database Installations on OEL 4Oracle Advanced Database Installations on OEL 4Oracle Database Installations on OEL 4 by using Database Configuration Assistant (DBCA)

d) Oracle Database 11g Architecture.

DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad

Oracle Logical Storage StructuresOracle Logical Database Structures.Oracle Physical Storage Structures.Oracle Instance ArchitectureShared and Dedicated Server processesOracle Memory StructuresDatabase Buffer CacheRedolog Buffer CacheShared PoolLarge PoolJava PoolStreams PoolBackground Processes

e) Controlling the Database

Creating and Configuring a listener.ora and tnsnames.ora fileFor Manual Installations as well as advanced and DBCA installations.Starting and Stopping ISQL* PlusStarting and Stopping Database ControlChanging the Listener StatusStartup and ShutdownStarting Up a Database NOMOUNTStarting Up a Database MOUNTStarting Up a Database OPENShutting down the database.SHUTDOWN OPTIONS like Shutdown Normal, Shutdown Transactional, Shutdown Immediate and Shutdown Abort

g) TableSpace Management

DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad

Tablespaces and Data FilesSpace Management in TablespacesCreating a New TablespaceStorage for Locally Managed TablespacesAltering a TablespaceActions with TablespacesDropping TablespacesViewing Tablespace InformationHow to find the database sizeHow to find used database sizeHow to find free database sizeHow to find the table size

h) Control files managementMultiplexing Control filesHow to recreate a controlfiles from the trace file.How to take backup of a controlfileHow to restore a controlfile

I) Redologfile ManagementHow to multiplex redo log files.Creating Redo log groupsHow to drop redo log groups Adding Redolog Members to a Redolog GroupDropping a Redolog Member from a Group

j) Archivelog files management

How to configure flash_recovery_area for manual database installations.How to configure flash_recovery_area size for manual database installationsHow to configure flash_recovery_area and flash_recovery_area size for basic, advanced and dbca installations.How to enable ArchivelogmodeHow to change database mode from noarchivelog mode to Archivelogmode

k) Security

DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad

Users and Resource ControlCreating New UsersModifying User Settings with the ALTER USER StatementRemoving Users

Introduction to ProfilesCreating ProfilesManaging PasswordsControlling Resource UsageDropping a Profile

Changing User, Profile, Password, and Resource DataSystem and Object Privileges

Identifying System PrivilegesUsing Object Privileges

Managing System and Object PrivilegesGranting and Revoking System PrivilegesGranting and Revoking Object Privileges

Database RolesHow to Use RolesUsing Predefined Roles

Creating and Modifying RolesCreating and Assigning Privileges to a RoleAssigning Roles to Users and to Other RolesLimiting Availability and Removing Roles

Roles in the Enterprise Manager ConsoleQuotas

Assigning Quota to UserAltering Quota to a UserAssigning Unlimited Quota to a UserRemoving Entire Quota from a User

Assigning Permanent and Temporary Tablespaces to a User

l) Oracle Net Services

Creating and configure a listener in client server environmentStarting the Listener Server ProcessStopping a listener processOracle Networking and Database ConnectivityEstablishing Oracle Connectivity

DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad

Listener Control UtilityMonitoring with Listener ControlLocal Naming Testing Oracle Net ConnectivityLinux Server to Linux Server Communication (DBA)Windows to Linux Server Communication (DBA) using puttyWindows to Linux Server Communication by using tnsnames.ora file (DBA)Windows to Linux Server Communication by using Oracle 11g Client Software (Developer, Tester etc)Windows to Windows Server Communication using Remote Desktop (DBA)Windows to Windows Server communication using tnsnames.ora file (DBA)Windows Client to Windows Server Communication using Oracle 11g Client Software (Developer, Tester etc)

m) Flashback Technologies

Flashback Drop (Uses Recycle bin feature)

Flashback Table (Uses undo data)

Flashback Version Query (Uses undo data)

Flashback Transaction Query (Uses undo data)

Flashback Database (Uses flashback log/flash recovery area)

n) Logical Backups Logical backups using exp/impFull Logical Backups, User Level Backups and Table level backupsLogical backups

The Data Pump Export/Import ProcessUsing Data Pump Export and Import

Creating a DirectoryData Pump Export OptionsStarting a Data Pump Export job

Data Pump Import OptionsStarting a Data Pump Import JobComparing Data Pump Export/Import to Export/Import

Logical Incremental backups using exp and impLogical Incremental backups using data pump technologies i.e expdp and impdp

o) Physical Backups

DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad

Cold backups or offline backups or Closed backupsHow to take cold backups for non-production environments like DEV, TST and STAGINGHot backups or Online Backups or Open BackupsHow to take Hot Backups for Production environments.

p) RMAN Backups and Recovery (Physical Backups)

RMAN Features and ComponentsRMAN vs. Traditional Backup MethodsBackup TypesRMAN commands and OptionsConfiguring the RMAN EnvironmentSetting up a RepositoryRegistering a DatabaseControlfile Autobackup

Backup OperationsFull Database BackupsTablespaceDatafilesControl File, SPFILE BackupArchived Redo LogsIncrementally Updated BackupsBackup CompressionValidating Backups

Using the Recovery CatalogMaking Backups with RMANMaintaining RMAN Backups and the RepositoryScripting RMANRestoring a Control FileRestoring a TablespaceRestoring a DatafileRestoring an Entire DatabaseValidating Restore Operations

Restore PreviewRestore ValidatePoint in Time Recovery

DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad

REPORT and LISTPerforming Complete RecoveryPerforming Incomplete RecoveryPerforming Flashback RecoveryHandling Online Redo Log FailuresTuning RMANTroubleshooting RMANPerforming Backup and Recovery with Enterprise Manager (OEM)

s) Database Cloning

Online Cloning for the Production Servers

Offline Cloning for the Non-Production Servers.

t) Data Guard (Disaster and Recovery)

Introduction to Oracle Data Guard

Data Guard Architecture

Complete Implementation of Data Guard between Primary and Standby Servers

Preparing the Primary Database

Implementing Standby databases

Standby Database Administration

Log Management Services

Switchover and Failover

Data Guard Troubleshooting

u) Upgrading to Oracle Database 11g

Manual Upgradation

DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad

Upgradation using DBCA

V) Patch Management

What is a Patch?

How to apply CPU (critical patch updates) to the Database.

How to file SR (Service Requests) using

https://support.oracle.com

How to download Oracle patches from the Oracle Customer Connection

i.e httS://support.oracle.com

How to Apply Patches to the Database

w) Database Tuning

Both Text based as well as OEM basedMonitoring the Database AspectsTuning the Database AreasMonitoring using the ADDM (Automatic Database Diagnostic Monitor)Running ADDM using OEMRunning ADDM using Command promptUsing the UTLBSTAT.SQL and UTLESTAT.SQL filesImplementing the OEM-Tuning PackUsing SQL Tuning AdvisorRunning SQL Access AdvisorManaging AWR (Automatic Workload Repository)Accessing AWR through OEMManaging AWR using DBMS_WORKLOAD_REPOSITORY packageUsing OEM to View AWR Report

x) Automatic Storage Management (ASM)

Introduction to Automatic Storage Management (ASM)

DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad

How to implement RDBMS instance

How to implement ASM instance

How to maintain ASM Disks

Diskgroups and Failure Groups

ASM Command-Line

Managing Databases in ASM

ASM Operations

Typical ASM Diskgroup Commands

Troubleshooting ASM

y) Database Refreshes

z) Managing Large Databases

Bigfile Tablespace Basics

Creating and Modifying Bigfile Tablespaces

Bigfile Tablespace ROWID Format

DBMS-ROWID and Bigfile Tablespaces

Using DBVERIFY with Bigfile Tablespaces

Advanced Oracle Table Types

Index Organized Tables

Global Temporary Tables

External Tables

Partitioned Tables

z) Database Server Troubleshooting.

DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad

Listener Issues

Client Server issues

Data Guard Issues

RMAN issues

Performance and Tuning Troubleshooting Issues

Upgrade issues

Patch Management issues

Installation and Configuration issues

Online and Offline Cloning issues

Logical Backup and Physical backup issues

Flashback issues

Control file issues

Redolog file issues

Archive log file issues

Faculty: Satya Seelam

(10 Years DBA Exp in USA)

Visit: www.hyddbatraining.com

Phone: +91 9966293445 / +91 8142368899 / 040-30629114

Contact Us

DBA School (Software Training Institute)

Flat #501 & 502, Mahindra Residency,

Near Aditya Trade Center,

Ameerpet,

Hyderabad