Examine the RMAN commands executed in your database:
RMAN>CONFIGUREDEFAULT DEVICE TYPE TO disk;
RMAN>CONFIGURE DEVICETYPE DISK BACKUP TYPE TO BACKUPSET;
RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
You issue the command:
RMAN> BACKUP DATABASE;
Which two statements are true about the command?
A.
It performs a log switch.
B.
It creates compressed backup sets by using binary compression by default.
C.
It backs up only the used blocks in data files.
D.
It backs up data files, the control file, and the server parameter file.
E.
It creates a backup of only the control file whenever the database undergoes a structural
change.
C and D
C , D and E.
@VIJAY
We require only two statements.
CD
C:
RMAN backup sets automatically use unused block compression.
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm#i1015382
D:
If CONFIGURE CONTROLFILE AUTOBACKUP is ON (by default it is OFF), then RMAN automatically backs up the control file and server parameter file after every backup and after database structural changes.
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup003.htm#i1009642
Not E: spfile is also backed up.
CD
CD
A may also be possible. I will check again. Now test db off.
CD
CD
https://docs.oracle.com/cd/E16338_01/backup.112/b56269/rcmcncpt.htm#i1016424
CCd
This example shows the procedure for taking a whole database backup to the default destination:
RMAN> BACKUP DATABASE; # uses automatic channels to make backup
RMAN> SQL ‘ALTER SYSTEM ARCHIVE LOG CURRENT’; # switches logs and archives all logs
If oracle docs recomend to use “SWITCH” command after backup – I presume that A is wrong.
ANS DE?
Sorry CD
C,D
If the CONFIGURE CONTROLFILE AUTOBACKUP command is set to ON (by default it is OFF), then RMAN automatically backs up the control file and server parameter file after every backup and after database structural changes
CD