Exam 1z0-083 All QuestionsBrowse all questions from this exam
Go to Exam
Question 140

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.

    Correct Answer: B

    To recover a database when all members of the current redo log group are lost before it is archived, the following minimum steps are required: 1) SHUTDOWN ABORT to immediately stop the database, 2) STARTUP MOUNT to mount the database, 3) RESTORE DATABASE to restore the data files, 4) RECOVER DATABASE NOREDO to recover the database without the current redo logs, and 5) ALTER DATABASE OPEN RESETLOGS to open the database with a new incarnation, thereby creating new redo logs. These steps ensure that the database is returned to a consistent state with minimal actions.

Discussion
egore0496Option: B

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

leozanon94

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

leozanon94

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

dancymonkey

7. RECOVER DATABASE UNTIL AVAILABLE REDO I guess

piontkOption: C

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.

ObserverPLOption: C

C is correct

gon20Option: C

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

mikom80Option: 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...

jackymakOption: B

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

freemun05Option: B

read oracle 19 docs., recovery about this scanario

saserdiOption: C

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

freemun05

you should try it )))

Neil107Option: C

It's C.

freemun05

nope it's not

antonicaOption: B

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.

_gio_Option: B

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

leader79Option: B

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)

leader79

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

ABAJ

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

gon20

F ? what F ?

ABAJ

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

RinDOption: B

B correct

RinD

I recheck, C is correct

egore0496

Correct is UNTIL AVAILABLE REDO but not UNTIL AVAILABLE

dunhillOption: A

I think A