Which three statements are true about using flashback database in a multitenant container
database (CDB)?
A.
A CDB can be flashed back specifying the desired target point in time or an SCN, but not
a restore point.
B.
The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable
flashback of the CDB.
C.
Individual PDBs can be flashed back without flashing back the entire CDB.
D.
The root container can be flashed back without flashing back the pluggable databases
(PDBs).
E.
To enable flashback database, the CDB must be mounted.
ABE
BDE
But none of them looks like strictly correct.
For example, a CDB must be mounted or opened.
A. Explicitely wrong ->
https://docs.oracle.com/database/121/BRADV/rcmflash.htm#BRADV89752
Ex.:
FLASHBACK DATABASE TO SCN 46963;
FLASHBACK DATABASE
TO RESTORE POINT BEFORE_CHANGES;
FLASHBACK DATABASE TO TIME
“TO_DATE(’09/20/12′,’MM/DD/YY’)”;
C. wrong.
flashback pluggable database test to time “to_date(’23:00 01-01-2015′,’hh24:mi dd-mm-yyyy’)”;
RMAN-03002: failure of flashback command at 01/01/2015 23:00:00
RMAN-05108: Command is not supported for pluggable database
from “Oracle Database 12c: Managing Multitenant Architecture (D79128GC10)”
You can specify a restore point name
http://imgur.com/a/V47sb
Now i think “A” is not correct.
From 12.2 PDB flashback is possible , so C is correct option.
However, if we flashback CDB, all PDBs will be affected
I just found from Oracle site that this exam is validated agains 12.1.0.1
So C is not a correct option.
BDE is right.
BDE IS Right
A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point. – WRONG !!!
oracle@angel(/home/oracle)$ rman target /
Recovery Manager: Release 12.1.0.2.0 – Production on Fri Aug 25 01:53:54 2017
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2068650679)
RMAN> select cdb from v$database;
using target database control file instead of recovery catalog
CDB
—
YES
RMAN> shutdown immediate
database closed
database dismounted
Oracle instance shut down
RMAN> startup mount
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 2432696320 bytes
Fixed Size 2927288 bytes
Variable Size 654312776 bytes
Database Buffers 1761607680 bytes
Redo Buffers 13848576 bytes
RMAN> FLASHBACK DATABASE TO RESTORE POINT ‘BEFORE_UPDATE’;
Starting flashback at 25.08.2017 01:54:50
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=27 device type=DISK
starting media recovery
archived log for thread 1 with sequence 84 is already on disk as file +FRA/CDB/ARCHIVELOG/2017_08_24/thread_1_seq_84.362.952871009
media recovery complete, elapsed time: 00:00:01
Finished flashback at 25.08.2017 01:55:07
RMAN> ALTER DATABASE OPEN RESETLOGS;
Statement processed
RMAN> exit
Recovery Manager complete.
oracle@angel(/home/oracle)$