Oracle Database Administration from Zero to Hero - Performing Incremental Backups (1 of 3)

The lecture covers incremental backups, focusing on differential and cumulative types. Incremental backups are faster and use less space than full backups, as they only save changed blocks. Differential backups save changes since the last incremental backup, while cumulative backups save changes since the last level 0 backup. The lecture explains the benefits and drawbacks of each type, emphasizing space efficiency and recovery speed. Differential backups are preferred for space-saving, while cumulative backups simplify recovery.

What is one of the main benefits of incremental backups compared to traditional full backups?

• They do not support no logging option.

• They only back up changed blocks since the last backup.

• They require more storage space.

• They are slower to perform.

What is the starting point for all incremental backups?

• Level 1 backup

• No backup is needed

• Level 0 backup

• Full database backup

In a differential incremental backup, what does a level 1 backup contain?

• Changes since the last incremental backup

• Changes since the last level 0 backup

• All data blocks in the database

• No changes are stored

How does a cumulative incremental backup differ from a differential backup?

• It requires more frequent backups.

• It stores changes since the last incremental backup.

• It does not support level 0 backups.

• It stores changes since the last level 0 backup.

What is a key advantage of cumulative backups during recovery?

• They take up less storage space.

• They do not require a level 0 backup.

• They require reading from fewer backup files.

• They are faster to perform.

Which type of incremental backup is the default when using the RMAN command without specifying the type?

• Cumulative

• Differential

• No backup

• Full

Why might one prefer differential backups over cumulative backups?

• They are faster to recover.

• They take up less space.

• They store all changes since the last full backup.

• They do not require a level 0 backup.