ORACLE 12c DBA
COURSE CONTENT
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