Course Content

CORE DBA

• Introduction to database management systems and databases
• What is a database?
• Popular database management system (DBMS) software and why Oracle DBMS.
• History and Current trends of DBMS and Database Administration.
• Oracle database market share and about its current competitive landscape.
• Tasks of a Database Administrator.
• Relational Database Model and Installing Oracle database software (11g R2)
• Designing a relational database using Entity-Relationship Modeling.
• Understand pre-requisites for a successful Oracle RDBMS software installation.
• Installation of Oracle 11g R2 database software.
• Installation of Oracle 12c database software (Latest Release).
• Oracle Database Architecture
• Planning for an Oracle database creation.
• Creating an Oracle database using the MANUAL method.
• Creating an Oracle database using the Graphical Tool (Database Configuration Assistant).
• Startup and Shutdown of a database.
• Components of an Oracle database and detailed architecture.
• Advance Startup and Shutdown Scenarios.
• Oracle database memory and process architecture.
• Oracle database job scheduler API
• Database storage
• Tablespaces and allocation types.
• Create tablespaces.
• Create data files with fixed size and autoextend option.
• Control files and producing a trace output to view its contents.
• How to rename datafiles in a control file.
• Redolog File architecture and best practices.
• Enabling Archivelog mode for a database with automatic archiving.

Temporary tablespaces and temporary tablespace groups (11g R2 new feature).

ORACLE NETWORKING

• Introduction.
• Oracle listener configuration (Dynamic and Static Listeners).
• Dynamic Service Registration and Naming Methods configuration in sqlnet.ora.
• Oracle database connections from other computers.
• Using Oracle netca (Network Configuration Assistant) for network configuration file tnsnames.ora.
• Oracle listener administration and TNS_ADMIN environment variable.
• Database Links.
• User Administration and Security
• How to create database users.
• How to set database profile limits for a user for efficient resource management.
• Unlocking a user account and enabling password management.
• Oracle database authorization using object and system privileges
• Oracle database authorization using database roles
• How to audit Oracle database connections in standard and XML mode.
• How to audit Oracle DBA commands (SYS Operations).
• Used Managed (Manual) Backup and Recovery
• Introduction and planning for a robust Backup and Recovery Strategy.
• How to take an Oracle database backup in offline mode (COLD BACKUP).
• Hot to take an Oracle database backup in online mode (HOT BACKUP).
• How to clone a database using Cold Backup.
• How to clone a database using Hot Backup.
• How to recreate source database from a user-managed backup (Media failure scenario) RMAN Backup and Recovery
• Advantages of RMAN method compared to manual method.
• Database backup using RMAN in normal and compressed mode.
• Oracle database backup metadata.
• Database backup using RMAN catalog.
• Querying the RMAN metadata.
• How to clone a database using RMAN duplicate (11g R2 new feature: Backup-based duplication).
• How to restore and recover a database using its backup in the event of a media failure.
• Oracle database backup retention policies and backups to Tape/offsite.
• Fast Recovery Area for better management of backups and archive log files.

ORACLE DATABASE UPGRADES

• Introduction to Oracle versions and how to understand a version.
• How to upgrade from a previous release to latest releases.
• How to upgrade from one patchset to another patchset within a release. What is slip-streaming?
• What are one-off/interim patches?
• Learn about Oracle Interim Patch Installer (OPATCH).
• Oracle Data Movement Utilities
• Oracle database logical backups.
• Business use cases of logical backups compared to physical backups.
• Data Pump Export modes.
• Data Pump Import to import data from an export backup.
• Advanced features in Oracle Data Pump Export.
• Oracle Database Performance Tuning
• How to handle performance issues in the real world.
• V$ views for performance monitoring and analysis.
• How to size the Oracle database memory structures for optimal performance.
• Oracle database wait events.
• Explain Oracle UNDO management internals and sizing.
• Explain Oracle TEMP space internals and sizing.
• SQL Query tracing using TKPROF.
• Database-wide tracing for Oracle Errors (Event Tracing).
• Index Monitoring and internals of index maintenance by Oracle.
• Statistics data collection for Oracle database optimizer.
• Real world life of an Oracle DBA
• Type of Oracle errors like Valid errors and internal exceptions (ORA-00600 and ORA-07445 errors).
• Monitoring Oracle databases.
• How to work with Oracle Support to create Service Requests.
• Parlance and terminology used by Oracle DBAs.
• Working with Oracle Forums for issues.
• Productivity tools required when you join the workplace.
• Scheduling JOBS and scripts through UNIX/LINUX crontab utility.
• Oracle Database High Availability (RAC, DataGaurd)
• Automatic Storage Management (ASM): Install and setup
• Introduction and benefits of Oracle ASM.
• Oracle ASM software installation and configuration (Grid Infrastructure)
• Partitioning Disks in LINUX.
• Oracle ASMLib Utility for managing ASM Disk Storage.
• Oracle ASMCA (ASM Configuration Assistant).
• ASM Parameter file, ASM Instance and working with DISKGROUPS.
• Querying ASM Information.
• Creating Database Files using ASM.
• Oracle Automatic Storage Management (ASM): Mirroring Disks
• Understanding ASM Disk Redundancy (Mirroring)
• Learn about the three levels of ASM redundancy
• How Oracle manages ASM Disk failures
• Replacing a failed disk with a new disk
• ASM Disk Rebalancing operations
• Oracle Real Application Clusters (RAC)
• Components of a RAC environment.
• Storage, network and hardware requirements.
• Pre-requisites for RAC installations.
• Installation and configuration of Clusterware.
• How to validate the configuration and install.
• The Grid and RAC installation.
• RAC Databases
• Creation of RAC database and instances.
• Differences in RAC database versus single instance.
• Database and instance parameters.
• How to change parameters.
• Connection information for high availability (TAF, FAN, and FCF).
• Single client access name (SCAN).
• Managing RAC Databases
• Database services and SRVCTL.
• Using restart utility.
• Adding and removing a node to the RAC environment.
• Backup of databases and parameter files.
• Rolling Patches of RAC environment grid and database.
• Testing and Monitoring RAC
• Clusterware testing.
• Failover testing and validations.
• Troubleshooting configuration and failures.
• GV$ views.
• Monitoring interconnects and performance.

ORACLE DATA GUARD

• Using standby databases in HA environments.
• Active Standby features.
• Decisions for syncing standby databases.
• Requirements for different sync options.
• Getting the requirements and parameters set for primary and standby databases.
• Create standby database.
• Managing Data Guard Environment
• Configuring Data Guard broker(DGMGRL).
• Validating the configuration.
• Commands for managing Data Guard environment.
• Failing over to standby.
• Recreating Primary.
• Monitoring syncing the standby.

OEM 12C CONFIGURATION

• Creating a repository Database for the OEM console.
• Installing the OEM 12C software
• Installing the software for the target agents for multiple flavors
• Adding and deploying the agents
• Identifying the targets
• Configuring the target to be monitored through OEM 12C console