1Z0-076 Sample Questions & Answers

The DB_FILE_NAME_CONVERT parameter is used to specify how to convert primary database datafile paths to standby database datafile paths. RMAN's DUPLICATE command reads this parameter from the auxiliary (standby) instance's parameter file to automatically create the standby datafiles in the correct location. The format is ('string1', 'string2'), where string1 is the pattern in the primary location and string2 is the pattern for the standby location.

When the primary database is shut down gracefully, the Broker recognizes this as a controlled event, not an error. The overall configuration is still considered valid and will report a status of SUCCESS. However, the state of the primary database itself will change to reflect that it is no longer transporting redo, typically shown as LOG-TRANSPORT-OFF. An ERROR status would imply an unexpected failure.

The DBMS_LOGSTDBY.SKIP procedure is used to create rules for SQL Apply. To skip DDL for a specific object while allowing DML, the statement_opt should be set to 'SCHEMA_DDL' and the schema_name and object_name parameters should be specified. Using 'TABLE' would skip both DDL and DML for the object. This provides granular control over what gets applied on the logical standby.

Redo transport compression can be configured on a per-destination basis. By adding the COMPRESSION=ENABLE attribute to the specific LOG_ARCHIVE_DEST_n parameter that points to the reporting standby, compression will be enabled only for that redo stream. This allows for granular control, leaving the transport to the other DR standby uncompressed if desired. This feature requires an Active Data Guard license.

This statement is true. The VALIDATE DATABASE command is a powerful diagnostic tool within DGMGRL. It performs a comprehensive check of the specified database's readiness for its role, which includes verifying that standby redo logs (SRLs) are properly configured. It checks for correct size, number of groups, and whether they are being used, which is critical for higher protection modes.

The observer must be able to establish a direct SQL*Net connection to both the primary and the target standby database to monitor their health. The error ORA-16664 combined with intermittent connection failures to the remote standby strongly suggests a network connectivity issue. The most common cause in such a topology is a firewall rule that is not configured to allow the observer's IP address to connect to the standby's listener port (typically 1521).

The transient logical standby method involves: 1) Converting a physical standby to a logical standby. 2) Applying the patch or upgrade to the logical standby while it continues to apply redo from the primary. 3) Performing a switchover to make the upgraded standby the new primary. This minimizes application downtime to the duration of the switchover.

With STANDBY_FILE_MANAGEMENT=AUTO, when a new PDB is created on the primary, the redo generated for the creation will cause the corresponding datafiles to be automatically created on the standby system. However, the PDB itself will be in a mounted state on the standby. It will not be automatically opened. A DBA would need to intervene if they wanted to open it read-only on an Active Data Guard standby.

Real-Time Cascading involves a primary database sending its redo to a single standby database (the cascading standby), which in turn forwards the redo to one or more other standby databases (the terminal standbys). This reduces the overhead on the primary, as it only needs to manage one redo stream. A Far Sync instance can also be a cascading destination, but the core concept is a standby forwarding redo to other standbys.

For Automatic Block Media Recovery to function, the physical standby database must be an Active Data Guard instance, meaning it must be open in read-only mode with redo apply active. If the standby is only in a mounted state, the primary database cannot fetch the good version of the corrupted block from it. Therefore, the standby not being open is a primary reason for ABMR failure.