11g physical standby

Follow-up to Physical standby vs logical standby from Oracle/Java/Others

Rolling upgrade:
You can do that.

Switchover:

The old primary db need to be shutdown.
You need to let your application use the standby before start. Can you open your physical standby in read-only mode

1. On primary:
SQL>SELECT SWITCHOVER_STATUS FROM V$DATABASE;

2. On primary:
SQL>ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

3. Shutdown and then mount former primary
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;

4 Verify that the switchover target is ready to be switched to the primary role.
SELECT SWITCHOVER_STATUS FROM V$DATABASE;

5. Switch the target physical standby database role to the primary role.
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;

6 Open the new primary database.
SQL> ALTER DATABASE OPEN;

7 Start Redo Apply on the new physical standby database.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

Hongfeng Sun : 30 Sep 2010 10:48 |  Tags: Oracle-Availability |  Comments (0) |  Report a problem