Course details

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