Course Description
In this Oracle database administration course, Part 1 of a two part online training series, you will explore how an Oracle Database applies 'cloud computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. In this Oracle training, students learn how to perform complete and incomplete backup and recovery operations, utilize Oracles new FLEX ASM technology, and utilize Oracles new 12 tuning features such as heat map real time ADDM.
Once you have completed Oracle 12c: Database Administration II Part 1 the next course is this series is Oracle 12c: Database Administration II Part 2. The Oracle 12c: Database Administration II Part 2 course will continue to build your knowledge in backup and recovery operations, Oracle’s flashback technology, and advanced resource management.
In This Course You Will Learn:
- Define Oracles Multitenant architecture
- Manage Container Databases
- Use Oracles’ FLEX ASM
- Understand the ASM architecture
- Understand Oracles Cloud File Systems (ACFS)
- Create a Recovery Catalog
- Use a Recovery Catalog
- Define and Create a Virtual Private Catalog
- Set up Oracle Fast Recovery Area
- Administer the Recovery Catalog
- Perform RMAN backups
- Perform Fast incremental Backups
- Identify critical losses and non-critical losses
- Perform RMAN Recovery
Prerequisites
You need to have equivalent Oracle 9i database experience, taken training in 12c: SQL and PL/SQL and have taken the following courses from GogoTraining:
Outline
Module 00: Course Introduction - Oracle 12c Database Administration II Part 1
Module 01: Installing the Database Software and Creating a Database
- Demo: Installing the Database
- Demo: Creating a Database
- Lab Exercise: Installing the Database Software
- Lab Exercise: Create a Database
Module 02: Multitenant Architecture
- Define Oracle’s Multitenant Architecture
- Root Containers
- Container databases/Pluggable databases
Module 03: Managing Container Databases
- Connect to a container/pluggable databases
- Startup/Shutdown a container database
- Preservation of PDB mode upon restart of CDB
- Lab: Start/Stop a container database
- Lab: Preserve Pluggable open mode
- Lab Demo Solution: Start/Stop a container database
- Lab Demo Solution: Preserve Pluggable open mode
Module 04: Container Users and Roles
- Create container users
- Create Container Roles
- Lab: Create local users
- Lab: Create local roles
- Lab Demo Solution: Create local users
- Lab Demo Solution: Create local roles
Module 05: Container Profiles and Privileges
- Create Container Profiles
- Grant local privileges
- Lab: Grant local privileges
- Lab Demo Solution: Grant local privileges
Module 06: ASM Overview
- ASM Overview
- ASM Privileges
- ASM Components
- ASM Quiz
Module 07: ASM Instance Management
- ASM Instance Administration
- ASM Instance Parameters
- ASM diskgroups
- ASM Startup and Shutdown
Module 08: FLEX ASM
- FLEX ASM Architecture
- FLEX ASM Overview
- Configuring Flex ASM
- Managing Flex ASM
- Quiz Flex ASM
Module 09: ASM Files and Directories
- Using asmcmd
- ASM Directory Structure
- Creating ASM files
- Creating ASM directories
- Lab: Using asmcmd
- Lab Demo Solution: Using asmcmd
Module 10: Oracle Cloud File System
- Cloud File System Overview
- Cloud File System Components
- Using ACFS with Oracle ASM
- Oracle Cloud File System Quiz
Module 11: Fast Recovery Area
- Configure fast recovery area
- Configure flashback database
- Lab: Archivelog and flashback mode
- Lab Demo Solution: Archivelog and flashback mode
Module 12: Recovery Catalog
- Definition of recovery catalog
- Recovery catalog meta data
- Create the recovery catalog
Modules 13: Recovery Catalog Scripts and Databases
- Create recovery catalog scripts
- List target databases
- Synchronizing the recovery catalog
Module 14: Administering the Recovery Catalog
- Backup the recovery catalog
- Configure recovery catalog settings
- Create a virtual private catalog
- Recovery Catalog Quiz
Module 15: RMAN Backups Part 1
- Backup sets
- Image copies
- Non-compressed backups
- Compressed backups
- Incremental backups
- Backup ASM files
- Backup the Recovery Area
- Lab: Database backup
Module 16: Lab Demo Solution: Database Backup
Module 17: RMAN Backups Part 2
- RMAN encrypted backups
- Oracle Transparent Data Encryption
- Password Encryption
- Dual Mode Encryption
- RMAN Backups Quiz
Module 18: RMAN Critical Recovery
- Recover a critical data file
- Incremental recovery
- Image copy recovery
- Recovery to an alternate location
- Oracle’s Data Recovery Advisor
- Oracle Block Corruption
Module 19: Demo: Recover a non-critical file
Module 20: Diagnosing Backup Issues
- Using Oracles ADR
- Using RMAN DEBUG feature
- Reading Backup messages and Output
- Diagnosing Backups Quiz
Module 21: RMAN Recovery Concepts
- Instance Recovery
- Complete Database Recovery
- Incomplete database Recovery
- Recovery through Resetlogs.
- RMAN Recovery Quiz
Module 22: RMAN Recovery
- Recovery in NoArchivelog mode
- Recovery in Archivelog Mode
- Recovery of ASM disk Groups
- Point in Time recovery
- Table recovery using RMAN
- Lab: Perform Complete Recovery
- Lab Demo Solution: Demo on Complete Recovery
Module 23: Additional Recovery Concepts
- Parameter file recovery
- Control file Recovery
- Non-critical loss recovery
- Disaster Recovery
- Encrypted backup recovery
- Recovery Concepts Quiz
Certification
Oracle's Certified Professional is one of the certifications available to you after completing Oracle 12c: Database Administration II Parts 1 and 2. In order to become a Certified Professional, you will need to pass the following exams: