최신Oracle Database 12c: Data Guard Administrator - 1Z0-066무료샘플문제
문제1
Which three are true about the use of the VALID_FOR clause of the LOG_ARCHIVE_DEST_N parameter, in determining whether archive logs should be written to a particular destination by a database in a Data Guard environment? (Choose three.)
Which three are true about the use of the VALID_FOR clause of the LOG_ARCHIVE_DEST_N parameter, in determining whether archive logs should be written to a particular destination by a database in a Data Guard environment? (Choose three.)
정답: A,B,C
문제2
Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled? (Choose three.)
Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled? (Choose three.)
정답: A,B,E
설명: (KoreaDumps 회원만 볼 수 있음)
문제3
Examine the Data Guard configuration:
DGMGRL> show configuration:
Configuration Animals
Protection Mode: MaxAvailability
Databases:
cats Primary database
dogs Physical standby database
sheep Logical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three will be true after a switchover to Dogs? (Choose three.)
Examine the Data Guard configuration:
DGMGRL> show configuration:
Configuration Animals
Protection Mode: MaxAvailability
Databases:
cats Primary database
dogs Physical standby database
sheep Logical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three will be true after a switchover to Dogs? (Choose three.)
정답: A,B,E
문제4
Examine the Data Guard configuration:
DGMGRL> show configuration verbose;
Configuration - Animals
Protection Mode: MaxPerformance
Databases:
cats - Primary database
dogs - (*) Physical standby database
sheep - Physical standby database
(*) Fast-Start Failover target
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout= '180'
ObserverReconnect= '10'
FastStartFailoverAutoReinstate= 'FALSE'
FastStartFailoverPmyShutdown= 'TRUE'
BystandersFollowRoleChange= 'none'
ObserverOverride = 'FALSE'
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: dogs
Observer: ol5.example.com
Lag Limit: 30 seconds
Shutdown Primary:TRUE
Auto-reinstate: FALSE
Observer Reconnect: 10 seconds
Observer Override: TRUE
Configuration Status:
SUCCESS
Which two are true? (Choose two.)
Examine the Data Guard configuration:
DGMGRL> show configuration verbose;
Configuration - Animals
Protection Mode: MaxPerformance
Databases:
cats - Primary database
dogs - (*) Physical standby database
sheep - Physical standby database
(*) Fast-Start Failover target
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout= '180'
ObserverReconnect= '10'
FastStartFailoverAutoReinstate= 'FALSE'
FastStartFailoverPmyShutdown= 'TRUE'
BystandersFollowRoleChange= 'none'
ObserverOverride = 'FALSE'
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: dogs
Observer: ol5.example.com
Lag Limit: 30 seconds
Shutdown Primary:TRUE
Auto-reinstate: FALSE
Observer Reconnect: 10 seconds
Observer Override: TRUE
Configuration Status:
SUCCESS
Which two are true? (Choose two.)
정답: D,E
설명: (KoreaDumps 회원만 볼 수 있음)
문제5
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
dogs - Primary database
sheep - (*) Physical standby database
cats - Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS
What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
dogs - Primary database
sheep - (*) Physical standby database
cats - Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS
What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?
정답: D
문제6
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: ol7.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
Health Conditions:
Corrupted ControlfileYES
Corrupted DictionaryYES
Inaccessible Logfile NO
Stuck ArchiverNO
Datafile OfflineYES
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.
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: ol7.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
Health Conditions:
Corrupted ControlfileYES
Corrupted DictionaryYES
Inaccessible Logfile NO
Stuck ArchiverNO
Datafile OfflineYES
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.
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)
문제7
The Oracle database 12c Observer is currently running on host1 and you wish to have it running on host2.
Examine this list of possible steps:
1) Stop the observer on host1.
2) Disable Fast-Start Failover.
3) Update the broker configuration with the new observer hostname.
4) Enable Fast-Start Failover.
5) Start the Observer on host2.
Which contains the minimum required steps to move the observer to host2?
The Oracle database 12c Observer is currently running on host1 and you wish to have it running on host2.
Examine this list of possible steps:
1) Stop the observer on host1.
2) Disable Fast-Start Failover.
3) Update the broker configuration with the new observer hostname.
4) Enable Fast-Start Failover.
5) Start the Observer on host2.
Which contains the minimum required steps to move the observer to host2?
정답: B
문제8
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
dogs - Primary database
cats - Physical standby database
sheep - Logical 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
Which three will be true after a successful failover to Sheep? (Choose three.)
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
dogs - Primary database
cats - Physical standby database
sheep - Logical 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
Which three will be true after a successful failover to Sheep? (Choose three.)
정답: B,C,D
문제9
Which four are true about DGMGRL show command? (Choose four.)
Which four are true about DGMGRL show command? (Choose four.)
정답: B,C,D,F
설명: (KoreaDumps 회원만 볼 수 있음)
문제10
Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.
Switchovers or failovers are possible due to testing or in case of a disaster.
Clients use local TNSNAMES.ORA files to define connection strings to the database instances.
Which three will prevent clients from connecting to the wrong database instances? (Choose three.)
Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.
Switchovers or failovers are possible due to testing or in case of a disaster.
Clients use local TNSNAMES.ORA files to define connection strings to the database instances.
Which three will prevent clients from connecting to the wrong database instances? (Choose three.)
정답: B,F,G
설명: (KoreaDumps 회원만 볼 수 있음)