You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:
DGMGRL> SHOW CONFIGURATION
Configuration DRSolution
Protection Mode: MaxPerformance
Databases:
Close_by Primary database
FS_inst Far Sync
Far_away Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
What is true concerning this configuration?
An Oracle Data Guard far sync instance is a remote Oracle Data Guard destination that accepts redo from the primary database and then ships that redo to other members of the Oracle Data Guard configuration. A far sync instance manages a control file, receives redo into standby redo logs (SRLs), and archives those SRLs to local archived redo logs, but that is where the similarity with standbys ends. A far sync instance does not have user data files, cannot be opened for access, cannot run redo apply, and can never function in the primary role or be converted to any type of standby database.
References:
https://docs.oracle.com/database/121/SBYDB/create_fs.htm
After converting your physical standby database to a logical database, you get an error:
DGMGRL> show configuration
Configuration proddg
Protection Mode: MaxPerformance
Databases:
prod Primary database
prodsby Physical standby database
Error: ORA-16810 multiple errors or warnings detected for database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
How can you rectify the error?
You can reenable the standby database or reset the primary database state to ONLINE to fix the inconsistencies.
References:
https://docs.oracle.com/cd/B19306_01/server.102/b14230/cli.htm
Which four requirements can be met by deploying a logical standby database? (Choose four.)
A: DDL Statements supported by a Logical Standby Database include:
ALTER INDEX
CREATE INDEX
DROP INDEX
C: DDL Statements supported by a Logical Standby Database include:
CREATE TABLE
DROP TABLE
A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary database returns several rows.
As a result of this, you decide that an upgrade may not use logical standby databases.
Which three are true about upgrading Data Guard environments consisting of one physical standby database running on a separate host from the primary? (Choose three.)
B: Disable the broker's management of the configuration and then stop the broker.
E: On the primary database install the newer release of the Oracle software, and on the logical standby database, install the newer release of the Oracle software.
Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.
Switchovers or failovers are possible due to testing or in case of a disaster.
Clients use local TNSNAMES.ORA files to define connection strings to the database instances.
Which three will prevent clients from connecting to the wrong database instances? (Choose three.)
Currently there are no comments in this discussion, be the first to comment!