oracle dba course content

Oracle 11gR2, 12cR2 & 13cR1 DBA Course Contents
Course Contents
1) LINUX Administration for Oracle DBA

2) SQL for Oracle DBA

3) OPERATING SYSTEM INSTALLATIONS0
Oracle Enterprise Linux 5.5 and 6 Installations (Text Mode and Graphical Mode)
Oracle Enterprise Linux 5.5 and 6 Installations (Text Mode and Graphical Mode)

4) ORACLE Database Creations
Oracle Manual database creation for 11g R2 and 12c
Oracle Database Creation Using Basic Installation Method for 11g R2 and 12c
Oracle Advanced Database Creation for 11g R2 and 12c
Oracle Database Creation using Database Configuration Assistant (DBCA)

5) Oracle Database 11g R2 and 12c Architecture.
Oracle Logical Storage Structures
Oracle Logical Database Structures.
Oracle Physical Storage Structures.
Oracle Instance Architecture
Shared and Dedicated Server processes
Oracle Memory Structures
Database Buffer Cache
Redolog Buffer Cache
Shared Pool
Large Pool
Java Pool
Streams Pool
Background Processes

6) Controlling the Database
Creating and Configuring a listener.ora and tnsnames.ora file
For Manual Installations as well as advanced and DBCA installations.
Starting and Stopping ISQL* Plus
Starting and Stopping Database Control
Changing the Listener Status
Startup and Shutdown
Starting Up a Database NOMOUNT
Starting Up a Database MOUNT
Starting Up a Database OPEN
Shutting down the database.
SHUTDOWN OPTIONS like Shutdown Normal, Shutdown Transactional, Shutdown Immediate and Shutdown Abort

7) TableSpace Management
Tablespaces and Data Files
Space Management in Tablespaces
Creating a New Tablespace
Storage for Locally Managed Tablespaces
Altering a Tablespace
Actions with Tablespaces
Dropping Tablespaces
Viewing Tablespace Information
How to find the database size
How to find used database size
How to find free database size
How to find the table size

8) Control files management
Multiplexing Control files
How to recreate a controlfiles from the trace file.
How to take backup of a controlfile
How to restore a controlfile

9) Redologfile Management
How to multiplex redo log files.
Creating Redo log groups
How to drop redo log groups
Adding Redolog Members to a Redolog Group
Dropping a Redolog Member from a Group

10) Archivelog files management
How to configure flash_recovery_area for manual database installations.
How to configure flash_recovery_area size for manual database installations
How to configure flash_recovery_area and flash_recovery_area size for basic, advanced and dbca installations.
How to enable Archivelogmode
How to change database mode from noarchivelog mode to Archivelogmode

11) Pfile and spfile
Pfile
Spfile
Advantage and Disadvantages of pfile and spfile
Creating spfile from pfile
Creating pfile from spfile
Creating pfile

12) Security
Users and Resource Control
Creating New Users
Modifying User Settings with the ALTER USER Statement
Removing Users
Introduction to Profiles
Creating Profiles
Managing Passwords
Controlling Resource Usage
Dropping a Profile
Changing User, Profile, Password, and Resource Data
System and Object Privileges
Identifying System Privileges
Using Object Privileges
Managing System and Object Privileges
Granting and Revoking System Privileges
Granting and Revoking Object Privileges
Database Roles
How to Use Roles
Using Predefined Roles
Creating and Modifying Roles
Creating and Assigning Privileges to a Role
Assigning Roles to Users and to Other Roles
Limiting Availability and Removing Roles
Roles in the Enterprise Manager Console
Quotas
Assigning Quota to User
Altering Quota to a User
Assigning Unlimited Quota to a User
Removing Entire Quota from a User
Assigning Permanent and Temporary Tablespaces to a User

