A Data Guard environment has this configuration and these attributes:1. A primary database2. A Physical Standby Database named sbdb3. The configuration is in maximum availability protection mode.Then sbdb is converted to a snapshot standby database.When two statements are true? A. Sdbd can still apply redo. B. The recovery point objective increases. C. The protection mode […]
Which three are among the various tasks performed by the data Guard Monitor (DMON) process? A. performing role transitions when switchover requests are made B. communicating with DMON processes in other database instances that are part of the broker configuration C. activating role-based services appropriately in the various database instances of the configuration, based on […]
Examine the Data Guard configuration after an accidental switchover to Sheep:DGMGRL> show configuration;Configuration –AnimalsProtection Mode: MaxAvailabilityDatabases:sheep- Primary databasedogs- Logical standby databasecats- Physical standby database (disabled)ORA-16795: the standby database needs to be re-createdFast-Start Failover: DISABLEDConfiguration Status:SUCCESSWhich three will be true after a switchover to Dogs? A. Sheep will be a disabled logical standby database. B. Sheep […]
Which two statements are true for Data Guard environments with multi-tenant databases? A. Different pluggable databases within a logical standby database may have different guard statuses. B. The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation. C. The Data Guard broker automatically opens all pluggable […]
Which two are true about offloading backups to a physical standby database in a Data Guard environment?
Which two are true about offloading backups to a physical standby database in a Data Guard environment? A. The standby database must be registered in an RMAN catalog after the primary database has been registered. B. The standby database cannot be registered in an RMAN catalog if the primary database has not been registered. C. […]
Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when runningan application as an ordinary Oracle user? A. Real Time Query must be enabled on the primary database. B. Real Time Query must be enabled on the physical standby database. C. If a physically corrupt block is discovered on a […]
Examine the Data Guard configuration:DGMGRL> show configuration:Configuration –AnimalsProtection Mode: MaxAvailabilityDatabases:dogs- Primary databasesheep-Logical standby databasecats- Logical standby databaseFast-Start Failover: DISABLEDConfiguration Status:SUCCESSWhich three will be true after a switchover to Sheep? A. Cats will be an enabled logical standby database. B. Cats will be a disabled logical standby database. C. Dogs will be a logical standby database. […]
which situations may be used to perform restore operations to a logical standby database in a Data Guard environment?
Which three types of backups taken in which situations may be used to perform restore operations to a logicalstandby database in a Data Guard environment? A. backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered B. backups of data files taken on […]
Your Data Guard environment consists of these components and settings:1. A primary database2. Two remote physical standby databases3. The redo transport mode is set to SYNC.4. Real-time query is enabled for both standby databases.5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases.You notice an increase in redo apply lag time on both […]
A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows.As a result of this, you decide that an upgrade may use logical standby databases.Which two are true about upgrading Data Guard environments consisting of one logical standby databaserunning on a separate host from the primary? A. The upgrade always requires downtown until […]