1Z0-060 · Question #67
Which three statements are true about using flashback database in a multitenant container database (CDB)?
The correct answer is B. To enable flashback database, the CDB must be mounted. D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB. E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point. Enabling flashback database on a CDB requires the database to be mounted, the retention target parameter to be configured, and target specification is limited to SCN or point in time in certain CDB contexts.
Question
Which three statements are true about using flashback database in a multitenant container database (CDB)?
Options
- AThe root container can be flashed back without flashing back the pluggable databases (PDBs).
- BTo enable flashback database, the CDB must be mounted.
- CIndividual PDBs can be flashed back without flashing back the entire CDB.
- DThe DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
- EA CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
How the community answered
(38 responses)- A16% (6)
- B79% (30)
- C5% (2)
Why each option
Enabling flashback database on a CDB requires the database to be mounted, the retention target parameter to be configured, and target specification is limited to SCN or point in time in certain CDB contexts.
Flashing back a CDB affects all containers - the root and all associated PDBs are returned to the target point together, because the CDB shares a single set of redo and flashback logs across all containers.
The ALTER DATABASE FLASHBACK ON command used to enable flashback on a CDB must be issued while the database is in MOUNT state, because the operation modifies control file settings and requires exclusive access before the database is opened.
Flashing back an individual PDB independently requires local undo mode to be enabled on the CDB and the use of a PDB-level restore point - it is not a universally available capability in all CDB configurations.
The DB_FLASHBACK_RETENTION_TARGET parameter must be set to a non-zero value to define how many minutes of flashback logs the system should retain, and this is a required prerequisite for enabling CDB-level flashback database.
In CDB flashback operations, the supported target specifications are a timestamp or an SCN - restore point-based flashback in a CDB environment has behavioral restrictions that distinguish it from non-CDB flashback usage.
Concept tested: Flashback database enablement and behavior in Oracle CDB
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/using-flashback-database-restore-points.html
Topics
Community Discussion
No community discussion yet for this question.