Backing Up & Recovering Data

Oracle 12c    |    Intermediate
  • 17 videos | 1h 20m 27s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 25 users Rating 4.6 of 25 users (25)
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 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

IN THIS COURSE

  • Locked
    1.  Database, Statement, and Process Failures
    4m 27s
    After completing this video, you will be able to recognize responsibilities for preventing and responding to database, statement, and user process failures in Oracle Database 12c. FREE ACCESS
  • Locked
    2.  Network and Instance Failures, and User Error
    4m 58s
    After completing this video, you will be able to describe network failures, user errors, and instance failures and describe the Oracle Flashback Technology features in Oracle Database 12c. FREE ACCESS
  • Locked
    3.  Media Failure and Recovery Types
    5m 9s
    After completing this video, you will be able to describe media failure and distinguish between complete and point-in-time recovery in Oracle Database 12c. FREE ACCESS
  • Locked
    4.  Oracle Data Protection
    2m 5s
    Upon completion of this video, you will be able to describe the Oracle data protection solutions in Oracle Database 12c. FREE ACCESS
  • Locked
    5.  Checkpoints, Redo Log Files, and Log Writers
    4m 21s
    After completing this video, you will be able to explain the use of checkpoints, redo log files, and log writers in Oracle Database 12c. FREE ACCESS
  • Locked
    6.  Instance Recovery
    4m 59s
    After completing this video, you will be able to describe and configure instance recovery, and use the Mean Time To Recover (MTTR) Advisor in Oracle Database 12c. FREE ACCESS
  • Locked
    7.  Configuring the Flash Recovery Area
    5m 4s
    In this video, you will learn how to configure and monitor the flash recovery area in Oracle Database 12c. FREE ACCESS
  • Locked
    8.  Multiplexing Control and Redo Log Files
    5m 23s
    In this video, you will learn how to multiplex control and redo log files in Oracle Database 12c. FREE ACCESS
  • Locked
    9.  Archiving Redo Log Files
    6m 14s
    In this video, you will learn how to configure archiving of redo log files in Oracle Database 12c. FREE ACCESS
  • Locked
    10.  Backup Solutions
    3m 59s
    Upon completion of this video, you will be able to describe backup solutions for Oracle Database 12c. FREE ACCESS
  • Locked
    11.  Backup Types and the Recovery Manager
    6m 41s
    After completing this video, you will be able to describe backup types and how to use the Recovery Manager in Oracle Database 12c. FREE ACCESS
  • Locked
    12.  Configure Backup Settings
    4m 38s
    In this video, you will learn how to use the Recovery Manager to configure backup settings in Oracle Database 12c. FREE ACCESS
  • Locked
    13.  Implementing a Backup Strategy
    3m 55s
    In this video, you will implement the Oracle suggested backup strategy and back up a control file to a trace file in Oracle Database 12c. FREE ACCESS
  • Locked
    14.  Creating and Managing Backups
    4m 1s
    In this video, find out how to create backups using RMAN commands and how to manage backups in Oracle Database 12c. FREE ACCESS
  • Locked
    15.  Recovering a Database
    5m 35s
    To learn how to recover a database and use the Data Recovery Advisor in Oracle Database 12c, consult the documentation or seek expert advice. FREE ACCESS
  • Locked
    16.  Recovering from Loss of Control or Redo Log Files
    3m 23s
    In this video, find out how to recover from the loss of a control file or redo log file in Oracle Database 12c. FREE ACCESS
  • Locked
    17.  Recovering Data Files
    5m 38s
    Learn how to recover data files in both NOARCHIVELOG and ARCHIVELOG modes in Oracle Database 12c. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Pro Oracle Database 23c Administration: Manage and Safeguard Your Organization's Data, Fourth Edition
Course Backup & Recovery: Business Continuity & Disaster Recovery
Rating 4.7 of 471 users Rating 4.7 of 471 users (471)
Course Backup & Recovery: Enterprise Backup Strategies
Rating 4.6 of 1588 users Rating 4.6 of 1588 users (1588)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Performing & Managing Backups
Rating 4.4 of 26 users Rating 4.4 of 26 users (26)
Course Relational Database Concepts
Rating 4.4 of 649 users Rating 4.4 of 649 users (649)
Course Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Rating 4.6 of 255 users Rating 4.6 of 255 users (255)