13) Oracle Net Services
Creating and configure a listener in client server environment
Starting the Listener Server Process
Stopping a listener process
Oracle Networking and Database Connectivity
Establishing Oracle Connectivity
Listener Control Utility
Monitoring with Listener Control
Local Naming
Testing Oracle Net Connectivity
Linux Server to Linux Server Communication (DBA)
Windows to Linux Server Communication (DBA) using putty
Windows 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)
14) Flashback Technologies
Flashback Drop (Uses Recycle bin feature)
Flashback Table (Uses undo data)
Flashback Version Query (Uses undo data)
Flashback Database (Uses flashback log/flash recovery area)
15) Logical Backups
Logical backups using exp/imp
Full Logical Backups, User Level Backups and Table level backups
Logical backups
The Data Pump Export/Import Process
Using Data Pump Export and Import
Creating a Directory
Data Pump Export Options
Starting a Data Pump Export job
Data Pump Import Options
Starting a Data Pump Import Job
Comparing Data Pump Export/Import to Export/Import
Logical Incremental backups using exp and imp
Logical Incremental backups using data pump technologies i.e expdp and impdp

16) Physical Backups
Cold Backups or Offline backups or Closed Backups
How to take cold backups for non-production environments like DEV, TST and STAGING
Hot backups or Online Backups or Open Backups
How to take Hot Backups for Production environments.

17) RMAN Backups and Recovery (Physical Backups)
RMAN Features and Components
RMAN vs. Traditional Backup Methods
Backup Types
RMAN commands and Options
Configuring the RMAN Environment
Setting up a Repository
Registering a Database
Controlfile Autobackup
Backup Operations
Full Database Backups
Tablespace
Datafiles
Control File, SPFILE Backup
Archived Redo Logs
Incrementally Updated Backups
Backup Compression
Validating Backups
Using the Recovery Catalog
Making Backups with RMAN
Maintaining RMAN Backups and the Repository
Scripting RMAN
Restoring a Control File
Restoring a Tablespace
Restoring a Datafile
Restoring an Entire Database
Validating Restore Operations
Restore Preview
Restore Validate
Point in Time Recovery
REPORT and LIST
Performing Complete Recovery
Performing Incomplete Recovery
Performing Flashback Recovery
Handling Online Redo Log Failures
Tuning RMAN
Troubleshooting RMAN
Performing Backup and Recovery with Enterprise Manager (OEM)

18) Database Cloning
Online Cloning for the Production Servers
Offline Cloning for the Non-Production Servers.

19) 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
20) Upgrading to Oracle Database 11g
Manual Upgradation
21) 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
How to Apply Patches to the Database

22) Database Tuning
Both Text based as well as OEM based
Monitoring the Database Aspects
Tuning the Database Areas
Monitoring using the ADDM (Automatic Database Diagnostic Monitor)
Running ADDM using OEM
Running ADDM using Command prompt
Using the UTLBSTAT.SQL and UTLESTAT.SQL files
Implementing the OEM-Tuning Pack
Using SQL Tuning Advisor
Running SQL Access Advisor
Managing AWR (Automatic Workload Repository)
Accessing AWR through OEM
Managing AWR using DBMS_WORKLOAD_REPOSITORY package
Using OEM to View AWR Report

23) Automatic Storage Management (ASM)
Introduction to Automatic Storage Management (ASM)
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

24) Database Refreshes
Refreshing Data from Production Server to the Development and Testing Servers

25) Managing Large Databases
Bigfile Tablespace Basics
Creating and Modifying Bigfile Tablespaces
Managing Oracle Application Databases
Managing Oracle-PeopleSoft Databases
Managing SAP Databases
Managing SOA Applications Database

26) Database Server Troubleshooting.
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

27) Miscellaneous
Uninstalling Oracle Software
Dropping Databases using Drop database command
Dropping database using DBCA

28) Oracle Background Processes
System Monitor (SMON)
Process Monitor (PMON)
Database Write (DBWR)
Archiver (arch)
Recover (reco)
Managed Recovery Process (MRP)
Check Point (CKPT) and so on