Which three of these steps must be performed on the pri

You must use a physical standby database file to recover a data file on a primary database in a Data Guardenvironment.Which three of these steps must be performed on the primary database after the file has been backed up usingRMAN on the physical standby database? A. Connect to the primary database as the AUXILIARY. B. […]

Read More

Which two statements are true regarding Data Guard Broker?

Which two statements are true regarding Data Guard Broker? A. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby. B. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration. C. It can be […]

Read More

What can you conclude based on this error?

Examine the Data Guard configuration:DGMGRL> show configuration;Configuration –AnimalsProtection Mode: MaxPerformanceDatabases:dogs- Primary databasesheep- Physical standby databasecats- Snapshot standby databaseFast-Start Failover: DISABLEDConfiguration Status:SUCCESSYou receive an error while attempting to raise the protection mode to Maximum Protection:DGMGRL> edit configuration set protection mode as maxprotection:Error: ORA-16627: operation disallowed since no standby databases would remain to support protection modeFailed.What can […]

Read More

Which three will be true after a switchover to Sheep?

Examine the Data Guard configuration:DGMGRL> show configuration;Configuration –AnimalsProtection Mode: MaxAvailabilityDatabases:dogs- Primary databasecats- Physical standby databasesheep- Logical standby databaseFast-Start Failover: DISABLEDConfiguration Status:SUCCESSWhich three will be true after a switchover to Sheep? A. Dogs will be an enabled logical standby database. B. Sheep will be the primary database. C. Cats will be a disabled physical standby database. […]

Read More

Which two are effects of this change?

You edit the DGConnectIdentifier database property using the edit database set property DGMGRL command.Which two are effects of this change? A. The fal_client database initialization parameter on all standby databases is updated with the new value. B. The service attribute of the log_archive_dest_n initialization parameter for any database referring to the specified database is updated […]

Read More

which protection mode would you configure to meet these requirements?

You must configure an Oracle Data Guard environment consisting of:1. A primary database2. One Physical Standby Database3. One Logical Standby DatabaseYou must meet these requirements:1. Primary database availability should not be compromised by the availability of the standby databases.2. Under normal operations, transactions executed on the primary database should not commit before redo iswritten to […]

Read More

which protection mode should you configure to meet these requirements?

You must configure an Oracle Data Guard environment consisting of:1. A primary database2. A Physical Standby Database3. A Snapshot Standby DatabaseYou must meet these requirements:1. Primary database availability should not be compromised by the availability of the standby databases.2. Under normal operations, transactions executed on the primary database should not commit before redo iswritten to […]

Read More

Which two are true?

Examine the Data Guard configuration:DGMGRL> show configuration verbose;Configuration –AnimalsProtection Mode: MaxPerformanceDatabases:cats- Primary databasedogs-(*) Physical standby databasesheep- Physical standby database(*) Fast-Start Failover targetProperties:FastStartFailoverThreshold = ‘30’OperationTimeout = ‘30’TraceLevel = ‘USER’FastStartFailoverLagLimit = ‘30’CommunicationTimeout= ‘180’ObserverReconnect= ‘10’FastStartFailoverAutoReinstate= ‘FALSE’FastStartFailoverPmyShutdown= ‘TRUE’BystanderFollowRoleChange= ‘none’ObserverOverride = ‘FALSE’Fast-Start Failover: ENABLEDThreshold: 30 secondsTarget: dogsObserver: 015.example.comLag Limit: 30 secondsShutdown Primary: TRUEAuto-reinstate: FALSEObserver Reconnect: 10 secondsObserver Override: TRUEConfiguration Status:SUCCESSWhich […]

Read More