1z1-076 무료 덤프문제 온라인 액세스

Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
dogs - Primary database
sheep - Snapshot standby database
cats - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
You 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 mode Failed.
Which is the minimum statement, or sequence of statements you must execute to enable successful raising of the protection mode to Maximum Protection?

• A.DGMGRL> edit database dogs set property LogxptMode=sync;
  DGMGRL> edit database sheep set property LogxptMode=sync;
• B.DGMGRL> edit database dogs set property LogXptMode=sync;
  DGMGRL> edit database cats set property LogXptMode=sync;
• C.DGMGRL> edit database sheep set property LogXptMode=sync;
• D.DGMGRL> edit database dogs set property LogxptMode=sync;
• E.DGMGRL> edit database dogs set property LogXptMode=sync;
  DGMGRL> edit database sheep set property LogxptMode=sync;
  DGMGRL> edit database cats set property LogXptMode=sync;
• F.DGMGRL> edit database cats set property LogXptMode=sync;

Which four factors can influence the rate of SQL apply on a logical standby database?

• A.the number of full table scans performed by SQL apply
• B.the size of the undo tablespace on the logical standby database
• C.the size of the shared pool
• D.the number of coordinator processes on the standby database instance
• E.the number of applier processes
• F.the number of PREPAER processes

Your Data Guard environment consists of these components and settings:
1. A primary database
2. Two remote physical standby databases
3. 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 standby databases.
Which two would you recommend to reduce the redo apply lag on the standby databases?

• A.Increase the size of the buffer cache on the physical standby database instances.
• B.Increase the number of standby redo log files on the standby databases.
• C.Decrease the redo log file size on the primary database.
• D.Increase the size of standby redo log files on the standby databases.
• E.Lower DB_BLOCK_CHECKING to MEDIUM or low on the standby databases.

You created the PRODSBY1 physical standby database for the PROD primary database using gql and RMAN. You are planning to create a Data Guard Broker configuration. You execute the command:

Which three statements are true regarding the execution of the command?

• A.The Data Guard Broker configuration files is automatically created in the destinations specified by the DG_BROKER_CONFIG_FILEn initialization parameters on the primary database.
• B.The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.
• C.The PRODSBYI standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBYl database instance is defined on the primary host.
• D.The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBYl database instances are defined on the primary host.
• E.The command will execute successfully only if the DG_BROKER_START initialization parameter is set to TRUE for the PROD database instance.
• F.The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START is TRUE for PRODSBYl.

You detected an unrecoverable archive gap in your data guard environment. So, you need to roll standby.
forward in time without applying a large number of archive log files using this command:
RMAN> RECOVER STANDBY DATABASE FROM SERVICE-<primary database name>;
When running this command, which of the following steps can be performed automatically?
1. Remember all data file names on the standby.
2. Restart standby in nomount.
3. Restore controlfile from primary.
4. Mount standby database.
5. Rename data files from stored standby names.
6. Restore new data files to new names.
7. Recover standby.

• A.1,3,5,6,7
• B.1, 2,3,4,6,7
• C.2,3,5,6,7
• D.1,2,3,4,5,6,7
• E.2,3,6,7