Introduction to Oracle Database Backup and Security

Oracle Database  is a relational database management system -RDBMS that is widely used by a lot of organisations to store and manage their data.

Database backup and recovery as well as securing the database from unauthorized access are key tasks performed by Database administrators or anyone that closely works with  or looks after databases.

As a backup administrator, your principal duty is to devise, implement, and manage a backup and recovery strategy. In general, the purpose of a backup and recovery strategy is to protect the database against data loss and reconstruct the database after data loss.

The Oracle database provides security in the form of authentication, authorization, and auditing. Authentication ensures that only legitimate users gain access to the system. Authorization ensures that those users only have access to resources they are permitted to access.

This course is a practical hands-on that will teach you how to:
    • Perform a  full database backup
    • Perform a database  restore and recovery
    • View and retrieve historical data using Flashback technology
    • Recover and retrieve dropped tables
    • Establish security measures to protect the database
    • Manage user roles and privileges to the database  
    • Enabling Archive log mode
    • Auditing Oracle Database users
    • Predefined Oracle user accounts

After the end of this course , you will know how to :

  • Backup and restore a database
  • Manage database user access and security
  • Recover dropped tables
  • Use Oracle flashback technology.