The command ALTER DATABASE FLASHBACK ON; enables the Flashback Database feature, which
provides a way to quickly revert an entire Oracle database back to a previous point in time. This
command can be executed while an Oracle 19c primary database is either open (option A) or
mounted (option B). It is also applicable to an Oracle 19c logical standby database while SQL Apply is
active (option E). However, it's important to note that enabling Flashback Database on the primary
does not automatically enable it on all associated standby databases, whether they are physical or
logical. Each database in a Data Guard configuration must have Flashback Database explicitly enabled
if desired. Real Time Query being active on a physical standby does not directly relate to the ability to
execute this command on the standby. Reference: The explanation is based on Oracle's concepts for
Flashback Technology and Data Guard configurations as detailed in the Oracle Database Backup and
Recovery User's Guide and the Oracle Data Guard Concepts and Administration guide.