Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN?

Question

Options

• AThe compatible initialization parameter is set to 10.2 or higher.
• BThere are no guaranteed restore points defined for the database.
• CThe default device for the backup must be set to disk.
• DThe tablespaces are locally managed.
• EThe fast recovery area is less than 50 percent free.

• A
  78% (28)
• C
  17% (6)
• E
  6% (2)

Explanation

About Unused Block Compression When employing unused block compression, RMAN skips reading, and backing up, any database blocks that are not currently allocated to some database object. This is regardless of whether those blocks had previously been allocated. So if a database table is dropped, RMAN will not back up the space that was occupied by that table until new objects are created in that space. Unused block compression is used automatically when the following conditions are true: - The COMPATIBLE initialization parameter is set to 10.2 or higher. - There are currently no guaranteed restore points defined for the database. - The data file is locally managed. - The data file is being backed up to a backup set as part of a full backup or a level 0 incremental - The backup set is created on disk, or Oracle Secure Backup is the media manager.

No community discussion yet for this question.