You must propose an Oracle Data Guard configuration for a database supporting a DSS workload that meets these permanent requirements:
1. The performance impact on the primary database should be kept to a minimum.
2. Creating and maintaining materialized views should not impact the performance of the primary database.
Additionally, there are these requirements, only the one of which is ever done at any one time:
3. It should be possible to apply designated patches with a minimum amount of downtime.
4. Upgrading to a new database release should be performed with the least possible amount of downtime.
5. New application software releases should be tested against an exact up-to-date replica of the production database.
You propose a configuration operating in Maximum Performance mode with a primary database and one logical standby database.
Which requirements do you meet?
Which two are true about Data Guard Broker configuration parameter administration? (Choose two.)
Which three factors can influence the rate of redo apply on a physical standby database? (Choose three.)
Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard? (Choose three.)
Which two Data Guard features require the use of flashback database by the broker? (Choose two.)
On your logical standby database, you specified these rules:
SQL> EXECUTE DBMS_LOGSTBY.SKIP (STMT=> 'DML', -
SCHEMA_NAME => 'HR', -
OBJECT_NAME=> 'EMP_NEW');
SQL> EXECUTE DBMS_LOGSTBY.SKIP (STMT=> 'DML', -
SCHEMA_NAME => 'HR', -
OBJECT_NAME=> 'EMP_OLD');
After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:
SQL> EXECUTE DBMS_LOGSTBY.UNSKIP (STMT=> 'DML', -
SCHEMA_NAME => 'HR', -
OBJECT_NAME=> 'EMP%');
Which is true regarding the execution of the UNSKIP procedure?
You are licensed to use Oracle Active Data Guard.
Which two statements are true after enabling block change tracking on a physical standby database? (Choose two.)
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration -Animals
Protection Mode: MaxAvailability
Databases:
dogs- Primary database
cats- Snapshot standby database
sheep- Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-01034: ORACLE not available
ORA-16625: cannot reach database "dogs"
DGM-17017: unable to determine configuration status
You wish to perform a failover to Sheep.
Which command, or sequence of commands, should you issue to the broker before executing "failover to sheep", using the broker?