Exam 1z0-083 All Questions

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

Exam 1z0-083 topic 1 question 140 discussion

Actual exam question from Oracle's 1z0-083

Question #: 140
Topic #: 1

Examine this configuration:
1. CDB1 is a container database running in ARCHIVELOG mode.
2. Multiple uncommitted transactions are running in CDB1.
3. Redo log groups 1 and 2 are INACTIVE.
4. Redo log group 3 is the CURRENT group.
All members of redo log group 3 are lost before it is archived.
Examine these possible steps:
1. SHUTDOWN ABORT
2. STARTUP NOMOUNT
3. STARTUP MOUNT
4. ALTER DATABASE MOUNT
5. RESTORE DATABSE
6. RECOVER DATABASE NOREDO
7. RECOVER DATABASE UNTIL AVAILABLE
8. RESTORE ARCHIVELOG ALL
9. ALTER DATABSE OPEN
10.ALTER DATABASE OPEB RESETLOGS
Choose the minimum required steps in the correct order to recover the database.

A. 1, 3, 5, 8, 6, 10
B. 1, 3, 5, 6, 10
C. 1, 3, 5, 7, 10
D. 1, 2, 5, 7, 4, 10
E. 1, 3, 5, 6, 9

Show Suggested Answer

Suggested Answer: B 🗳️

by dunhill at May 9, 2021, 5:46 p.m.

Comments

Submit Cancel

egore0496

Highly Voted 2 years, 11 months ago

RECOVER DATABASE UNTIL AVAILABLE; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found ";": expecting one of: "redo" RMAN-01007: at line 1 column 33 file: standard input RMAN> RECOVER DATABASE NOREDO; Starting recover at 16.01.2022 16:50:40 using channel ORA_DISK_1 Finished recover at 16.01.2022 16:50:40 So C must be incorrect. B - ok

upvoted 6 times

leozanon94

2 years, 10 months ago

you are right, its possible that the question is truncated or this is a tricky question. Anyway it will be to pay attention during the exam

upvoted 1 times

leozanon94

2 years, 9 months ago

In exam there are: 6. RECOVER DATABASE NOREDO 7. RECOVER DATABASE UNTIL AVAILABLE So confirm that answer B is right

upvoted 1 times

dancymonkey

10 months, 3 weeks ago

7. RECOVER DATABASE UNTIL AVAILABLE REDO I guess

upvoted 1 times

...

df404e2

Most Recent 2 weeks, 2 days ago

Selected Answer: C

B is FALSE, as it causes no archive logs to be applied. This is meant for a database that is running in NOARCHIVELOG. C: RECOVER DATABASE UNTIL AVAILABLE REDO ; Finds the last available archived redo log and online redo logs, and recovers the database to the point where a log is missing. The database files still needs to be consistent enough to open the database.

upvoted 1 times

...

antonica

8 months, 3 weeks ago

B The NOREDO options is required if redo logs are not available. If you do not specify NOREDO when recovering a NOARCHIVELOG database, then RMAN ends recovery and issues an error.

upvoted 1 times

...

piontk

1 year, 2 months ago

This question is wrong. Is missing the word "REDO" on item 7. If you try a RECOVER DATABASE NOREDO and try to open the database with RESETLOGS option you get: ORA-01139: RESETLOGS option only valid after an incomplete database recovery If you try a RECOVER DATABASE NOREDO and try to open the database with RESETLOGS option you get: ORA-01113: file 1 needs media recovery. So NOREDO is not an option here. The right answer is C if item 7 is RECOVER DATABASE UNTIL AVAILABLE REDO". Otherwise there's no correct answer for this question.

upvoted 4 times

...

_gio_

1 year, 5 months ago

Selected Answer: B

B because "REDO" word is missing: RECOVER DATABASE UNTIL AVAILABLE REDO

upvoted 1 times

...

jackymak

1 year, 10 months ago

Selected Answer: B

B, There is no redo log so RECOVER DATABASE NOREDO should be enough.

upvoted 2 times

...

mikom80

1 year, 10 months ago

Selected Answer: C

if point 7 would be: "RECOVER DATABASE UNTIL AVAILABLE REDO" then answer: C.... In B, will be incomplete recovery (until level 0 or level 1 backup) without applying archive redo...

upvoted 3 times

...

freemun05

2 years, 8 months ago

Selected Answer: B

read oracle 19 docs., recovery about this scanario

upvoted 2 times

...

leader79

3 years, 2 months ago

I think B is the correct because of the "minimum required steps" restriction. (The C sames to be also correct, but in this case one aditional step to reapplying the redo entries will be made also)

upvoted 1 times

leader79

3 years, 2 months ago

Just one another remark. The correct syntax should be "UNTIL AVAILABLE REDO" and not "UNTIL AVAILABLE". So C must be incorrect.

upvoted 3 times

...

saserdi

3 years, 3 months ago

C is correct 12.2 NEW FEATURE : -RECOVER DATABASE UNTIL AVAILABLE REDO (Doc ID 2300465.1)

upvoted 2 times

freemun05

2 years, 8 months ago

you should try it )))

upvoted 1 times

...

Neil107

3 years, 4 months ago

It's C.

upvoted 2 times

freemun05

2 years, 8 months ago

nope it's not

upvoted 1 times

...

ObserverPL

3 years, 6 months ago

C is correct

upvoted 4 times

...

ABAJ

3 years, 6 months ago

F is the correct answer. Recover database until available is a new feature of 19c. https://web.stanford.edu/dept/itss/docs/oracle/10gR2/backup.102/b14191/recoscen008.htm#i1006564

upvoted 1 times

gon20

3 years, 6 months ago

F ? what F ?

upvoted 2 times

ABAJ

3 years, 6 months ago

I meant to say C is the correct answer. Don't know how come I typed F.

upvoted 3 times

...

gon20

3 years, 7 months ago

I go with C, recover and restore until available....

upvoted 4 times

...

RinD

3 years, 7 months ago

B correct

upvoted 1 times

RinD

3 years, 6 months ago

I recheck, C is correct

upvoted 5 times

egore0496

2 years, 11 months ago

Correct is UNTIL AVAILABLE REDO but not UNTIL AVAILABLE

upvoted 3 times

...

dunhill

3 years, 7 months ago

I think A

upvoted 1 times

...

Exam 1z0-083 All Questions

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

Exam 1z0-083 topic 1 question 140 discussion

Comments

egore0496

leozanon94

leozanon94

dancymonkey

df404e2

antonica

piontk

_gio_

jackymak

mikom80

freemun05

leader79

leader79

saserdi

freemun05

Neil107

freemun05

ObserverPL

ABAJ

gon20

ABAJ

gon20

RinD

RinD

egore0496

dunhill

SY0-701