ORACLE11GDataGuard role conversion

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.