New Features for Administrators - Question 037

A switchover to a standby database differs from a failover to the standby in a number of ways.

What are two of the key differences that characterize a switchover? (Choose two.)

A. The operation is planned and causes no data loss.

B. The standby database must be running in a no data divergence mode.

C. The old primary database can take on the standby role and be available for a future switchover.

D. The primary and standby database must be using exactly the same release and patch level of Oracle9i.

E. Either the primary database's online or archived log files, but not necessarily both, must be available.

Answer: A, C

Explanation:

Switchover is planned operation and should not cause any data losses. During the switchover the old primary database can take on the standby role and be available for a future switchover.

Incorrect Answers

B: The standby database has not to run in a no data divergence mode.

D: It is not required that the primary and standby database must be using exactly the same release and patch level of Oracle9i.

E: Online and archived log files of the primary database need to be available for the standby database.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 51-74

Chapter 2: Availability Enhancements

Oracle 9i New Features, Robert Freeman, p. 86-99

Chapter 3: New Oracle9i Availability and Recoverability Features