Valid 1Z0-066 Dumps For Oracle Exam

Try it Latest Dumps4it 1Z0-066 Braindumps. Get Full File: https://www.dumps4it.com/1z0-066-dumps.html (112 As Dumps)
Question No. 1
Examine the Data Guard configuration after an accidental switchover to Sheep:
DGMGRL> show configuration;
Configuration Animals
Protection Mode: MaxAvailability
Databases:
sheep Primary database
dogs Logical standby database
cats Physical standby database (disabled)
ORA-16795: the standby database needs to be re-created
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three will be true after a switchover to Dogs? (Choose three.)
Question No. 2
Examine the Fast-start configuration:
DGMGRL> show fast_start failover;
Fast-Start Failover: ENABLED
Threshold : 30 seconds
Target: sheep
Observer : ol7.example.com
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: (none)
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver YES
Datafile Offline YES
Oracle Error Conditions:
(none)
Which three are true? (Choose three.)
A: Stuck Archiver: YES
Archiver is unable to archive a redo log because the device is full or unavailable.
C: Observer : 017.example.com
E: The FastStartFailoverLagLimit configuration property is only used by the broker when enabling fast-start failover for configurations operating in maximum performance mode.
References:
https://docs.oracle.com/cd/E11882_01/server.112/e40771/sofo.htm#DGBKR330
Question No. 3
You edit the DGConnectIdentifier database property using the edit database set property DGMGRL command.
Which two are effects of this change? (Choose two.)
B: The DGConnectIdentifier configurable database property specifies the connection identifier the broker uses when making connections to a database.
The value of this property is specified in the SERVICE attribute of the LOG_ARCHIVE_DEST_n parameter when the broker configures redo transport services on the primary database.
A: The connect identifier for a database must allow all other databases in the configuration to reach it.
References:
https://docs.oracle.com/cd/E11882_01/server.112/e40771/dbpropref.htm#DGBKR870
Question No. 4
Examine this command executed on a physical standby database to transition it to a logical standby database:
SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY prodlgsby;
Which statement is true regarding the execution of this command?
Question No. 5
You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:
DGMGRL> SHOW CONFIGURATION
Configuration DRSolution
Protection Mode: MaxPerformance
Databases:
Close_by Primary database
FS_inst Far Sync
Far_away Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
What is true concerning this configuration?
An Oracle Data Guard far sync instance is a remote Oracle Data Guard destination that accepts redo from the primary database and then ships that redo to other members of the Oracle Data Guard configuration. A far sync instance manages a control file, receives redo into standby redo logs (SRLs), and archives those SRLs to local archived redo logs, but that is where the similarity with standbys ends. A far sync instance does not have user data files, cannot be opened for access, cannot run redo apply, and can never function in the primary role or be converted to any type of standby database.
References:
Question No. 6
Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when running an application as an ordinary Oracle user? (Choose three.)
B: For automatic block media recovery to work, a physical standby database must be in real-time query mode, which requires an Oracle Active Data Guard license.
D: A physical standby database operating in real-time query mode can be used to repair corrupt data blocks in a primary database.
C: If corruption occurs on the primary database, blockmedia recovery is performed automatically using a good copy of the block from the standby database and vice versa.
References:
https://ora600tom.wordpress.com/2013/09/07/abmr-automatic-block-media-recovery/
