exam questions

Exam 1z0-062 All Questions

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

Exam 1z0-062 topic 1 question 175 discussion

Actual exam question from Oracle's 1z0-062
Question #: 175
Topic #: 1
[All 1z0-062 Questions]

You have successfully taken a database backup by using the command:
RMAN> BACKUP AS BACKUPSET DATABASE;
Now you execute this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;
What is the outcome?

  • A. It fails because an incremental level 1 backup always searches for an image copy as level 0 backup.
  • B. It fails because an incremental level 0 backup does not exist.
  • C. It takes a backup of blocks that have been formatted since the last full database backup.
  • D. It takes an incremental level 0 backup of the database.
  • E. It first takes an incremental level 0 backup and then an incremental level 1 backup.
Show Suggested Answer Hide Answer
Suggested Answer: E 🗳️
References:
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm
(4.4.1.2)

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
SKY_ming
Highly Voted 5 years ago
D IS RIGHT
upvoted 9 times
...
dad
Highly Voted 4 years, 7 months ago
correct answer is D :If there is no level 0 backup when you attempt a level 1 backup, RMAN will realize this and rather than returning an error will in fact perform a level 0 backup. (i just copy it from oracle doc)
upvoted 5 times
jackymak
3 years, 3 months ago
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm#sthref391 If compatibility is >=10.0.0, RMAN copies all blocks changed since the file was created, and stores the results as a level 1 backup. It sound like E.
upvoted 1 times
...
...
Ray520
Most Recent 2 years, 10 months ago
Selected Answer: E
Takes level 0 then level 1 backup
upvoted 1 times
...
Ray520
3 years, 1 month ago
D is correct. Sample spool for given commands (ran BACKUP AS BACKUPSET DATABASE first): BACKUP INCREMENTAL LEVEL 1 DATABASE; Starting backup at 18-APR-22 using channel ORA_DISK_1 no parent backup or copy of datafile 10 found no parent backup or copy of datafile 8 found no parent backup or copy of datafile 7 found no parent backup or copy of datafile 9 found channel ORA_DISK_1: starting incremental level 0 datafile backup set -----Level 0 backup being taken .... Finished backup at 18-APR-22
upvoted 2 times
Ray520
2 years, 10 months ago
Correction: E is correct as verified, takes level 0 first then level 1 backup
upvoted 1 times
...
...
Ray_gk
3 years, 1 month ago
E is actually correct. I verified using 12.1.0.2. My RMAN output is too large to post as a comment but I will explain my output. I took a backupset using the first command in the questions, which was done successfully. Upon completion of the previous command, I took an incremental level 1 backup. My initial output started as "no parent backup or copy of datafile x found" meaning that a previous level 0 backup of the specified datafiles were not detected. RMAN immediately began initiating a level 0 backup "channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set" for each datafile without a level 0 backup taken. A level 1 backup began immediately after the completion of the level 0 backups, which I observed in the output "channel ORA_DISK_1: starting compressed incremental level 1 datafile backup set" In this case, E is correct
upvoted 2 times
...
Oracle2020
3 years, 9 months ago
I think E: The only difference between a level 0 incremental backup and a full backup is that a full backup is never included in an incremental strategy. A level 1 incremental backup can be either of the following types: A differential backup, which backs up all blocks changed after the most recent incremental backup at level 1 or 0 A cumulative backup, which backs up all blocks changed after the most recent incremental backup at level 0
upvoted 1 times
...
dancymonkey
4 years, 10 months ago
E is right. Did the test on my own HW
upvoted 3 times
charan94
4 years, 1 month ago
But taking level 0 backup and level 1 backup back to back has no use...
upvoted 1 times
...
...
TuxBingo
4 years, 10 months ago
If no level 0 backup is available, then the behavior depends upon the compatibility mode setting. If compatibility is >=10.0.0, RMAN copies all blocks changed since the file was created, and stores the results as a level 1 backup. In other words, the SCN at the time the incremental backup is taken is the file creation SCN. If compatibility <10.0.0, RMAN generates a level 0 backup of the file contents at the time of the backup, to be consistent with the behavior in previous releases.
upvoted 2 times
...
Mohit201920
5 years, 2 months ago
SHOULD BE C
upvoted 3 times
...
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.

SaveCancel
Loading ...