11GR2 Oracle Data Guard Switchover Scenarios
This article explains Oracle 11G R2 Oracle Data Guard physical standby database switchover scenarios. We have explained already the setup of the physical standby database for Oracle 11G R2 Data Guard. Please click here for this article. Step 1:
|
1 2 3 4 5 6 7 |
SELECT OPEN_MODE FROM V$DATABASE; OPEN_MODE -------------------- READ ONLY |
Step 2:
|
1 |
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT; |
Step 3:
|
1 2 3 4 5 6 7 |
SELECT open_mode FROM V$DATABASE; OPEN_MODE -------------------- READ ONLY WITH APPLY |
Scenario 1: How to switch over the Primary database … 11GR2 Oracle Data Guard Switchover Scenarios