Monday, May 08, 2006

How? ALTER DATABASE SET STANDBY TO MAXIMIZE AVAILABILITY (on online database)

I created standby database (RAC <==> RAC) by use maximize performance protection mode.
but i want to change to maximize [AVAILABILITY|PROTECTION]. but don't want to shutdown primary database. So I send email for this concept to Oracle.

Below, that reply mail

In Oracle Database10g Release 1 (10.1.x.x) you must shut down all instances of the Primary RAC, mount one instance, do the ALTER DATABASE SET STANDBY TO MAXIMIZE AVAILABILITY; command, and then restart all primary RAC instances.

In Oracle Database10g Release 2 (10.2.x.x) you do not have to shut down any Primary RAC instance and you must execute the SQL command from an open instance and we will ensure that all other Primary RAC instances move up to Maximum Availability.

No comments: