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 is the main difference between a whole database backup and a partial database backup?

• Partial backup is more secure than whole backup.

• Whole backup includes all data files and control files, while partial backup includes only specific parts.

• Whole backup is faster than partial backup.

• Partial backup includes all data files and control files, while whole backup includes only specific parts.

Which type of backup only includes data blocks that have changed since the last backup?

• Full backup

• Partial backup

• Whole backup

• Incremental backup

What is a key characteristic of an offline backup?

• It is taken while the database is open.

• It is consistent because the SCN matches in all files.

• It is faster than an online backup.

• It does not require shutting down the database.

What is an image copy in the context of RMAN backups?

• A logical concept of backup files.

• A bit-for-bit copy of a database data file.

• A compressed version of the database.

• A backup set containing multiple backup pieces.

Why might backup sets be preferred over image copies?

• They can be used for all types of files.

• They are easier to manage.

• They are faster to create.

• They take up less disk space.

Which type of files cannot be backed up by RMAN?

• Archived redo log files

• Network configuration files

• Control files

• Data files

When is it recommended to use image copies for backups?

• When using tape devices.

• When backing up network files.

• When a quick restore is needed.

• When disk space is limited.