The _______ writes the Flashback Database logs in the flash recovery area.
A.
FLSH
B.
FLDB
C.
RVWR
D.
RVRW
E.
FBDA
Explanation:
RVWR (Recovery Writer Process), Writes flashback data to the flashback logs in the fast
recovery area RVWR writes flashback data from the flashback buffer in the SGA to the
flashback logs. RVWR also creates flashback logs and performs some tasks for flashback
log automatic management. Existed in Database instance, Flashback Database
FBDA (Flashback Data Archiver Process), Archives historical rows for tracked tables into
flashback data archives and manages archive space, organization, and retention
When a transaction that modifies a tracked table commits, FBDA stores the pre-image of the
rows in the archive. FDBA maintains metadata on the current rows and tracks how much
data has been archived.
FBDA is also responsible for automatically managing the flashback data archive for space,
organization (partitioning tablespaces), and retention. FBDA also keeps track of how far the
archiving of tracked transactions has progressed.
See Also: Oracle Database Advanced Application Developer’s Guide
Existed in Database and ASM instances
C is correct:
https://docs.oracle.com/database/121/REFRN/GUID-30039A0A-B292-491D-8D6A-8A802AEBE042.htm#REFRN00547
This wait event only occurs when Flashback Database is turned on. A session waits for recovery writer (RVWR) to write flashback data to the flashback logs on disk because the buffers are full. Until RVWR can free up the buffers, the session may need to wait.