Jump to content

Oracle Database Administration/Backup and Recovery

Add links
From Wikiversity
Oracle Database Administration
  1. Environment
  2. Instances
  3. Network
  4. Architecture
  5. Storage
  6. Undo Data
  7. Data Concurrency
  8. User Security
  9. Database Security
  10. Maintenance
  11. Performance
  12. Moving Data
  13. Backup and Recovery
  14. Support
Download Learning Guide

This lesson introduces backup and recovery.

Objectives and Skills

[edit | edit source]

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 | edit source]
  1. Oracle: Database 2-Day DBA Performing Backup and Recovery

Multimedia

[edit | edit source]
  1. YouTube: Backup & Recovery

Activities

[edit | edit source]
  1. Complete the tutorial Oracle: Performing Backup and Recovery.

See Also

[edit | edit source]

References

[edit | edit source]
  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"