真实的国产乱ⅩXXX66竹夫人,五月香六月婷婷激情综合,亚洲日本VA一区二区三区,亚洲精品一区二区三区麻豆

成都創(chuàng)新互聯(lián)網(wǎng)站制作重慶分公司

switchoverphysicalDB怎樣互換primaryDB

switchover physical DB怎樣互換primary DB，相信很多沒有經(jīng)驗的人對此束手無策，為此本文總結(jié)了問題出現(xiàn)的原因和解決方法，通過這篇文章希望你能解決這個問題。

成都創(chuàng)新互聯(lián)是一家集網(wǎng)站建設(shè),本溪企業(yè)網(wǎng)站建設(shè),本溪品牌網(wǎng)站建設(shè),網(wǎng)站定制,本溪網(wǎng)站建設(shè)報價,網(wǎng)絡(luò)營銷,網(wǎng)絡(luò)優(yōu)化,本溪網(wǎng)站推廣為一體的創(chuàng)新建站企業(yè)，幫助傳統(tǒng)企業(yè)提升企業(yè)形象加強企業(yè)競爭力?？沙浞譂M足這一群體相比中小企業(yè)更為豐富、高端、多元的互聯(lián)網(wǎng)需求。同時我們時刻保持專業(yè)、時尚、前沿，時刻以成就客戶成長自我，堅持不斷學(xué)習(xí)、思考、沉淀、凈化自己，讓我們?yōu)楦嗟钠髽I(yè)打造出實用型網(wǎng)站。

PS：這一些實驗是建立在我之前博客實驗的基礎(chǔ)上的

為什么要先alter 先切主庫  再切備庫，
因為如果先切備庫的話，那么主庫的一些日志可能備庫收不到，導(dǎo)致不一致的情況發(fā)生

先切主庫------>standby DB 切換之后主庫是斷開close的，重新open后查看其狀態(tài)

  1. 20:53:33 SYS @ slow >select name,database_role,protection_mode,switchover_status from v$database;

  3. NAME      DATABASE_ROLE    PROTECTION_MODE    SWITCHOVER_STATUS

  4. --------- ---------------- -------------------- --------------------

  5. SLOW     PRIMARY       MAXIMUM AVAILABILITY TO STANDBY

  7. 1 row selected.

  9. Elapsed: 00:00:00.00

  10. 20:55:15 SYS @ slow >edit

  11. Wrote file afiedt.buf

  13.   1* select username,sid,serial# from v$session where username is not null

  14. 20:55:24 SYS @ slow >r

  15.   1* select username,sid,serial# from v$session where username is not null

  17. USERNAME                  SID    SERIAL#

  18. ------------------------------ ---------- ----------

  19. SYS                    1       5

  21. 1 row selected.

  23. Elapsed: 00:00:00.01

  24. 20:55:25 SYS @ slow >r

  25.   1* select username,sid,serial# from v$session where username is not null

  27. USERNAME                  SID    SERIAL#

  28. ------------------------------ ---------- ----------

  29. SYS                    1       5

  30. SCOTT                       41      47

  32. 2 rows selected.

  34. Elapsed: 00:00:00.00

  35. 20:56:25 SYS @ slow >alter database commit to switchover to standby;

  37. Database altered.

  39. Elapsed: 00:00:01.89

  40. 20:57:05 SYS @ slow >select name,database_role,protection_mode,switchover_status from v$database;

  41. select name,database_role,protection_mode,switchover_status from v$database

  42. *

  43. ERROR at line 1:

  44. ORA-01034: ORACLE not available

  45. Process ID: 5713

  46. Session ID: 1 Serial number: 5

  49. Elapsed: 00:00:00.00

  50. 20:58:08 SYS @ slow >select status from v$instance;

  51. select status from v$instance

  52. *

  53. ERROR at line 1:

  54. ORA-01034: ORACLE not available

  55. Process ID: 5713

  56. Session ID: 1 Serial number: 5

  59. Elapsed: 00:00:00.00

  60. 20:58:46 SYS @ slow >startup

  61. ORACLE instance started.

  63. Total System Global Area  521936896 bytes

  64. Fixed Size            2254824 bytes

  65. Variable Size          377489432 bytes

  66. Database Buffers      138412032 bytes

  67. Redo Buffers            3780608 bytes

  68. Database mounted.

  69. Database opened.

  70. 21:07:19 SYS @ slow >select name,open_mode,database_role,protection_mode,switchover_status from v$database;

  72. NAME      OPEN_MODE           DATABASE_ROLE    PROTECTION_MODE      SWITCHOVER_STATUS

  73. --------- -------------------- ---------------- -------------------- --------------------

  74. SLOW      READ ONLY           PHYSICAL STANDBY MAXIMUM AVAILABILITY TO PRIMARY

  76. 1 row selected.

  78. Elapsed: 00:00:00.01

  79. 21:07:55 SYS @ slow >recover managed standby database disconnect;

  80. Media recovery complete.

  81. 21:08:35 SYS @ slow >select name,open_mode,database_role,protection_mode,switchover_status from v$database;

  83. NAME      OPEN_MODE           DATABASE_ROLE    PROTECTION_MODE      SWITCHOVER_STATUS

  84. --------- -------------------- ---------------- -------------------- --------------------

  85. SLOW      READ ONLY WITH APPLY PHYSICAL STANDBY MAXIMUM AVAILABILITY TO PRIMARY

  87. 1 row selected.

  89. Elapsed: 00:00:00.00

  90. 21:09:02 SYS @ slow >

