1z0-076 Exam Dumps : Oracle Database 19c: Data Guard Administration

The commandALTER 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.References: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.

The compatible parameter on a standby database that is applying redo, must be equal to or greater than the compatible parameter on the primary that is shipping redo to that standby (A):This ensures that the standby database can apply redo from the primary, even after the primary has been upgraded. TheCOMPATIBLEparameter setting on the standby database should not preclude it from understanding the redo it receives.

Modifications to the data dictionary on the primary database caused by the upgrade, are applied on a physical standby database (C):When the primary database undergoes a non-rolling upgrade, any resulting data dictionary changes are transmitted through redo data and applied to the physical standby database.