Course Overview
During the Oracle Database 12c Administration Workshop, students cover a brief overview of the multitenant container database and its pluggable databases. This course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases. You learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged pluggable databases in multitenant container databases using various methods.
In addition, you learn how to create common and local users and administer database security to meet your business requirements by using encryption, Database Vault and auditing and you will learn how to create a database deployment in the Cloud.
- Understand the multitenant architecture.
- Create and manage a multitenant container database and pluggable databases.
- Understand regular and application pluggable databases.
- Manage storage within a multitenant container database and pluggable databases.
- Manage security within a multitenant container database and regular and application pluggable databases.
- Monitor performance and manage resources within a multitenant container database and pluggable databases.
- Perform backup, recover and flashback operations on a multitenant container database and regular and application pluggable databases.
- Perform particular operations like Oracle Data Pump transportation, loading, encrypting, auditing.
- Manage the CDB and PDBs in specific configurations like Data Guard, Database Vault.
Benefits To You
During the Oracle Database 12c Backup and Recovery Workshop, students get an overview of how to backup and recover pluggable databases. This course presents multitenant container database and pluggable databases backup, recovery and flashback procedures.
To provide an acceptable response time to users and manage resources effectively, you learn how to monitor performance and manage resources within the multitenant container database and its pluggable databases, and within each pluggable database.
Another important aspect is the data movement between non-CDBs and pluggable databases, and between pluggable databases.
It is also important to understand the procedures of upgrading an Oracle Database 12.1 multitenant container database to an Oracle Database 12.2 multitenant container database or an Oracle Database 12.1 pluggable database to an Oracle Database 12.2 pluggable database.
Finally, students discover the way multitenant container database and pluggable databases are created and monitored in the Cloud.
Who should attend
- Database Administrators
- Database Designers
- Support Engineer
- Technical Administrator
- Data Warehouse Administrator
Prerequisites
Required Prerequisites:
- Working knowledge of SQL and use of PL/SQL packages
Suggested Prerequisites:
- Basic knowledge of Linux operating system
Course Objectives
- Understand the multitenant architecture
- Understand regular and application pluggable databases
- Create and manage a multitenant container database and pluggable databases
- Manage storage within a multitenant container database and pluggable databases
- Manage security within a multitenant container database and regular and application pluggable databases
- Monitor performance and manage resources within a multitenant container database and pluggable databases
- Perform backup, recover and flashback operations on a multitenant container database and regular and application pluggable databases
- Perform particular operations like Oracle Data Pump transportation, loading, encryption, auditing
- Upgrade an Oracle Database 12.1 CDB or PDB to an Oracle Database 12.2 CDB or PDB
- Monitor pluggable databases in the Cloud
Course Content
- CDB Basics
- CDB and Regular PDBs
- Application PDBs and Application Installation
- PDB Creation
- CDB and PDB Management
- Storage
- Security
- Backup, Recovery, and Flashback
- Performance Monitoring
- Resources Allocation
- Data Movement
- Upgrade Methods
- Miscellaneous
- PDBs in Cloud