Oracle Database Administration from Zero to Hero - Performing RMAN Backups - Part I (1 of 2)

The video tutorial covers RMAN backup strategies, types, and modes. It explains whole and partial backups, full and incremental backups, and offline and online backup modes. The tutorial also compares image copies and backup sets, highlighting their advantages and providing recommendations for their use. Additionally, it discusses the types of files RMAN can back up and those that require manual backup.

What are the two main choices for backup strategies when creating a backup and recovery plan?

• Whole backup

• Partial backup

Explain the difference between a full backup and an incremental backup.

• Full backup backs up all data blocks

• Incremental backup backs up only changed data blocks

What are the two types of incremental backups mentioned in the lecture?

• Differential

• Cumulative

Describe the main difference between offline and online backups.

• Offline backup is taken when the database is closed

• Online backup is taken while the database is open

What is the significance of the system change number (SCN) in relation to offline backups?

• Ensures consistency of data files

• Matches SCN number in control files

How does RMAN differentiate between backup sets and image copies?

• Backup sets contain used blocks

• Image copies are complete copies of data files

What types of database files can RMAN back up?

• Data files

• Control files

• Archived redo log files