You issued the following RMAN command to back up the database:
RMAN> RUN{
ALLOCATE CHANNEL c1
DEVICE TYPE sbt
BACKUP DATABASE
TAG quarterly
KEEP FOREVER
RESTORE POINT FY06Q4;}
Which two statements are true regarding the backup performed? (Choose two.)
A.
Archived redo log files are backed up along with data files.
B.
Only data files are backed up and a restore point named FY06Q4 is created.
C.
Archived log files are backed up along with data files, and the archived log files are deleted.
D.
The command creates a restore point named FY06Q4 to match the SCN at which this backup
is consistent.
The answer is wrong.
BACKUP DATABASE – “Creates a backup of all data files in the database. If generating a backup set, then RMAN can include only data files and control files: it cannot include archived redo log files. ”
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta007.htm#RCMRF107
“The following example backs up the database, switches the online redo logs, and includes archived logs in the backup:
BACKUP DATABASE PLUS ARCHIVELOG; ”
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmbckba.htm#i1006297
KEEP option is added,
“Specifies the backup as an archival backup, which is a self-contained backup that is exempt from the configured retention policy.
An archival backup is self-contained because is contains all files necessary to restore the backup and recover it to a consistent state. If the database is open during the backup, then RMAN automatically generates and backs up the archived redo logs needed to make the database backup consistent
…
When KEEP is specified, RMAN creates multiple backup sets. RMAN backs up datafiles, archived redo logs, the control file, and the server parameter file with the options specified in the first backupOperand. ”
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsubcl011.htm
Answer is correct.
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta007.htm#RCMRF90046
keepOption
Overrides any configured retention policy for this backup so that the backup is not considered obsolete, as shown in Example 2-26.
You can use the KEEP syntax to generate archival database backups that satisfy business or legal requirements. The KEEP setting is an attribute of the backup set (not individual backup piece) or image copy.
Note: You cannot use KEEP with BACKUP BACKUPSET.
With the KEEP syntax, you can keep the backups so that they are considered obsolete after a specified time (KEEP UNTIL), or make them never obsolete (KEEP FOREVER). As shown in Example 2-27, you must be connected to a recovery catalog when you specify KEEP FOREVER.
Note: You can use CHANGE to alter the status of a backup generated with KEEP.
See Also: keepOption for more information about backups made with the KEEP option
Creating a Consistent Database Backup for Archival Purposes
This example uses a keepOption to create an archival backup set that cannot be considered obsolete for one year. The example backs up the database, archives the redo in the current online logs to ensure that this new backup is consistent, and backs up only those archived redo log files needed to restore the data file backup to a consistent state.
The BACKUP command also creates a restore point to match the SCN at which this backup is consistent. The FORMAT parameter must be capable of creating multiple backup pieces in multiple backup sets.
BACKUP DATABASE
FORMAT ‘/disk1/archival_backups/db_%U.bck’
TAG quarterly
KEEP UNTIL TIME ‘SYSDATE + 365’
RESTORE POINT Q1FY06;