New Features for Administrators - Question 013

The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role.

Choose the correct order of execution for the steps.

1. Shut down and start up the former primary instance without mounting the instance.

2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command.

3. Issue the ALTER DATABASE MOUNT STANDBY DATABASE command.

4. End read or update activity on the former primary and standby databases.

A. 1, 2, 3, 4

B. 3, 2, 4, 1

C. 4, 2, 1, 3

D. 4, 3, 2, 1

Answer: C

Explanation:

To switch from the primary database role to the standby database role you need to end to read or update activity on the former primary and standby databases, issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command, shut down and start up the former primary instance without mounting the instance, issue the ALTER DATABASE MOUNT STANDBY DATABASE command.

Incorrect Answers

A: First you need to end to read or update activity on the former primary and standby databases.

B: You need to issue the ALTER DATABASE MOUNT STANDBY DATABASE command after the former primary database have been switched to standby mode.

D: You need to switch the former primary database to standby mode and restart instance before you mount the former primary instance in standby mode.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 64-72

Chapter 2: Availability Enhancements

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

Chapter 3: New Oracle9i Availability and Recoverability Features