NEW QUESTION 1
You administer a Data Guard environment consisting of a primary and three physical standby databases.
One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing.
The standby database used for testing is occasionally converted into a snapshot standby database and then converted back to a physical standby.
The physical standby database is the only standby that is a mandatory destination The broker configuration operates in MAXIMUM PERFORMANCE mode.
Which ARCHIVELOG DELETION POLICY should be set. so that archive logs generated on the primary database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted form the primary as soon as it is safe to do so?

• A. CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY
• B. CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
• C. CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
• D. CONFIGURE ACHIVELOG DELETION POUCY TO SHIPPED TO STANDBY,
• E. CONFIGURE ACHIVELOG DELETION POLICY TO NONE;

Answer: B

NEW QUESTION 2
Which four are true about DGMGRL show command?

• A. It can be used to show properties of a pluggable standby database.
• B. it can be used to show properties of a pluggable primary database.
• C. it can be used to show instance-specific properties for a RAC database.
• D. it can be used to show properties of a far sync instance
• E. it can be used to show Fast Start Failover properties.
• F. It can be used to show properties of a primary container database.

Answer: ABEF

NEW QUESTION 3
Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

• A. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.
• B. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.
• C. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.
• D. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.
• E. Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog

Answer: DE

NEW QUESTION 4
You must use a physical standby database file to recover a data file on a primary database in a Data Guard environment.
Which three of these steps must be performed on the primary database after the file has been backed up using RMAN on the physical standby database?

• A. Connect to the primary database as the AUXILIARY.
• B. Catalog the data file copy for RMAN to use on the primary database for restore.
• C. Back up the data file as copy on the standby host to a location on the standby host.
• D. Switch to the data file copy using the RMAN SWITCH command.
• E. Back up the data file as copy on the standby host to a location on the primary host
• F. Connect to the primary database as the TARGET.

Answer: ABD

NEW QUESTION 5
Which three statements are true about snapshot standby databases?

• A. Snapshot standby databases may be used for rolling release upgrades.
• B. if datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
• C. Flashback logs are used to convert a snapshot standby database back into a physical standby database.
• D. a snapshot standby database can have Real-Time Query enabled
• E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

Answer: CE

NEW QUESTION 6
Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

• A. To start SQL apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.
• B. the LOCALJJSTERNER initialization parameter must be set to the listener used to register the primary database instance.
• C. To enable Reatime Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.
• D. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts.
• E. A TNS entry or entries enabling connectivity to standby database instance(s) must bedefined on the primary database host.

Answer: D

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

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

Answer: BDEF

NEW QUESTION 8
Examine the Data Guard configuration:


Configuration Status: SUCCESS Which two are true?

• A. The observer must run on host ol5.example com and is currently not running.
• B. The observer will reinstate Sheep automatically after a failover, if required.
• C. The observer will mark another standby database as the failover target if the original failover target becomes unavailable.
• D. The observer will detect if the primary database is unable to accept new connections
• E. The former primary database will not be reinstated automatically alter a failover.

Answer: BE

NEW QUESTION 9
Your Data Guard environment consists of these components and settings:
1. A primary database supporting an OLTP workload 2 A remote physical standby database
3. Real-time query is enabled
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability
Which two are true regarding the DelayMins Database Property for the standby database?

• A. it can only be enabled for a configuration in Maximum Performance mode.
• B. It allows user errors on the primary to be recovered by using the physical standby database.
• C. It enables you to bypass the default network timeout interval specified for the standby redo transport destination.
• D. it can only be enabled for a configuration in Maximum Availability mode.
• E. It allows logical corruptions on the primary to be recovered by using the physical standby database.
• F. It specifies a delay before the primary ships redo to the standby destination having DelayMins set.

Answer: BF

NEW QUESTION 10
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?

• A. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (pnma: physt2 SYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY
• B. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 ASYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima physt FASTSYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION
• C. EDIT DATABASE prima SET PROPERY REDOROUTES^' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNCfs1 SET PROPERTY REDORUOTES=' (prima physt ASYNC)'; EDITCONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
• D. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES= (LOCAL: fs1. FASTSYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima: physt2 ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

Answer: A

NEW QUESTION 11
Examine the Data Guard configuration:

Identify two possible reasons for this error.

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

Answer: AD

NEW QUESTION 12
Examine this query and its output:

Which are true?

• A. The observer is not connected to the database on which the query was executed.
• B. Cats is a bystander database.
• C. The observer is connected to the database on which the query was executed.
• D. The observer is currently running on o17.example com
• E. The observer is not running, but should run on o17 example.com.

Answer: A

NEW QUESTION 13
Which three statements are true about Far Sync instances?

• A. The Data Guard Broker must be used to deploy and manage Far Sync instances.
• B. They enable standby database to be configured at remote distances from the primary without impacting performance on the primary.
• C. A primary database can ship redo directly to multiple Far Sync instances.
• D. They use as spfile, a standby controlfile, and standby redo logs.
• E. They work with any protection level.

Answer: ABD

NEW QUESTION 14
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 three physical standby databases
• B. a primary database with one logical and two physical standby databases
• C. a primary database with one logical standby database
• D. a primary database with one logical and one physical standby database
• E. a primary database with two physical standby databases
• F. a primary database with one physical standby database

Answer: D

NEW QUESTION 15
Examine the Data Guard configuration: DGMGRL> show configuration Configuration-Animals
Protection Mode: MaxAvailability Databases:
Sheep- Primary database
Warning: ORA-16817: unsynchronized fast-start failover configuration Dogs - (*) Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Fast-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 Conditions Hearth Conditions: Corrupted Controlfile 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.

• A. Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.
• B. MOUNT DOGS and issue ''reinstate database dogs:" at the DGMGRL prompt while connected to Dogs.
• C. MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Sheep
• D. Open Dogs and let the broker reinstate Dogs automatically.

Answer: C

NEW QUESTION 16
Which two are true about the usage of DBMS_ROLLING?

• A. The leading group contains the original primary database.
• B. The trailing group contains the original primary database.
• C. The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process.
• D. At least one logical standby database must be part of the initial Data Guard configuration
• E. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.

Answer: DE

NEW QUESTION 17
Which three statements are true about snapshot standby databases?

• A. Snapshot standby databases may be used for rolling release upgrades.
• B. if datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
• C. Flashback logs are used to convert a snapshot standby database back into a physical standby database.
• D. a snapshot standby database can have Real-Time Query enabled
• E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

Answer: CE

NEW QUESTION 18
You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:

What is true concerning this configuration?

• A. The Close_by primary database instance forwards redo to the FSjnst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.
• B. The far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.
• C. The close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FSjnst Far Sync instance.
• D. The far sync instance will not forward redo to the Far_away physical standby because Fast-Stan: Failover is disabled
• E. The FSjnst Far Sync instance forwards redo to the Far_away physical standby only if the close_by primary database is not able to do so.

Answer: A

NEW QUESTION 19
......