You have configured RMAN SBT channels to write backups to media. You then take an RMAN backup by using this command: Which three are true? (Choose three.)
A.
The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
B.
The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
C.
All archive logs created after this backup are kept for two years.
D.
The SPFILE is included in the self-contained archival backup.
E.
The control file is included in the self-contained archival backup.
F.
The restore point is a label for the system change number (SCN) before the archival backup was taken.
B,D,E are correct
The restore point is a label for the SCN to which this archival backup can be restored and recovered , and is captured just after the data file backups complete. (F is wrong)
Normal restore points are retained in the database for at least the number of days specified for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter (A incorrect)
-The control file autobackup that RMAN automatically makes when you use the backup .. keep command has a copy of the restore point (and also the spfile D and E are correct)
KEEP - Specifies the backup as an archival backup, which is a self-contained backup that is exempt from the configured retention policy.
UNTIL TIME - Specifies the time until which the backup or copy must be kept (B correct)
https://docs.oracle.com/cd/E18283_01/server.112/e17118/statements_6011.htm
http://devel.hotpilot.cz/ora11gR2u2-full/backup.112/e10643/rcmsubcl011.htm
An example:
http://www.online-database.eu/recovery-manager-rman/143-rman-backupsets-with-restore-point
It supports an optional RESTORE POINT clause that creates a normal restore point, which is a label for an SCN to which the backup must be recovered to be made consistent. The SCN is captured just after the data file backups complete. RMAN resynchronizes restore points with the recovery catalog and maintains the restore points as long as the backup exists. "Listing Restore Points" explains how to display restore points.
ok it's a small difference, archival backup = datafile & archivelog. restore point is jus tafter the datafile backup ready. will be followed by archivelog, cf, spfile
BDE as explained here: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-database.html#GUID-09DA2028-0C54-492B-BDE9-9CE07BCD4390
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
veginha
Highly Voted 3 years, 7 months agojanw
3 years, 5 months agojanw
3 years, 5 months agoGuhborges
Most Recent 6 months, 3 weeks ago_gio_
7 months, 3 weeks ago