Exploring the 12c Oracle Database Architecture
• List the major architectural components of Oracle Database
• Explain the memory structures
• Describe the background processes
• Understanding 12c multitenant architecture
• Exploring cdb and pdb databases

Installing 12c Oracle Database Software
• Describe database administrator (DBA) role, explain typical tasks and tools
• Plan an Oracle software installation
• Install 12c Database software
Creating an Multitenant Oracle Database
• Plan database creation
• Create Multitenant Container and pluggable Databases
• Create database using SQL Plus
• Understand database users & sample schemas

Managing the Database Instance
• Managing database using Oracle Enterprise Manager & SQL*Plus
• Commonly used Intialization Parameters
• Manage database initialization parameters – SPFile & Pfile
• Describe the stages of database startup
• Start and stop the Oracle database and components
• Viewing Alert log & manage Trace files
• Understand Data Dictionary Views
• Access dynamic performance views

Managing Database Storage Structures
• Storage Structures
• Segments, Extents & Oracle block
• Describe the storage of table row data in blocks
• Create and manage Tablespaces
• Tablespaces and Datafiles
• Managing Tablespaces in CDBs and PDBs
• Oracle Managed Files (OMF)
• Managing Temporary Tablespace

Administering User Security
• Create and manage database user accounts:
– Authenticate users
– Assign default storage areas (tablespaces)
• Grant and revoke privileges
• Create and manage roles
• Create and manage profiles

Managing Data Concurrency
• Describe locking mechanism and how Oracle manages data concurrency
• Monitor and resolve locking conflicts

Managing Undo Data
• Explain DML and undo data generation
• Monitor and administer undo data
• Difference between undo data and redo data
• Configure undo retention
• Guarantee undo retention
• Use the Undo Advisor

Configuring the Oracle Network Environment
• Oracle Net Services
• Configure Listener & Create Oracle Net Service aliases
• Configure connect-time failover
• Control the Oracle Net Listener
• Use tnsping to test Oracle Net connectivity
• Identify when to use shared servers and when to use dedicated servers
• Configuring Communication between Databases
• Connecting to another Database using DB Links

Backup and Recovery Concepts
• Identify the types of failure that can occur in an Oracle database
• Importance of checkpoints, redolog files, control files & archive log files
• Understanding what is COLD & HOT backup
• Configure ARCHIVELOG mode & Fast Recovery Area
• Invoke and configure Recovery Manager (RMAN)
• Specify Retention policy

Use of RMAN Recovery Catalog & Configuring Backup Settings
• Usage of a Recovery Catalog over control file for the RMAN repository
• Create and configure a recovery catalog
• Register Database & Synchronize with recovery catalog
• Use RMAN stored scripts
• Enable control file autobackup
• Configure backup destinations
• Allocate channels for Disk & Tape destinations
• Configure backup optimization
• Create compressed & encrypted backups

Performing Database Backups with RMAN
• Create consistent database backups (offline / cold)
• Back up your database without shutting down (online / hot)
• Create image file backups
• Create a whole database backup
• Create a full database backup
• Enable fast incremental backup
• Create duplex backup sets
• Back up a backup set
• Create RMAN multi-section backup
• Create an archival backup for long-term retention
• Monitor Backup jobs, Manage backups and view backup reports
• Monitor the fast recovery area

Performing Database Recovery
• Determine the need for performing recovery
• Describe the causes of file loss and determine the appropriate action
• Describe major recovery operations
• Perform recovery:
– Control file
– Redo log file
– Data file
• Perform complete recovery when a critical or noncritical data file is lost
• Recover using incrementally updated backups
• Switch to image copies for fast recovery
• Recover using a backup control file

Moving Data
• Describe ways to move data
• Create and use directory objects
• Use SQL*Loader to load data from a non-Oracle database (or user files)
• Use external tables to move data via platform-independent files
• Explain the general architecture of Oracle Data Pump
• Use Data Pump Export and Import to move data between Oracle databases

Using Flashback Technology I
• Describe Flashback technology
• Perform Flashback Query
• Use Flashback Version Query
• Perform Flashback Table operations
• Use Flashback Transaction Query

Using Flashback Technology II
• Describe and use Oracle Total Recall
– Creating and Managing Flashback Data Archive (FDA)
• Describe and use flashback recycle bins
• Configure Flashback Database
• Perform Flashback Database operations
• Monitor Flashback Database

Implementing Oracle Database Auditing
• Describe DBA responsibilities for security and auditing
• Enable standard database auditing
• Specify audit options
• Review audit information
• Maintain the audit trail

Database Maintenance
• Optimizer overview
• Manage optimizer statistics
• Manage the Automatic Workload Repository (AWR)
• Use the Automatic Database Diagnostic Monitor (ADDM)
• Describe and use the advisory framework
• Accessing & analyzing Active Session History data

Performance Management
• Use performance-related dynamic view & EM to monitor performance
• Managing Memory:
– Describe the memory components in the SGA
– Implement Automatic Memory Management
– Manually configure SGA parameters
– Configure automatic PGA memory management
• Maintaining different types of Indexes
• Managing Partition Tables

Managing Performance by SQL Tuning
• SQL Tuning
• Row chaining & migration
• SQL trace, Tkprof, Explain plan
• Use the SQL Tuning Advisor to:
– Identify SQL statements that are using the most resources
– Tune SQL statements that are using the most resources
• Use the SQL Access Advisor to tune a workload

Diagnosing the Database
• Detect and repair database corruption
• Handle block corruption
• Set up Automatic Diagnostic Repository (ADR) & Run health checks

Managing Space
• Describe how the Oracle database server automatically manages space
• Save space by using compression
• Proactively monitor and manage tablespace space usage
• Describe segment creation in the Oracle database
• Control deferred segment creation
• Use the Segment Advisor
• Reclaim wasted space from tables and indexes by using segment shrink
• Manage resumable space allocation

Managing Space for the Database
• Use transportable tablespaces
• Describe the concepts of transportable databases

Managing the ASM Instance
• Describe the benefits of using ASM
• Manage the ASM instance
• Create and drop ASM disk groups
• Extend ASM disk groups
• Retrieve ASM metadata by using various utilities

Duplicating a Database / Cloning Database
• List the purposes of creating a duplicate database
• Choose a technique for duplicating a database
• Duplicate a database with RMAN

Data Guard
• Dataguard Architecture & background processes
• Configuring & Managing Dataguard
• Configuring Dataguard failover
• Managing switchover

Oracle 12c New Features
 Multitenant Container Database and Pluggable Databases
 Managing Tablespaces and Users in CDB and PDBs
 Backup, Recovery, and Flashback CDBs and PDBs
 Automatic Data Optimization and Storage Enhancements
 In-Database Archiving and Temporal
 Privilege Analysis new feature and new administrative privileges
 ADR and Network enhancements
 Oracle Data Redaction
 High Availability using RMAN
 Tables, Indexes, and Online Operations enhancements
 Major enhancements in Data Pump, SQL Loader & External tables