In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-09-21 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >
Share
Shulou(Shulou.com)06/02 Report--
Reasons for switching between master and slave libraries: 1. Switch: active switching by users; 2. Failover: forced switching when the master database fails; switch switching process: first master database and then backup master library 1. Check switchover_status:select database_role, switchover_status from vault database; if switchover_status is: to standby, then: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY otherwise use: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN; 2. Restart the database: shutdown immediate; startup nomount; 3. Prepare mount alter database mount standby database; for library 1. Apply redo:alter database recover managed standby database disconnect from session; 2. Check switchover_status:select database_role, switchover_status from vault database; if switchover_status is: to primary, then: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY otherwise use: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN; 3. Restart the database shutdown immediate; startup; failover master and standby library switch 1. Stop log application
Alter database recover managed standby database cancel
two。 Turn off standby log transfer
Alter database recover managed standby database finish force
3. Switch to primary
When alter database commit to switchover to primary with session shutdown; makes this step, if there is a gap, it will report an ORA-16139:Switchover: Media recovery required-standby not in limbo error. When doing testing, this problem will occur if you start the main database and then prepare the database, and do not wait for the completion of the transfer of the logs related to the standby database. Forced switching is required at this time.
Alter database activate physical standby database; 4. Restart the database to the open state
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
The market share of Chrome browser on the desktop has exceeded 70%, and users are complaining about
The world's first 2nm mobile chip: Samsung Exynos 2600 is ready for mass production.According to a r
A US federal judge has ruled that Google can keep its Chrome browser, but it will be prohibited from
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
About us Contact us Product review car news thenatureplanet
More Form oMedia: AutoTimes. Bestcoffee. SL News. Jarebook. Coffee Hunters. Sundaily. Modezone. NNB. Coffee. Game News. FrontStreet. GGAMEN
© 2024 shulou.com SLNews company. All rights reserved.