1Z1-066 試験問題を無料オンラインアクセス

A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows.
As a result of this, you decide that an upgrade may use logical standby databases.
Which two are true about upgrading Data Guard environments consisting of one logical standby database running on a separate host from the primary? (Choose two.)

• A.Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.
• B.Using manual upgrade, catupgrd.sql needs to run on the primary database only.
• C.The upgrade always required downtime until the upgrade of the primary is completed.
• D.Fast-Start Failover can be used to protect the primary database during the upgrade.
• E.SQL Apply on the local standby database must be stopped while the primary database is upgraded.
• F.The upgrade always requires downtown until the upgrade of the logical standby is completed.

You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. One Physical Standby Database
3. One Logical Standby Database
You 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 is written to disk on both the primary database and at least one standby database.
Which redo transport mode and which protection mode would you configure to meet these requirements?

• A.SYNC AFFIRM and Maximum Protection
• B.SYNC NOAFFIRM and Maximum Availability
• C.SYNC AFFIRM and Maximum Availability
• D.ASYNC and Maximum Performance
• E.SYNC NOAFFIRM and Maximum Protection

Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard? (Choose three.)

• A.It checks that supplemental logging is turned on if there is a logical standby database in the configuration.
• B.It verifies that parameter settings in the SPFILE or in memory or both, are consistent with the broker configuration properties for that database.
• C.It checks that the current data protection level is consistent with the broker's configured data protection mode.
• D.It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database.
• E.It modifies the database configurable parameters to match the values set for the broker configuration.

Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration Animals
Protection Mode: MaxAvailability
Databases:
dogs Primary database
dogsfs1 Far Sync
sheep Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
An attempt to enable fast-start failover raises an error:
DGMGRL> enable fast_start failover;
Error: ORA-16693: requirements not met for enabling fast-start failover Failed.
Identify two possible reasons for this error. (Choose two.)

• A.The RedoRoutes property is not set on Dogs.
• B.The FastStartFailoverTarget property is not set on Dogs.
• C.The RedoRoutes property is not set on DogsFS1.
• D.The LogXptMode property is set to ASYNC on Dogs.
• E.The FastStartFailoverTarget property is not set on Sheep.
• F.The FastStartFailoverTarget property is not set on DogsFS1.

You must design an Oracle Data Guard configuration for an OLTP database that meets these permanent requirements:
1. Data loss is not permitted.
2. Read-only applications should not connect to the primary database instance.
Additionally, there are these requirements, only one of which is ever done at any one time:
1. It should be possible to apply designated patches with a minimum amount of downtime.
2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. New application software releases should be tested against an exact and up-to-date replica of the primary database.
Which configuration meets these requirements with the fewest databases?

• A.a primary database with one logical and two physical standby databases
• B.a primary database with one physical standby database
• C.a primary database with two physical standby databases
• D.a primary database with one logical standby database
• E.a primary database with one logical and one physical standby database
• F.a primary database with three physical standby databases