Online Oracle 12c Administration Training Classes And Courses  BISP 

60% Complete Courses » Oracle 12c Administration
  • Course Content
  • Course Overview
  • Training Schedule
  • Demo Video
  • Learning Material
  • Register


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

Course Id:
ODT005 
Course Fees:
301 USD