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 MOUNTALTER DATABASE OPEN RESETLOGS;
correct answer id D (3 and 1)
D – TRUE
But qestion dont ask in what state must be PDBs ???!!!
http://www.oracle-base.com/articles/12c/multitentant-flashback-of-container-database-12cr1.php
D
correct answer id D (3 and 1)
No, in this question they asked which is the next step after performing flasback statement. So the answer is C. (only statemet 3)
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.
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?
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.
D is final answer
D
Yes. D is correct.
D
D
D is correct
Helpful info. Lucky me I discovered your site unintentionally, and I am surprised why this coincidence did not came about earlier! I bookmarked it.|
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