Choose the correct order of execution for the steps?

The list below display four step 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 database.
2.Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command.
3.Issue the ALTER DATABASE MOUNT STANDBY DATABASE comman.
4.End read or update activity on the former primary and standby database.

The list below display four step 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 database.
2.Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command.
3.Issue the ALTER DATABASE MOUNT STANDBY DATABASE comman.
4.End read or update activity on the former primary and standby database.

A.
1,2,3,4

B.
3,2,4,1

C.
4,2,1,3

D.
4,3,2,1

Explanation:
Stop read or update activity on the primary and standby databases. You must have exclusive database access before beginning a switchover. Ask users to log
off the primary and standby databases, or query the V$SESSION view to identify users that are connected to the databases and close all open sessions except the SQL*Plus session from which you are going to execute the switchover statement. Switch the primary database to the physical standby role. On the primary database (in New York), execute the following statement:
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY 2> WITH SESSION SHUTDOWN;
This statement does the following:
? Closes the primary database, terminating any active sessions ? Transmits any unarchived redo log files and applies them to the standby database ? Adds an end-of-redo marker to the header of the last log file being archived ? Creates a backup of the current control file
? Converts the current control file into a standby control file Shut down and start up the former primary instance, and mount the database.
Execute the following statement on the former primary database:
SQL> SHUTDOWN NORMAL;
SQL> STARTUP MOUNT;
Switch the original standby database to the primary role.
Issue the following SQL statement:
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
DATABASE;
REF.: Oracle(r) Data Guard Concepts and Administration 10g Release 2 (10.2), 12-39



Leave a Reply 0

Your email address will not be published. Required fields are marked *