New Features for Administrators - Question 063

In a Data Guard switchover operation, which command must you execute on the database that is being switched from the standby to the primary role?

A. ALTER DATABASE MOUNT STANDBY DATABASE;

B. ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

C. ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL PRIMARY;

D. ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;

Answer: C

Explanation:

This command will switch the database from the standby to the primary role. This statement ensures that all redo log files have been received and that they have been applied up to the end-of-redo marker. It also converts the standby control file to the current control file.

Incorrect Answers

A: This command just mounts the database as a standby database.

B: This command backs up the control file.

D: This command closes the primary database, completes the archive task, inserts an end-of-redo marker, and backs up the current control file to the SQL session trace file for conversion to a standby control file.

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