Wikiversity

Oracle Database Administration/Backup and Recovery

< Oracle Database Administration

This lesson introduces backup and recovery.

Objectives and Skills edit

Objectives and skills for the backup and recovery portion of Oracle Database Administration I certification include:[1]

  • Backup and Recovery Concepts
    • Identify the types of failure that can occur in an Oracle database
    • Describe ways to tune instance recovery
    • Identify the importance of checkpoints, redo log files, and archived log files
    • Overview of flash recovery area
    • Configure ARCHIVELOG mode
    • Performing Database Backups
  • Create consistent database backups
    • Back up your database without shutting it down
    • Create incremental backups
    • Automate database backups
    • Manage backups, view backup reports and monitor the flash recovery area
  • Performing Database Recovery
    • Overview of Data Recovery Advisor
    • Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)

Readings edit

  1. Oracle: Database 2-Day DBA Performing Backup and Recovery

Multimedia edit

  1. YouTube: Backup & Recovery

Activities edit

  1. Complete the tutorial Oracle: Performing Backup and Recovery.

See Also edit

References edit

  1. ↑ Oracle: Database 11g: Administration I Exam Topics

2. l Getting Started | Database Administration

3. | Oracle Database Administration

4. | Oracle Database Administration 2

Retrieved from "https://en.wikiversity.org/w/index.php?title=Oracle_Database_Administration/Backup_and_Recovery&oldid=2578389"