ORACLE11GDataGuard role conversion
1. ORACLE login uard Role Switching
2. similarities and differences between the two methods
3. Perform the switchover operation on primary
3.1. Start switchover -- primary.
3.2 restart to mount
3.3. Check the current status.
4. Perform the switchover operation on the standby database to be converted
4.1 check whether switchover switching is supported
4.2. Convert to primary and use the following statement to convert standby to the primary role:
4.3. After the conversion is completed, open the new primary database.
5. Verify the new primary and the new standby operation.
6. troubleshooting
7. Convert the failover physical standby to the primary database
7.2 check whether the archive file is complete
7.3 start failover and execute it on standby.
7.4 switch the physical standby role to primary
7.5 Start a new primary database.
Role conversion is completed. The rest is the remedy (for the original primary database). Because the primary database is no longer part of the data guard configuration, we need to try to see if the original primary database can be restored, transform it into a new standbyServer. The specific operation methods can be divided into two categories: 2. Reconstruction 2. Backup recovery.