Backing Up & Recovering Data
Oracle 12c
| Intermediate
- 17 Videos | 1h 20m 27s
- Includes Assessment
- Earns a Badge
A key responsibility of an Oracle database administrator is protecting databases from failure. 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.
WHAT YOU WILL LEARN
-
recognize responsibilities for preventing and responding to database, statement, and user process failures in Oracle Database 12cdescribe network failures, user errors and instance failures and describe the Oracle Flashback Technology features in Oracle Database 12cdescribe media failure and distinguish between complete and point-in-time recovery in Oracle Database 12cdescribe the Oracle data protection solutions in Oracle Database 12cexplain the use of checkpoints, redo log files, and log writers in Oracle Database 12cdescribe and configure instance recovery, and use the Mean Time To Recover (MTTR) Advisor in Oracle Database 12cconfigure and monitor the flash recovery area in Oracle Database 12cmultiplex control and redo log files in Oracle Database 12cconfigure archiving of redo log files in Oracle Database 12c
-
describe backup solutions in Oracle Database 12cdescribe backup types and the use of the Recovery Manager in Oracle Database 12cuse the Recovery Manager to configure backup settings in Oracle Database 12cimplement the Oracle suggested backup strategy and back up a control file to a trace file in Oracle Database 12ccreate backups using RMAN commands and manage backups in Oracle Database 12crecover a database and use the Data Recovery Advisor in Oracle Database 12crecover from loss of a control file or redo log file in Oracle Database 12crecover data files in NOARCHIVELOG and ARCHIVELOG modes in Oracle Database 12c
IN THIS COURSE
-
1.Database, Statement, and Process Failures4m 27s
-
2.Network and Instance Failures, and User Error4m 58s
-
3.Media Failure and Recovery Types5m 9s
-
4.Oracle Data Protection2m 5s
-
5.Checkpoints, Redo Log Files, and Log Writers4m 21s
-
6.Instance Recovery4m 59s
-
7.Configuring the Flash Recovery Area5m 4s
-
8.Multiplexing Control and Redo Log Files5m 23s
-
9.Archiving Redo Log Files6m 14s
-
10.Backup Solutions3m 59s
-
11.Backup Types and the Recovery Manager6m 41s
-
12.Configure Backup Settings4m 38s
-
13.Implementing a Backup Strategy3m 55s
-
14.Creating and Managing Backups4m 1s
-
15.Recovering a Database5m 35s
-
16.Recovering from Loss of Control or Redo Log Files3m 23s
-
17.Recovering Data Files5m 38s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.