Backing Up, Recovering, Importing, and Exporting Data in Oracle Database 12c Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Expertise Level Overview/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).
Target Audience
Data warehouse administrator; database administrators; database designers; support engineer; technical administrator
Prerequisites
None
Expected Duration (hours)
2.3
Lesson Objectives Backing Up, Recovering, Importing, and Exporting Data in Oracle Database 12c
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
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
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
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
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
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
verify database configuration and export the HR schema in the Oracle Database 12c
Course Number: od_dbre_a04_it_enus
Expertise Level
Intermediate