RMAN is configured to create backupset backups for your database. You issue the command to back up the database:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two statements are true about the backup performed by the command?
A.
Only the used blocks in the data files are backed up.
B.
It backs up all the data files and deletes obsolete backups after the backup is complete.
C.
It backs up only those archived log files that are not backed up at least once.
D.
It backs up all the archived log files and deletes the ones that were just backed up.
E.
It backs up all archived redo log files and online log files and deleted the archived log files after the backup is complete.
AD
The BACKUP ARCHIVELOG … DELETE INPUT command deletes archived log files after they are backed up. This command eliminates the separate step of manually deleting archived redo logs.
With DELETE INPUT, RMAN deletes only the specific copy of the archived log chosen for the backup set. With DELETE ALL INPUT, RMAN deletes each backed-up archived redo log file from all log archiving destinations.
CE
C. As a result, by using “DELETE INPUT” we made RMAN, backup only one copy of all the archivelogs in one archivelog destination and then delete only the backed up copies of all the archivelogs in only one archivelog destination.
Link with example: http://uralural.blogspot.com.br/2011/06/difference-between-delete-input-and.html
E. The command “PLUS ARCHIVELOG” switches the online redo log and backup de archivelogs. After backed up the files, Rman delete the archives backed up.
Link: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckba.htm#BRADV8231
I think E is wrong because RMAN does not backup online redo log but only make a log switch.
I think C is correct
I think CD
I think AD is correct answer
A – Backup of entire data files occurs only when image copy is made, here this is not true so BACKUPSET is made which ommits not used blocks
D – Correct this is exactly what DELETE INPUT does
AD