• Online, Self-Paced
Course Description

A key responsibility of an Oracle database administrator is protecting databases from failure. It's also important to be able to import and export data in various ways. In this course, you'll learn how to back up and recover databases, how to migrate and load data, and how to work with external tables in Oracle Database 12c. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).

Learning Objectives

Failure Types and Recovery Options

  • start the course
  • recognize responsibilities for preventing and responding to database, statement, and user process failures in Oracle Database 12c
  • describe network failures, user errors and instance failures and describe the Oracle Flashback Technology features in Oracle Database 12c
  • describe media failure and distinguish between complete and point-in-time recovery in Oracle Database 12c
  • describe the Oracle data protection solutions in Oracle Database 12c
  • explain the use of checkpoints, redo log files, and log writers in Oracle Database 12c
  • describe and configure instance recovery, and use the Mean Time To Recover (MTTR) Advisor in Oracle Database 12c

Recovery Configuration

  • configure and monitor the flash recovery area in Oracle Database 12c
  • multiplex control and redo log files in Oracle Database 12c
  • configure archiving of redo log files in Oracle Database 12c

Database Backups

  • describe backup solutions in Oracle Database 12c
  • describe backup types and the use of the Recovery Manager in Oracle Database 12c
  • use the Recovery Manager to configure backup settings in Oracle Database 12c
  • implement the Oracle suggested backup strategy and back up a control file to a trace file in Oracle Database 12c
  • create backups using RMAN commands and manage backups in Oracle Database 12c

Database Recovery

  • recover a database and use the Data Recovery Advisor in Oracle Database 12c
  • recover from loss of a control file or redo log file in Oracle Database 12c
  • recover data files in NOARCHIVELOG and ARCHIVELOG modes in Oracle Database 12c

Moving and Loading Data

  • describe the functional components used for moving data and the use of Oracle Data Pump in Oracle Database 12c
  • work with Oracle Data Pump directory objects, clients, and modes in Oracle Database 12c
  • export data using Data Pump in Oracle Database 12c
  • import data using Data Pump in Oracle Database 12c
  • create a SQL*Loader control file in Oracle Database 12c
  • use SQL*Loader to load external data into tables in Oracle Database 12c

External Tables

  • describe the uses of external tables in Oracle Database 12c
  • use ORACLE_LOADER to access external tables in Oracle Database 12c
  • create and populate an external table using ORACLE_DATAPUMP in Oracle Database 12c
  • use data dictionary views to access information about external tables in Oracle Database 12c

Practice: Back up Database and Export HR Schema

  • verify database configuration and export the HR schema in the Oracle Database 12c

Framework Connections