Oracle DBA Training

Duration: 50 Hours

1. Introduction to Oracle Database Administrator

• Oracle Database 12c New and Enhanced Features
• Objectives 
• Challenges 
• Oracle Database in 11g Release 
• High Performance Systems

2. Basics of Multi Container Database and Pluggable Databases

• New Multitenant Architecture: Benefits 
• Other Benefits of Multitenant Architecture 
• Multitenant Container Database
• Separating SYSTEM and User Data
• Naming the Containers
• Provisioning a Pluggable Database
• Basics of Multitenant Container Database and Pluggable Databases
• Interacting Within Multitenant Container Database
• Exploring CDB Architecture and Structures

3. Creating a Multi Container Database and Pluggable Databases

• Steps to Create a Multitenant Container Database
• Creating a Multitenant Container Database Using SQL*Plus 
• Exploring CDB and PDB Structures
• Create New PDB from PDB$SEED
• With FILE_NAME_CONVERT
• Without FILE_NAME_CONVERT
• Cloning PDB within the Same CDB
• Plugging a Non-CDB into a CDB
• Dropping a PDB (optional)
• Plug Unplugged PDB in to CDB

4. Managing Multi Container Databases and Pluggable Databases

• Starting Up a CDB Instance 
• Mounting a CDB 
• Opening a CDB 
• Opening a PDB 
• Closing a PDB 
• Shutting Down a CDB Instance 
• Creating after Startup Trigger to Open All PDBs
• Changing PDB Mode 
• Changing PDB Mode with SQL Developer 
• Instance Parameter Changes and its Impact on PDBs

5. Managing Tablespaces and Users in CDB and PDBs

• Creating Permanent Tablespaces in a CDB
• Assigning Default Tablespaces 
• Creating Local Temporary Tablespaces
• Assigning Default Temporary Tablespaces 
• Users, Roles, and Privileges 
• Local Users, Roles, and Privileges 
• Creating a Local User 
• Common Users 
• Creating a Common User 
• Common and Local Schemas / Users
• Common and Local Privileges 
• Granting and Revoking Privileges 
• Creating Common and Local Roles 
• Granting Common or Local Privileges / Roles to Roles
• Granting Common and Local Roles to Users
• Granting and Revoking Roles 
• Creating Shared and Non-Shared Objects

6. Backup, Recovery, Flashback CDB and PDBs

• Whole CDB Backup 
• User-Managed Hot CDB Backup 
• Partial CDB Backup 
• Whole PDB Backup 
• Partial PDB Backup 
• SQL PDB Hot Backup (optional)
• SQL Control File Backup (optional)

    Activities

• Media Failure: CDB or PDB Temp File Recovery
• Media Failure: PDB Temp File Recovery 
• Media Failure: Control File Loss 
• Media Failure: Redo Log File Loss
• Media Failure: Root SYSTEM or UNDO Data File
• Media Failure: Root SYSAUX Data File
• Media Failure: PDB SYSTEM Data File 
• Media Failure: PDB Non-SYSTEM Data File 
• Media Failure: PITR

Flashback CDB
Special Situations
Creating a control file backup script

7. Heat Map, Automatic Data Optimization and Online Datafile Move

• Enabling Heat Map.
• Automatic Data Optimization – Creating a TIER Policy
• Automatic Data Optimization – Creating a COMPRESS Policy
• Cleanup ADO Policies and Heat Map Statistics
• Moving Data File Online
• In-Database Archiving and Temporal Validity
• Archiving Challenges
• Archiving Solutions 
• In-Database Archiving: HCC 
• Archiving Challenges and Solutions 
• In-Database Archiving 
• ORA_ARCHIVE_STATE column 
• Session Visibility Control 
• Disable Row-Archival 
• PERIOD FOR Clause Concept 
• Filtering on Valid-Time Columns

8. Auditing

• Types of Auditing 
• Audit Trail Implementation 
• Oracle Database 12c Auditing 
• Enabling Unified Auditing
• Auditing Data Pump Export
• Auditing RMAN Backups
• Unified Audit Implementation 
• Security Roles 
• Security SYS Auditing 9-21
• Simplicity Audit Policy 9-22
• Creating the Audit Policy 
• Creating the Audit Policy with Object-Specific Actions
• DBMS_FLASHBACK_ARCHIVE

9. Privileges

• New Administrative Privileges 
• New Administrative Privilege SYSBACKUP 
• New Administrative Privilege SYSDG 
• New Administrative Privilege SYSKM 
• OS Authentication and OS Groups 
• Password Authentication for SYSBACKUP 
• Password Authentication for SYSDG 
• New System Privilege PURGE DBA_RECYCLEBIN 10-19
• Creating Policies Database and Role Analysis
• Creating Policies Context Analysis 
• Analyzing and Reporting 
• SYSTEM and OBJECT Used Privileges 
• Used Privileges Results 
• Compare Used and Unused Privileges

10. Oracle Data Pump, SQL*Loader, and External Tables

• Full Transportable Export/Import Overview 
• Full Transportable Export/Import Usage 
• Full Transportable Export/Import Example 
• Plugging a Non-CDB into CDB Using Data Pump 
• Plugging a Non-CDB into CDB Using Replication
• Transporting a Database over the Network Example 
• Disabling Logging for Oracle Data Pump Import Overview 
• Disabling Logging for Oracle Data Pump Import Usage 
• Disabling Logging for Oracle Data Pump Import Command-Line Examples 
• Exporting Views as Tables Overview 
• Exporting Views as Tables Usage 
• Exporting Views as Tables Command-Line Examples 
• Specifying the Encryption Password 
• Compressing Tables during Import 
• SQL*Loader and External Table Enhancements

11. Recovery Manager New Features

• Backing Up and Restoring Very Large Files 
• RMAN Duplication Enhancements 
• Duplicating an Active Database 
• What Is New? 
• The NOOPEN Option 
• Duplicating Pluggable Databases 
• Recovering Databases with Third-Party Snapshots 
• Transporting Data across Platforms 
• Data Transport 
• Transporting Database Process Steps 
• Transporting Tablespace Process Steps 
• Table Recovery 
• Recovering Tables from Backups 
• Specifying the Recovery Point-in-Time 
• Process Steps of Table Recovery

Duration: 25 Hours

Oracle Database Architecture

• Oracle Database Architecture Overview
• Oracle ASM Architecture Overview
• Process Architecture
• Memory structures
• Logical and physical storage structures
• Architecture 2 
• Architecture 3 

Installing your Oracle 19c Software

• Tasks of an Oracle Database Administrator
• Tools Used to Administer an Oracle Database
• Installation: System Requirements
• Oracle Universal Installer (OUI)
• Installing Oracle Database Software on Linux 7

Creating an Oracle Database

• Planning the Database
• Create Manual database
• Using the DBCA to Create a Database
• Password Management
• Using the DBCA to Delete a Database

Managing the Oracle Instance

• Start and stop the Oracle database and components
• Access a database with SQLPlus
• Modify database installation parameters
• Describe the stages of database startup
• Describe database shutdown options
• View the alert log
• Access dynamic performance views

Managing Database Storage Structures(TABLESPACE MANAGEMENT)

• Storage Structures
• How Table Data Is Stored
• Anatomy of a Database Block
• Space Management in Tablespaces
• Tablespaces in the Preconfigured Database
• Actions with Tablespaces
• Oracle Managed Files (OMF)
• spfile and pfile management

Administering User Security

• Database User Accounts
• Predefined Administrative Accounts
• Benefits of Roles
• Predefined Roles
• Implementing Profiles

Managing Undo Data

• Data Manipulation
• Transactions and Undo Data
• Undo Data Versus Redo Data
• Configuring Undo Retention

Flashback

• Flashback query,  Flashback version query
• Flashback transaction query, Flashback drop table

Oracle Networking

• create and configure the Listener
• Use tnsping to test Oracle Net connectivity
• database links and materialized views

Controlfile and redologfile management 

• Controlfile multiplexing 
• DB renaming
• Redolog file multiplexing 
• Archivelog mode and NO Archivelog mode 

Backups 

• Logical backup ----  Exp, Expdp(datapump) 
• Physical backup ----- Cold and hot backup 
• Rman 

RMAN Topics

• Backup Strategies
• RMAN Architecture
• RMAN backup components
• RMAN catalog and configuration
• RMAN Commands
• Monitoring RMAN backups
• Restoring and recovering using RMAN
• Database cloning using RMAN
• Best practices