再切換備庫----->primary DB  備庫mount狀態(tài)下操作  成功?。。?/p>

  1. 20:52:21 SYS @ gotime >select name,database_role,protection_mode,switchover_status from v$database;

  3. NAME      DATABASE_ROLE    PROTECTION_MODE    SWITCHOVER_STATUS

  4. --------- ---------------- -------------------- --------------------

  5. SLOW      PHYSICAL STANDBY MAXIMUM AVAILABILITY NOT ALLOWED

  7. 1 row selected.

  9. Elapsed: 00:00:00.01

  10. 20:53:12 SYS @ gotime >r

  11.   1* select name,database_role,protection_mode,switchover_status from v$database

  13. NAME      DATABASE_ROLE    PROTECTION_MODE    SWITCHOVER_STATUS

  14. --------- ---------------- -------------------- --------------------

  15. SLOW      PHYSICAL STANDBY MAXIMUM AVAILABILITY NOT ALLOWED

  17. 1 row selected.

  19. Elapsed: 00:00:00.00

  20. 20:59:16 SYS @ gotime >select username,sid from v$session where username is not null;

  22. USERNAME                  SID

  23. ------------------------------ ----------

  24. SYS                       24

  26. 1 row selected.

  28. Elapsed: 00:00:00.01

  29. 21:02:26 SYS @ gotime >alter database commit to switchover to primary with session shutdown;

  30. alter database commit to switchover to primary with session shutdown

  31. *

  32. ERROR at line 1:

  33. ORA-16139: media recovery required

  36. Elapsed: 00:00:00.01

  37. 21:03:18 SYS @ gotime >recover managed standby database disconnect;

  38. Media recovery complete.

  39. 21:03:51 SYS @ gotime >alter database commit to switchover to primary with session shutdown;

  41. Database altered.

  43. Elapsed: 00:00:02.04

  44. 21:05:00 SYS @ gotime >select name,database_role,protection_mode,switchover_status from v$database;

  46. NAME      DATABASE_ROLE    PROTECTION_MODE    SWITCHOVER_STATUS

  47. --------- ---------------- -------------------- --------------------

  48. SLOW     PRIMARY       MAXIMUM AVAILABILITY NOT ALLOWED

  50. 1 row selected.

  52. Elapsed: 00:00:00.01

  53. 21:05:12 SYS @ gotime >alter database open;

  55. Database altered.

  57. Elapsed: 00:00:00.58

  58. 21:05:45 SYS @ gotime >select name,database_role,protection_mode,switchover_status from v$database;

  60. NAME      DATABASE_ROLE    PROTECTION_MODE    SWITCHOVER_STATUS

  61. --------- ---------------- -------------------- --------------------

  62. SLOW     PRIMARY       MAXIMUM AVAILABILITY FAILED DESTINATION

  64. 1 row selected.

  66. Elapsed: 00:00:00.01

  67. 21:06:13 SYS @ gotime >


