exam questions

Exam 1z0-066 All Questions

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

Exam 1z0-066 topic 1 question 79 discussion

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

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:

SUCCESS -
Which three will be true after a switchover to Sheep?

  • A. Dogs will be an enabled logical standby database.
  • B. Sheep will be the primary database.
  • C. Cats will be a disabled physical standby database.
  • D. Dogs will be a disabled logical standby database.
  • E. Cats will be an enabled physical standby database.
Show Suggested Answer Hide Answer
Suggested Answer: ABE 🗳️
A switchover is a role reversal between the primary database and one of its standby databases. A switchover guarantees no data loss and is typically done for planned maintenance of the primary system. During a switchover, the primary database transitions to a standby role, and the standby database transitions to the primary role.
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28295/sofo.htm

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
Rockfics
1 year, 3 months ago
Selected Answer: ABC
Dog will be a logical standby enable Cat will be a standy logical disable After a switch over a logical, the primary take logical standby role and the others will be disabled.
upvoted 1 times
...
ScottL
1 year, 3 months ago
DGMGRL> show configuration; Configuration - DRSolution Protection Mode: MaxPerformance Members: boston - Primary database london - Physical standby database london2 - Logical standby database Fast-Start Failover: Disabled Configuration Status: SUCCESS (status updated 29 seconds ago) DGMGRL> switchover to london2; Performing switchover NOW, please wait... Switchover succeeded, new primary is "london2" DGMGRL> show configuration; Configuration - DRSolution Protection Mode: MaxPerformance Members: london2 - Primary database boston - Logical standby database london - Physical standby database (disabled) ORA-16795: the standby database needs to be re-created Fast-Start Failover: Disabled Configuration Status: SUCCESS (status updated 54 seconds ago)
upvoted 1 times
...
JESUSBB
1 year, 9 months ago
Answer: A, B and E
upvoted 1 times
...
Rogazan
3 years, 6 months ago
Correct ABC
upvoted 2 times
...
Kamaelk
5 years ago
C is wrong. Whereas a switchover to a logical standby database will invalidate and disable all of the physical and snapshot standby databases in the configuration. You will then need to reenable the physical standby databases from a backup of the new primary database before you can reenable them. https://docs.oracle.com/cd/B28359_01/server.111/b28295/sofo.htm#BCGIEFCF
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