exam questions

Exam 1z0-066 All Questions

View all questions & answers for the 1z0-066 exam

Exam 1z0-066 topic 1 question 24 discussion

Actual exam question from Oracle's 1z0-066
Question #: 24
Topic #: 1
[All 1z0-066 Questions]

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
Health Conditions:

Corrupted Controlfile YES -

Corrupted Dictionary 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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
The command REINSTATE DATABASE reinstates a database as a new standby database in the broker configuration for the current primary database.
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28295/dgmgrl.htm#BABDACIF

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
JorgeZG
1 year, 11 months ago
Correct Answer: C
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago