Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.
Which components are backed up when this option is specified?
A.
only the control file, the current SPFILE, and data files
B.
only the current SPFILE and data files if autobackup is disabled
C.
only the data files and the archived redo logs
D.
the control file, current SPFILE file, data files, and archived redo logs
Explanation:
When the KEEP clause is specified, RMAN backs up all necessary components to ensure that the database can be restored. This includes the control file, the current SPFILE, data files, and the archived redo logs if the database is open when the backup is performed. You should note that when you use the KEEP clause, the KEEP clause takes precedence over other configured settings, such as any configured retention policy. Also, the control file is backed up even if autobackup has been disabled.
All of the other options are incorrect because the control file, current SPFILE, data files, and archived redo logs are backed up when you specify the KEEP clause.