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--------------- ----------------------- ---------------- ------------------BYSTANDER cats NOO17.example.com -Which are true?
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 minimized as much as possible given these requirements.4. Downtime on the primary database for any reason must be kept to a minimum.Components referred to in the broker commands are:Which Data Guard broker commands are needed to implement these requirements?
Examine the Data Guard configuration:DGMGRL> show configuration:Configuration-Animals -Protection Mode: MaxAvailabilityDatabases:Sheep- Primary database -Warning: ORA-16817: unsynchronized fast-start failover configurationDogs (*) Physical standby database (disabled)ORA- 16661: the standby database needs to be reinstatedFast-Start Failover: ENABLED -Configuration Status:WARNING -And the fast-start failover configuration:DGMGRL> show fast_start failover;Fast-Start Failover: ENABLED -Threshold : 30 seconds -Target: dogs -Observer : 017.example.com -Lag Limit: 30 seconds (not in use)Shutdown Primary: TRUE -Auto-reinstate: TRUE -Observer Reconnect: 10 seconds -Observer Override: FALSE -Configurable Failover ConditionsHealth Conditions:Corrupted Controlfile YES -Corrupted Dictionary YES -Inaccessible Logfile NO -Stuck Archiver NO -Datafile Offline YES -Oracle error Conditions:ORA-01578: ORACLE data block corrupted (file # %s, block # %s)And finally the reason for the fail over:SQL> select last_failover_reason from v$fs_failover_stats;LAST_FAILOVER_REASON -ORA-01578: ORACLE data block corrupted (file # %s, block # %s)Identify the task, or sequence of tasks, to bring the configuration into the SUCCESS state.
Which two statements are true for Data Guard environments with multi-tenant databases?
