Oracle 12c: New Features for DBA

Required Prerequisites:

Oracle Database: Introduction to SQL
Good knowledge of Oracle Database Administrator 11g

Basics of Multitenant Container Database (CDB)

• Benefits of the multitenant architecture
• Differences between the root container and pluggable database containers
• Structure of the root
• Structure of Pluggable Database (PDB)
• CDB_xxx and DBA_xxx views
• Configuring and Creating CDB and PDBs
• Tools: DBCA and SQL*Plus

Configuration and creation of CDB

• Exploring the Structure (CDB_xxx views and EM)
• Tools used: DBCA and SQL*Plus and EM Database Express
• Create a new PDB from PDB$SEED
• Create a PDB from a non-CDB
• Plug in an unplugged PDB

Managing CDB and PDBs

• Connect to CDB as administrator
• Connect to a PDB using a service name
• Start up a CDB
• Open / Close a PDB (SQL*Plus)
• Open / Close all PDBs
• Shut down a CDB
• Change PDB state

Managing Tablespaces, Common and Local Users, Privileges and Roles

• Create permanent tablespaces in the root and PDBs
• Manage common and local schemas and users in the root and PDBs
• Manage system and object privileges to common and local grantees granted "commonly" or "locally"
• Manage common and local roles granted "commonly" or "locally"

Managing Backup / Recovery / Flashback

• Backup a whole CDB
• Backup a PDB
• Recover CDB from redo log files, control files, undo datafiles loss
• Recover PDB from PDB datafiles loss
• Flashback at CDB level

Online Datafile Move and Automatic Data Optimization

• Automatic movement and compression
• Compression levels and types
• Policy declaration: simple declarative SQL extension
• Customized automated action execution with user-defined function
• Customized schedule with DBMS_ILM package

In-Database Archiving

• Challenges of old data in tables and 11g solutions
• In-database archiving new solutions
• Use ROW ARCHIVAL clause to enable row lifecycle state for applications
• Set ROW ARCHIVAL VISIBILITY for session level visibility control
• Use predicate on ORA_ARCHIVE_STATE column
• Temporal Validity versus Temporal History (Transaction Time of FDA)
• New clause of CREATE / ALTER TABLE to set a Temporal Validity: PERIOD FOR
• New SQL temporal data type

Auditing Enhancements

• Review of 11g R2 audit trail implementation
• Overview of the Unified Audit Trail
• Enabling the Unified Audit Trail
• Creating a separate tablespace for the unified audit trail
• Granting the AUDIT_ADMIN role to a user for audit trail configuration and management
• Configuring the Unified Audit Trail to set a tolerance level for loss of audit records
• Creating audit policies

Privileges Enhancements

• Implementing Separation of Duty for Database Administration Tasks
• Using Database Privilege Analysis
• Overview of Database Privilege Analysis
• Granting the CAPTURE_ADMIN role to enable management of privilege captures
• Creating and starting/stopping privilege captures
• Viewing privilege profile data
• Querying DBA_PRIV_CAPTURES
• Explaining the purpose of the default ORA$DEPENDENCY profile

Oracle Data Redaction

• Overview of Oracle Data Redaction
• Types of Masking Policies
• Administering the EXEMPT REDACTION POLICY system privilege to enable a user to view unmasked values
• Managing Masking Policies
• Best practices for defining policy expressions
• Understanding Masking of Statements Containing Subqueries
• Viewing Information About Masking Policies by Querying REDACTION_POLICIES and
• REDACTION_COLUMNS

General RMAN New Features and FDA Enhancements

• Making Database Connections With RMAN
• Using the SYSBACKUP Privilege
• Using SQL, DESCRIBE Command, Duplication Operation with the NOOPEN option
• Backing up and Restoring Very Large Files
• Creating Multisection Backups
• Table Level Recovery
• Duplication of Database.

ADR and Network Enhancements

• ADR file types
• New File types
• New File locations
• New command for ADRCI

Resource Manager and Other Performance Enhancements

• Manage resources between PDBs
• Manage resources within a PDB
• Manage resources with CDB and PDBs plans
• Automated maintenance tasks
• Current Architecture: Unixmultiprocess / one thread, NT/Windows one process / multithread
• New Architecture: Multiprocess / MultiThread

Index and Table Enhancements

• Multiple indexes on the same set of columns as long as some characteristic is different
• Create table with INVISIBLE columns
• Support for invisible columns
• Describe online redefinition supports
• Describe the Advanced Row Compression
• Using the following DDL statements in an online manner