Online Oracle DBA 11gR2 Training

Online Oracle Database 11gR2 Training will be conducted through Web Conference where we share our screen to audience and will show all the topics starting from installation till cloning practically,
which includes explanation of real-time scenarios and interview questions for each topic.

Oracle Database Administration (DBA) 11gR2 Training Course Content:

What is Oracle Database?

• Popular database management system (DBMS) software and why Oracle DBMS.
• History and Current trends of DBMS and Database Administration.
• Tasks of a Database Administrator.

Installing Oracle Database Software

• Understand pre-requisites for a successful Oracle RDBMS software installation.
• Installation of Oracle 11gR2 database software.
• Installation of Oracle 12cR1 database software (Latest Release).

Oracle Database Architecture

• Planning for an Oracle database creation.
• 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.
• 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
• The SPFILE Initialization Parameter
• Changing / Clearing Initialization Parameter Values
• Recovering a Lost or Damaged Server Parameter File
• Viewing Parameter Settings

Control File Management

• What Is a Control File?
• Creating Control Files
• Troubleshooting After Creating Control Files
• Backing Up Control Files
• Recovering a Control File Using a Current Copy
• 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.

Oracle Networking

• Introduction.
• Oracle listener configuration.
• 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).
• How 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

Questions

Duration:  4 Weeks – Daily 1 Hour/Weekend 2 Hours | One-to-One | Mail:  mbcdba@gmail.com

If you want to take this course please send mail to me or contact me.

Thanks,

Chowdari