Which three conditions must be true for unused block compression to be used automatically
while performing backups by using RMAN?
A.
The compatible initialization parameter is set to 10.2 or higher.
B.
There are no guaranteed restore points defined for the database.
C.
The default device for the backup must be set to disk.
D.
The tablespaces are locally managed.
E.
The fast recovery area is less than 50 percent free.
Explanation:
Reference:
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#BRADV89481 (See
unused block compression)
Hi,
The answer said only two options of three requested.
I think is ABD
I agree. This seems the most likely. See here: https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#BRADV89481
A B D
What about C? Unused block compression can be used to sbt devices only with Oracle Secure Backup.
But I agree with A B D
ABD
RMAN backupset only backup used blocks. Why unused block here?
A,B,D
http://docs.oracle.com/database/121/BRADV/rcmcncpt.htm#BRADV89481
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 backup.
— The backup set is created on disk, or Oracle Secure Backup is the media manager.
Thank u so much, it’s so Clear.
I think D is not correct. In the link you show you can read ‘The data file is locally managed’.
The answer D talks about ‘tablespaces’, not ‘data files’.
So i think the correct answer is: A, B, C.
Thanks Max. A,B,D
http://docs.oracle.com/database/121/BRADV/rcmcncpt.htm#BRADV89481
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 backup.
— The backup set is created on disk, or Oracle Secure Backup is the media manager.
A,B,D
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 backup.
The backup set is created on disk, or Oracle Secure Backup is the media manager.
https://docs.oracle.com/database/121/BRADV/rcmcncpt.htm#BRADV194
https://docs.oracle.com/cd/E16338_01/backup.112/b56269/rcmcncpt.htm#BABIDCCI
ABD