Shulou(Shulou.com)06/02 Report--

Protection mode:

Maximum availability: transactions on the main database must be updated in the online redo or in a slave database before they can be submitted; if the network is interrupted, it will be automatically switched to the maximum performance mode; the network will be restored and then switched back.

Maximum performance: default mode. Protect data as much as possible without affecting the performance of the main library.

Maximum protection: transactions on the main database must be updated in the online redo and a standby database before they can be submitted; if the network is interrupted, the main database will stop working directly The master database cannot resume the upgrade switch until it can be connected to at least one standby library. You need to restart the master library: maximum performance-> maximum available-- > maximum protection view protection mode: select database_role, protection_mode, protection_level from vault database. Upgrade switching steps: 1. Prepare the library to stop the redo application: alter database recover managed standby database cancel; 2. Restart the main library: shutdown immediate; startup mount 3. Main library upgrade switch protection mode: alter database set standby database to maximize availability; (or alter database set standby database to maximize protection;) alter database open; 4. Slave database starts redo application: alter database recover managed standby database disconnect from session; downgrade switching step: 1. Prepare the library to stop the redo application: alter database recover managed standby database cancel; 2. The main library adjusts the protection mode: alter database set standby database to maximize performance; 3. Launch redo application from slave library: alter database recover managed standby database disconnect from session

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.