There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database.The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12.Identify two changes, each of which would allow you to increase the number of […]
Which three statements are true about snapshot standby databases?
Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?
Examine this query and its output:SQL> select fs_failover_status, fs_failover_current_target,2 fs_failover_observer_present, fs_failover_oserver_host3 from v$database:FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGETFS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST————— […]
Which three are true about using RMAN in a Data Guard environment?
A customer has these requirements for their potential Data Guard implementation:1. Zero data loss must still be guaranteed through the loss of any one configuration component.2. The primary database must be protected against a regional disaster.3. Performance overheads on the primary should be […]
Examine the Data Guard configuration:DGMGRL> show configuration:Configuration-AnimalsProtection Mode: MaxAvailabilityDatabases:Sheep- Primary databaseWarning: ORA-16817: unsynchronized fast-start failover configurationDogs – (*) Physical standby database (disabled)ORA- 16661: the standby […]
You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:DGMGRL> SHOW CONFIGURATIONConfiguration – DRSolutionProtection Mode: MaxPerformanceDatabases:Close_by-Primary databaseFS_inst- Far SyncFar_away –Physical standby databaseFast-Start Failover: […]
After converting your physical standby database to a logical database, you get an error:DGMGRL> show configurationConfiguration- proddgProtection Mode: MaxPerformanceDatabases:prod-Primary datatabseprodsby-Physical standby databaseError: ORA-16810 multiple errors or warnings detected for […]
Which four requirements can be met by deploying a logical standby database?