Downloaded 194 times
Uploaded byMustafa Khan
Database backup & recovery
A backup is a copy of data that serves as a safeguard against unexpected data loss or errors. There are two main types of backups: full backups that copy all database data and require more storage, and incremental backups that only copy changed data since the last backup and require less storage but more time to restore. Backups can be performed offline after shutting down the database or online while the database is running. Database security protects the database from threats through securing hardware, software, people, and data to minimize losses from theft, loss of confidentiality or privacy, and loss of availability.
In this document
Powered by AI
Introduction to database backups, types including Full and Incremental backups. Full backups are comprehensive but require more storage, while Incremental backups save space by only storing changes.
Explains Offline and Online backup methods. Offline backups require shutdown, while Online backups allow data backup without interrupting database operations.
Discusses database security importance, addressing threats such as theft, loss of confidentiality, privacy issues, and availability. Emphasizes the need for strong security measures.
More Related Content
Similar to Database backup & recovery
Database backup & recovery
- 1. Database Backup &Security Mustafa khan ID: 3917
- 2. Introduction to BackupA backup is a copy of data. This copy can include important parts of the database, such as the control file and data files. A backup is a safeguard against unexpected data loss and application errors. If you lose the original data, then you can reconstruct it by using a backup.
- 3. There are twomain types of database backups: Full Backup Incremental Backup
- 4. Full Backup: Afull backup is used to create a copy of all data of entire database. It requires a large amount of storage space. A database can restored relatively quickly using a full backup as it requires to simply copy the backup files.
- 5.
- 6. Incremental Backup: AnIncremental backup creates a copy of only the data that have changed since the last backup. The Incremental backup only contains changes made to the database. Incremental database requires small amount of storage space. However it may take more time to restore a database.
- 7.
- 8. A database maybe in two different states while performing a backup Offline Backups: An offline backup a backup that is performed after a database has been shut down. The database administrator must schedule a time to shut down the database.
- 9. Online Backups Anonline backup is a backup that can be performed while a database is running. The database administrator does not have to shutdown the database. The user do not need to disconnect .
- 10. Database Security Database security is a process of protecting database from intentional or accidental threats. It includes the security of hardware, software, people and data related to database. The basic purpose of security is to minimize the losses that may occur due to different Security threats.
- 11. Some important factorsrelated to the security of database are as follows: 1:Theft and Fraud: Theft and fraud affect the database environment as well as entire organization. The security checks must be applied in database environment so no person may commit such activities. 2:Loss of confidentiality: confidentiality is a requirement to keep data secret.
- 12. 3: Loss ofprivacy: privacy is a requirement to protect people’s personal data. A problem in privacy may result in legal actions against the organization. 4:Loss of availability: it means that the data or the system may not be accessible. It can result in serious damage to the financial performance of the organization.
- 13.