Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam

Exam 1z0-062 topic 2 question 36 discussion

Actual exam question from Oracle's 1z0-062

Question #: 36
Topic #: 2

All of your live databases run in ARCHIVELOG mode.
On the SALES database there is no LEVEL 0 backup.
Examine these commands issued against the SALES database target:
RMAN> BACKUP AS BACKUPSET DATABASE;
..
backup set complete, elapsed time: 00:00:03
RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;
What is true about the execution of these commands?

A. A Level 0 backup of the database is created instead of the Level 1.
B. A backup is created which only contains blocks that have changed since BACKUP AS BACKUPSET command.
C. It throws an error because incremental level 1 backups require image copy backups as the Level 0 backup.
D. It throws an error because a Level 0 backup does not exist.

Show Suggested Answer

Suggested Answer: B 🗳️

by badcop at Aug. 28, 2020, 3:04 a.m.

Comments

Submit Cancel

TuxBingo

Highly Voted 4 years, 2 months ago

Correct Answer: A A level 1 incremental backup contains only blocks changed after a previous incre mental backup. If no level 0 backup exists in either the current or parent database incarnation when you run a level 1 backup, then RMAN makes a level 0 backup automatically.

upvoted 9 times

...

hggz

Highly Voted 4 years, 8 months ago

B is correct https://docs.oracle.com/database/121/ADMQS/GUID-74D6A06A-EC88-4CF0-B486-7B68DE4A78E4.htm#ADMQS09311

upvoted 6 times

katetel

3 years, 8 months ago

no the answer is A

upvoted 1 times

...

mayito1910

Most Recent 4 years, 5 months ago

Correct: A https://docs.oracle.com/database/121/BRADV/rcmquick.htm#BRADV89353

upvoted 2 times

...

badcop

4 years, 8 months ago

For B: Wrong "BACKUP AS BACKUPSET DATABASE;" is a full backup. Refer to https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/rman-backup-concepts.html#GUID-C93F3588-BBA9-4AE2-9E47-74C7A9468023 "A full backup has no effect on subsequent incremental backups. ... A full backup cannot be part of an incremental backup strategy; that is, it cannot be the parent for a subsequent incremental backup." So it's not related to the following incremental backup command.

upvoted 3 times

badcop

4 years, 8 months ago

For C: Wrong Refer to https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/rman-backup-concepts.html#GUID-0E273817-1EE0-40FD-BD92-51C4A0CAAF79 "Incremental backups at level 0 can be either backup sets or image copies, but incremental backups at level 1 can only be backup sets."

upvoted 2 times

badcop

4 years, 8 months ago

For D: Wrong Refer to https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/rman-backup-concepts.html#GUID-E9ABBACB-8259-4677-A8D4-81ED3194E7E2 "If no level 0 backup is available in either the current or parent incarnation, then the behavior varies with the compatibility mode setting. If compatibility is >=10.0.0, RMAN copies all blocks that have been changed since the file was created. Otherwise, RMAN generates a level 0 backup."

upvoted 2 times

badcop

4 years, 8 months ago

For A: The question doesn't mention whether a level 0 backup exists before "BACKUP INCREMENTAL LEVEL 1 DATABASE;" is executed, so the behavior can be level 0 or 1 backup. A is not fully correct, but considering other options are obviously wrong, A is better than worst.

upvoted 6 times

badguy001djh

4 years ago

It memtions that "On the SALES database there is no LEVEL 0 backup."

upvoted 2 times

...

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam

Exam 1z0-062 topic 2 question 36 discussion

Comments

TuxBingo

hggz

katetel

mayito1910

badcop

badcop

badcop

badcop

badguy001djh

SY0-701