Which command or commands should you execute next to allow updates to the flashback back schema?

Flashback is enabled for your multitenant container database (CDB), which contains two
pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the
CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT

SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”;
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back
schema?

Flashback is enabled for your multitenant container database (CDB), which contains two
pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the
CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT

SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”;
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back
schema?

A.
Only 1

B.
Only 2

C.
Only 3

D.
3 and 1

E.
1 and 2

Explanation:
Example (see step23):
Step 1:
Run the RMAN FLASHBACK DATABASE command.
You can specify the target time by using a form of the command shown in the following examples:
FLASHBACK DATABASE TO SCN 46963;
FLASHBACK DATABASE
TO RESTORE POINT BEFORE_CHANGES;
FLASHBACK DATABASE TO TIME
“TO_DATE(’09/20/05′,’MM/DD/YY’)”;
When the FLASHBACK DATABASE command completes, the database is left mounted and
recovered to the specified target time.
Step 2:
Make the database available for updates by opening the database with the RESETLOGS option. If
the database is currently open read-only, then execute the following commands in SQL*Plus:
SHUTDOWN IMMEDIATE
STARTUP MOUNT

ALTER DATABASE OPEN RESETLOGS;



Leave a Reply 16

Your email address will not be published. Required fields are marked *


R

R

correct answer id D (3 and 1)

Mohammad Rafiq

Mohammad Rafiq

correct answer id D (3 and 1)

Djuro

Djuro

No, in this question they asked which is the next step after performing flasback statement. So the answer is C. (only statemet 3)

Domingo

Domingo

The question is which command or “COMMANDS”… to allow updates to the flash back schema.

The schema is in a PDB so alter database open resetlogs doesn’t open PDB, because of this is not possible updates in the schema.

Future09

Future09

Domingo You did the certfication a few weeks ago.
How many question from this catalog are part of the real certification you did.
So how many new questions are in?

Denny

Denny

It actually says “command or commands”

But still it is being done for a user dropped in the PDB, so you’d probably want to open the PDB to “allow updates to the flashback schema”. You can’t have updates (assume they mean DML statement) in the schema without the PDB being open.

SUN

SUN

D is final answer

RS VASAN

RS VASAN

Yes. D is correct.

Umaruddin Ansari

Umaruddin Ansari

D is correct

see this here

see this here

Helpful info. Lucky me I discovered your site unintentionally, and I am surprised why this coincidence did not came about earlier! I bookmarked it.|

Sanjiv Ranjit

Sanjiv Ranjit

I dont think open without resetlogs is possible normally. I tested and the error was produced. But with the resetlogs options all went good and the user was recovered as well.

So its C