Online Oracle Database 11gR2 Training Course Content


What is 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.

Installing Oracle Database Software

  • Designing a relational database using Entity-Relationship Modeling.
  • Understand pre-requisites for a successful Oracle RDBMS software installation.
  • Installation of Oracle 11gR2 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.
  • In detail explanation about Oracle Database File System
  • Oracle database memory and process architecture.
  • In detail explanation about System Global Area and its components
  • In detail explanation about Oracle Background Processes
  • In detail explanation about How Database Works when its processing data

SPFile/PFile Management

  • What Is a Server Parameter File?
  • Migrating to a Server Parameter File
  • Creating a Server Parameter File
  • Storing the Server Parameter File on HARD-Enabled Storage
  • The SPFILE Initialization Parameter
  • Changing Initialization Parameter Values
  • Clearing Initialization Parameter Values
  • Exporting the Server Parameter File
  • Backing Up the Server Parameter File
  • Recovering a Lost or Damaged Server Parameter File
  • Viewing Parameter Settings

Control File Management

  • What Is a Control File?
  • Guidelines for Control Files
  • Creating Control Files
  • Troubleshooting After Creating Control Files
  • Backing Up Control Files
  • Recovering a Control File Using a Current Copy
  • Dropping Control Files
  • Displaying Control File Information

Online Redo-Log Management 

  • What Is the Redo Log?
  • Planning the Redo Log
  • Creating Redo Log Groups and Members
  • Relocating and Renaming Redo Log Members
  • Dropping Redo Log Groups and Members
  • Forcing Log Switches
  • Verifying Blocks in Redo Log Files
  • Clearing a Redo Log File
  • Viewing Redo Log Information
  • Resizing Online RedoLogs

Undo Management

  • What Is Undo?
  • Introduction to Automatic Undo Management
  • Setting the Minimum Undo Retention Period
  • Sizing a Fixed-Size Undo Tablespace
  • Managing Undo Tablespaces
  • Migrating to Automatic Undo Management
  • Undo Space Data Dictionary Views

Archivelog Management

  • What Is the Archived Redo Log?
  • Choosing Between NOARCHIVELOG and ARCHIVELOG Mode
  • Controlling Archiving
  • Specifying Archive Destinations
  • About Log Transmission Modes
  • Managing Archive Destination Failure
  • Controlling Trace Output Generated by the Archivelog Process
  • Viewing Information About the Archived Redo Log

Database Storage

  • Tablespaces and allocation types
  • Create tablespaces.
  • Create datafiles with fixed size and autoextend option.
  • Control files and producing a trace output to view its contents.
  • How to rename datafiles in a controlfile.
  • 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).
  • How to schedule Oracle database jobs using DBMS_SCHEDULER package.

Oracle DataPump

  • What Is Data Pump Import?
  • Invoking Data Pump Import
  • Parameters Available in Import’s Command-Line Mode
  • Commands Available in Import’s Interactive-Command Mode
  • Examples of Using Data Pump Import

User 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 Patches

  •  Introduction to Oracle versions and how to understand a version.
  • What are one-off/interim patches.
  • Learn about Oracle Interim Patch Installer (OPATCH).

Cloning Oracle Database

  • Overview of Cloning Methods
  • Cloning an Oracle Database Using Recovery Manager (RMAN) Backup
  • Cloning an Oracle Database Using Staging Areas
  • Cloning an Oracle Database Using an Existing Backup