Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to switch oracle11g dataguard". In daily operation, I believe many people have doubts about how to switch oracle11g dataguard. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "how to switch oracle11g dataguard". Next, please follow the editor to study!

1. Check whether the main library meets the switching conditions

SQL > select switchover_status from vested database STANDBY SWITCHOVERVERVERTSTATUS Murto

Sometimes SESSION ACTIVE is displayed, indicating that there is currently an active session connection.

two。 Execute the following command to switch

SQL > alter database commit to switchover to physical standby;Database altered.

If the first step is to switch the condition view to display SESSION ACTIVE, then use the following command here

SQL > alter database commit to switchover to physical standby WITH SESSION SHUTDOWN

3. Shut down the database and restart to mount

SQL > shutdown immediate;ORA-01012: not logged onSQL > exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@oraclerac2 ~] $sqlplus "/ as sysdba" SQL*Plus: Release 11.2.0.4.0 Production on Wed Aug 1 17:45:33 2018Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL > startup mount;ORACLE instance started.Total System Global Area 2.1379E+10 bytesFixed Size 2262656 bytesVariable Size 2885683584 bytesDatabase Buffers 1.8455E+10 bytesRedo Buffers 36073472 bytesDatabase mounted.

4. Open it in Read Only mode

SQL > alter database open read only;Database altered.

5. Start Redo application mode

SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;Database altered.

6. View roles after switching

SQL > select database_role,switchover_status from vested database share database-- PHYSICAL STANDBY TO PRIMARY

7. The above operations are all completed by the original main library, and the following operations are completed in the original standby library.

8. Check whether Standby Database meets the switching criteria

SQL > select database_role,switchover_status from vested database share database-- PHYSICAL STANDBY TO PRIMARY

9. Execute the following command to switch

SQL > alter database commit to switchover to primary;Database altered.

10. Open the database

SQL > alter database open;Database altered.

11. View roles after switching

SQL > select database_role,switchover_status from vested database alter database role SWITCHOVER_STATUS---PRIMARY TO STANDBY at this point, the study on "how to switch oracle11g dataguard" is over, hoping to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.