--------------------------------------但是，switchover_status是failed destination 狀態(tài)------------------------------------------

switchover之后的備庫slow，重新啟動listener

  1. [oracle@slow ~]$ lsnrctl stop

  3. LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 13-JAN-2018 21:31:12

  5. Copyright (c) 1991, 2013, Oracle. All rights reserved.

  7. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=slow)(PORT=1521)))

  8. TNS-12541: TNS:no listener

  9.  TNS-12560: TNS:protocol adapter error

  10.   TNS-00511: No listener

  11.    Linux Error: 111: Connection refused

  12. [oracle@slow ~]$ lsnrctl start

  14. LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 13-JAN-2018 21:31:20

  16. Copyright (c) 1991, 2013, Oracle. All rights reserved.

  18. Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

  20. TNSLSNR for Linux: Version 11.2.0.4.0 - Production

  21. System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

  22. Log messages written to /u01/app/oracle/diag/tnslsnr/slow/listener/alert/log.xml

  23. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=slow)(PORT=1521)))

  25. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=slow)(PORT=1521)))

  26. STATUS of the LISTENER

  27. ------------------------

  28. Alias                     LISTENER

  29. Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

  30. Start Date 13-JAN-2018 21:31:20

  31. Uptime                    0 days 0 hr. 0 min. 0 sec

  32. Trace Level off

  33. Security ON: Local OS Authentication

  34. SNMP OFF

  35. Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

  36. Listener Log File /u01/app/oracle/diag/tnslsnr/slow/listener/alert/log.xml

  37. Listening Endpoints Summary...

  38.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=slow)(PORT=1521)))

  39. The listener supports no services

  40. The command completed successfully

  41. [oracle@slow ~]$ lsnrctl status

  43. LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 13-JAN-2018 21:31:23

  45. Copyright (c) 1991, 2013, Oracle. All rights reserved.

  47. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=slow)(PORT=1521)))

  48. STATUS of the LISTENER

  49. ------------------------

  50. Alias                     LISTENER

  51. Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

  52. Start Date 13-JAN-2018 21:31:20

  53. Uptime                    0 days 0 hr. 0 min. 2 sec

  54. Trace Level off

  55. Security ON: Local OS Authentication

  56. SNMP OFF

  57. Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

  58. Listener Log File /u01/app/oracle/diag/tnslsnr/slow/listener/alert/log.xml

  59. Listening Endpoints Summary...

  60.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=slow)(PORT=1521)))

  61. The listener supports no services

  62. The command completed successfully

關(guān)閉slow備庫，再打開mount狀態(tài)

  1. 21:28:36 SYS @ slow >shutdown immediate;

  2. Database closed.

  3. Database dismounted.

  4. ORACLE instance shut down.

  5. 21:28:53 SYS @ slow >startup mount;

  6. ORACLE instance started.

  8. Total System Global Area  521936896 bytes

  9. Fixed Size            2254824 bytes

  10. Variable Size          377489432 bytes

  11. Database Buffers      138412032 bytes

  12. Redo Buffers            3780608 bytes

  13. Database mounted.

  14. 21:29:08 SYS @ slow >

等slow備庫重新啟動之后，狀態(tài)為ready了

  1. [oracle@slow ~]$ lsnrctl status

  3. LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 13-JAN-2018 21:32:05

  5. Copyright (c) 1991, 2013, Oracle. All rights reserved.

  7. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=slow)(PORT=1521)))

  8. STATUS of the LISTENER

  9. ------------------------

  10. Alias LISTENER

  11. Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production

  12. Start Date 13-JAN-2018 21:31:20

  13. Uptime 0 days 0 hr. 0 min. 44 sec

  14. Trace Level off

  15. Security ON: Local OS Authentication

  16. SNMP OFF

  17. Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

  18. Listener Log File /u01/app/oracle/diag/tnslsnr/slow/listener/alert/log.xml

  19. Listening Endpoints Summary...

  20.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=slow)(PORT=1521)))

  21. Services Summary...

  22. Service "slow" has 1 instance(s).

  23.   Instance "slow", status READY, has 1 handler(s) for this service...

  24. The command completed successfully

  25. [oracle@slow ~]$

