Topic: Oracle 1z0-083 topic 1 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.

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

Re: Oracle 1z0-083 topic 1 question 140

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

Re: Oracle 1z0-083 topic 1 question 140

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

Re: Oracle 1z0-083 topic 1 question 140

In exam there are:
6. RECOVER DATABASE NOREDO
7. RECOVER DATABASE UNTIL AVAILABLE

So confirm that answer B is right

Re: Oracle 1z0-083 topic 1 question 140

7. RECOVER DATABASE UNTIL AVAILABLE REDO I guess

Re: Oracle 1z0-083 topic 1 question 140

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.

Re: Oracle 1z0-083 topic 1 question 140

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.

  • _gio_
  • New member
  • Offline

Re: Oracle 1z0-083 topic 1 question 140

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

Re: Oracle 1z0-083 topic 1 question 140

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

Re: Oracle 1z0-083 topic 1 question 140

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

Re: Oracle 1z0-083 topic 1 question 140

read oracle 19 docs., recovery about this scanario

Re: Oracle 1z0-083 topic 1 question 140

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)

Re: Oracle 1z0-083 topic 1 question 140

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

Re: Oracle 1z0-083 topic 1 question 140

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

Re: Oracle 1z0-083 topic 1 question 140

you should try it  )))

Re: Oracle 1z0-083 topic 1 question 140

It's C.

Re: Oracle 1z0-083 topic 1 question 140

nope it's not

Re: Oracle 1z0-083 topic 1 question 140

C is correct

  • ABAJ
  • New member
  • Offline

Re: Oracle 1z0-083 topic 1 question 140

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
  • New member
  • Offline

Re: Oracle 1z0-083 topic 1 question 140

F ? what F ?

  • ABAJ
  • New member
  • Offline

Re: Oracle 1z0-083 topic 1 question 140

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

  • gon20
  • New member
  • Offline

Re: Oracle 1z0-083 topic 1 question 140

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

  • RinD
  • New member
  • Offline

Re: Oracle 1z0-083 topic 1 question 140

B correct

  • RinD
  • New member
  • Offline

Re: Oracle 1z0-083 topic 1 question 140

I recheck, C is correct

Re: Oracle 1z0-083 topic 1 question 140

Correct is UNTIL AVAILABLE REDO
but not UNTIL AVAILABLE