BCE
FG wrong - tested in stend
E not exist ARCHIVAL attribute
see about C https://www.examtopics.com/discussions/oracle/view/23424-exam-1z0-083-topic-1-question-79-discussion/
Some of facts about archival backup:
• Use KEEP clause to create archival backup
• Use RESTORE POINT clause to assign a name to a specific SCN
○ It create a consistency point in the control file
○ The SCN is captured after the data file backup complete
• They are either considered obsolete only after a specific time that you specify or never considered obsolete
• Any files that need to restore this backup (to a consistent state) are kept, include data files, control files, SPFILE, archived log files, and relevant autobackup files (so what are relevant autobackup files)
• Cannot be stored in FRA, DBA must provide a FORMAT clause to specify a different location
• Recovery catalog is required to create archival backup of an OPEN DB. Without recovery catalog, you must put the DB in MOUNT state
• Without recovery catalog, you cannot use KEEP FOREVER as the backup will eventually age out of the control file
E: Not sure about 'ARCHIVAL' attribute. I use 'keep until' or 'keep forever', not 'ARCHIVAL'
I think that BDF is correct answer.
https://www.oracledistilled.com/oracle-database/backup-and-recovery/archival-backups-rman-backups-for-long-term-retention/
E: is incorrect. F is correct.
You can create archival backups with KEEP. Clause KEEP specifies the backup as an archival backup, which is a self-contained backup that is exempt from the configured retention policy.
RMAN does not consider backup pieces with the KEEP option when computing the retention policy. If available, RMAN uses these backups for disaster recovery restore operations, but their purpose is to produce a snapshot of the database that can be restored on another system for testing or historical usage.
Note: You cannot use KEEP to override the retention policy for files stored in the fast recovery area. If you specify KEEP when backing up to the recovery area, then RMAN issues an error.
https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/keepOption.html#GUID-36E9008E-48A5-4AB9-8C9D-2D477342594B
G is correct, since the question is about "Restore Point" therefore you have to use either "Keep forever" or "Keep until" and Hence Correct Answer is B,E,G
My mistake Recovery Catalog is only required with "Keep Forever", other clause "Keep Until" do not require a Recovery Catalog.
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.
dancymonkey
6 months, 3 weeks ago_gio_
1 year, 1 month agoOmnisumem
1 year, 1 month agoScottL
1 year, 3 months agohilaire
1 year, 6 months agoegore0496
2 years, 6 months agoegore0496
2 years, 6 months agoegore0496
2 years, 6 months agoleozanon94
2 years, 5 months agohkshado
2 years, 10 months agoMarco_M
3 years, 2 months agojorche
2 years, 11 months agojorche
2 years, 11 months agoObserverPL
3 years, 2 months agoABAJ
3 years, 2 months agoRinD
3 years, 2 months agodunhill
3 years, 2 months agonavingupta52
3 years, 1 month agoDBA007
2 years, 4 months agoDBA007
2 years, 4 months ago