Performing Database Backups using RMAN

• Backup Solutions: Overview
• Oracle Secure Backup
• User-Managed Backup
• Terminology
• Recovery Manager (RMAN)
• Configuring Backup Settings
• Backing Up the Control File to a Trace File
• Opening a Database
• Data Recovery Advisor
• Loss of a Control File
• Loss of a Redo Log File
• Data Failures
• Listing Data Failures

Using the RMAN Recovery Catalog

• Identify situations that require RMAN recovery catalog
  
• Create and configure a recovery catalog
  
• Synchronize the recovery catalog
  
• Create and Use RMAN stored scripts --- local, global scripts
  
• Back up the recovery catalog
  
• Create and use a virtual private catalog
  

Configuring Backup Specifications

• Configure backup settings
• Allocate channels to use in backing up
• Configure backup optimization

Using RMAN to Create Backups

• Create image file backups
• Create a whole database backup
• Enable fast incremental backup
• Create duplex backup and back up backup sets
• Create an archival backup for long-term retention
• Create a multisection, compressed and encrypted backup

Performing User-Managed Backup and Recovery

• Recover from a lost TEMP file and redo log group
• Recover from the loss of password file
• Perform user-managed complete and incomplete  database recovery
• Perform user-managed and server managed backups
• Identify the need of backup mode
• Back up and recover a control file

Using RMAN to Perform Recovery

• Perform complete recovery from a critical or noncritical data file loss using RMAN
• Perform incomplete recovery using RMAN
• Recover using incrementally updated backups
• Switch to image copies for fast recovery
• Restore a database onto a new host
• Recover using a backup control file
• Using RMAN to Duplicate a Database
• Creating a duplicate database
• Using a duplicate database

RMAN

• Block change tracking
• Incremental,complete, cumulative backup
• Virtual private catalog 
• Tablespace point in time recovery
• Table level recovery
• Flashback database, Flashback data archive

Implementing Oracle Database Auditing

• Describe DBA responsibilities for security
• Enable standard database auditing
• Specify audit options
• Unified auditing
• Review audit information
• Maintain the audit trail
• Manage optimizer statistics
• Manage the Automatic Workload Repository (AWR)
• Use the Automatic Database Diagnostic Monitor (ADDM)
• Describe and use the advisory framework
• Use server-generated alerts
• Use automated tasks

Performance Management

• Performance Monitoring
• Managing Memory Components
• Enabling Automatic Memory Management (AMM)
• Automatic Shared Memory Advisor
• Using Memory Advisors
• Dynamic Performance Statistics
• Troubleshooting and Tuning Views
• Invalid and Unusable Objects

Manage the ASM Instance

• Set up initialization parameter files for ASM instance
• Start up and shut down ASM instances
• Administer ASM disk groups

ASM TOPICS

• Database Architecture and ASM
• Describe Automatic Storage Management (ASM)
• Set up initialization parameter files for ASM and database instances
• Start up and shut down ASM instances
• Administer ASM disk groups
• Storage Fundamentals
• ASM Concepts
• Preparing ASM Storage
• ASM Instance setup
• ASM diskgroupsFailure groups (Redundancy)
• Managing Diskgroups
• Backing up Diskgroups
• Monitoring Diskgroups
• Creating Database on ASM
• Managing Database on ASM
• Basic architecture
• Storage concepts

Multitenent Database architecture

• Creating container databases(CDB) using DBCA
• Creating pluggable databases(PDB)
• Managing pluggable databases
• Start and stop of pluggable databases
• Export and import of PDBS
• Cloning methods of PDB databases

Data guard/Standby database/DR site

• Configuring Standby database
• Changing protection modes
• Switchover ,  failover

Upgrade database from 12c  to 19c 

• Upgrade 12c db to 19c  using dbua 
• Upgrade 12c db to 19c  using manual scripts

We offer Oracle 12c and Oracle 19c as two different courses with different prices. And, you can register for a customized curriculum covering both versions at a special discounted price. For further information about the course, please drop us an enquiry, and our Course Advisor will assist you in making your learning hassle-free.

Mindmajix offers advanced Oracle DBA interview questions and answers along with Oracle DBA resume samples. Take a free sample practice test before appearing in the certification to improve your chances of scoring high.