Core DBA 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
· 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