現(xiàn)在的主庫gotime這邊重啟listener

  1. [grid@sink ~]$ lsnrctl stop

  3. LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 13-JAN-2018 21:31:41

  5. Copyright (c) 1991, 2013, Oracle. All rights reserved.

  7. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sink)(PORT=1521)))

  8. The command completed successfully

  9. [grid@sink ~]$ lsnrctl start

  11. LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 13-JAN-2018 21:31:46

  13. Copyright (c) 1991, 2013, Oracle. All rights reserved.

  15. Starting /u01/11.2.0/grid/bin/tnslsnr: please wait...

  17. TNSLSNR for Linux: Version 11.2.0.4.0 - Production

  18. System parameter file is /u01/11.2.0/grid/network/admin/listener.ora

  19. Log messages written to /u01/app/grid/diag/tnslsnr/sink/listener/alert/log.xml

  20. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sink)(PORT=1521)))

  22. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sink)(PORT=1521)))

  23. STATUS of the LISTENER

  24. ------------------------

  25. Alias                     LISTENER

  26. Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

  27. Start Date 13-JAN-2018 21:31:46

  28. Uptime                    0 days 0 hr. 0 min. 0 sec

  29. Trace Level off

  30. Security ON: Local OS Authentication

  31. SNMP OFF

  32. Listener Parameter File /u01/11.2.0/grid/network/admin/listener.ora

  33. Listener Log File /u01/app/grid/diag/tnslsnr/sink/listener/alert/log.xml

  34. Listening Endpoints Summary...

  35.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sink)(PORT=1521)))

  36. Services Summary...

  37. Service "gotime" has 1 instance(s).

  38.   Instance "gotime", status UNKNOWN, has 1 handler(s) for this service...

  39. The command completed successfully

  40. [grid@sink ~]$

gotime主庫重新啟動，到open

  1. 21:32:12 SYS @ gotime >startup force;

  2. ORACLE instance started.

  4. Total System Global Area  521936896 bytes

  5. Fixed Size            2254824 bytes

  6. Variable Size          377489432 bytes

  7. Database Buffers      138412032 bytes

  8. Redo Buffers            3780608 bytes

  9. Database mounted.

  10. Database opened.

  11. 21:32:35 SYS @ gotime >

switchover之后的備庫slow，查詢其狀態(tài)，not allowed，正常了?。?

  1. 21:29:08 SYS @ slow >recover managed standby database disconnect;

  2. Media recovery complete.

  3. 21:29:32 SYS @ slow >select name,open_mode,database_role,protection_mode,switchover_status from v$database;

  5. NAME      OPEN_MODE           DATABASE_ROLE    PROTECTION_MODE      SWITCHOVER_STATUS

  6. --------- -------------------- ---------------- -------------------- --------------------

  7. SLOW      MOUNTED           PHYSICAL STANDBY MAXIMUM AVAILABILITY NOT ALLOWED

  9. 1 row selected.

  11. Elapsed: 00:00:00.01

  12. 21:33:16 SYS @ slow >

在查詢狀態(tài)，為to standby了，正常了??！

  1. 21:32:35 SYS @ gotime >select name,open_mode,database_role,protection_mode,switchover_status from v$database

  2. 21:32:45   2 ;

  4. NAME      OPEN_MODE           DATABASE_ROLE    PROTECTION_MODE      SWITCHOVER_STATUS

  5. --------- -------------------- ---------------- -------------------- --------------------

  6. SLOW      READ WRITE     PRIMARY        MAXIMUM AVAILABILITY TO STANDBY

  8. 1 row selected.

  10. Elapsed: 00:00:00.02

  11. 21:32:47 SYS @ gotime >

看完上述內(nèi)容，你們掌握switchover physical DB怎樣互換primary DB的方法了嗎？如果還想學(xué)到更多技能或想了解更多相關(guān)內(nèi)容，歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道，感謝各位的閱讀！


本文標(biāo)題：switchoverphysicalDB怎樣互換primaryDB
文章地址：http://weahome.cn/article/gcssdj.html

其他資訊

在線咨詢

微信咨詢

電話咨詢

028-86922220（工作日）

18980820575（7×24）

提交需求

返回頂部