maximumprotection轉(zhuǎn)maximumavailability

PS：該實(shí)驗(yàn)建立在之前DG博客的基礎(chǔ)之上的

主庫(kù)之前的狀態(tài)，執(zhí)行轉(zhuǎn)換語(yǔ)句，主庫(kù)之后的狀態(tài)

創(chuàng)新互聯(lián)專(zhuān)業(yè)為企業(yè)提供銅梁網(wǎng)站建設(shè)、銅梁做網(wǎng)站、銅梁網(wǎng)站設(shè)計(jì)、銅梁網(wǎng)站制作等企業(yè)網(wǎng)站建設(shè)、網(wǎng)頁(yè)設(shè)計(jì)與制作、銅梁企業(yè)網(wǎng)站模板建站服務(wù)，10年銅梁做網(wǎng)站經(jīng)驗(yàn)，不只是建網(wǎng)站，更提供有價(jià)值的思路和整體網(wǎng)絡(luò)服務(wù)。

  1. 15:00:01 SYS @ slow >select name,database_role,protection_mode from v$database;

  3. NAME     DATABASE_ROLE PROTECTION_MODE
  4. --------- ---------------- --------------------
  5. SLOW     PRIMARY     MAXIMUM PROTECTION

  7. 1 row selected.

  9. Elapsed: 00:00:00.00
  10. 15:00:35 SYS @ slow >select status from v$instance;

  12. STATUS
  13. ------------
  14. OPEN

  16. 1 row selected.

  18. Elapsed: 00:00:00.00
  19. 18:57:24 SYS @ slow >startup mount force;
  20. ORACLE instance started.

  22. Total System Global Area 521936896 bytes
  23. Fixed Size         2254824 bytes
  24. Variable Size         377489432 bytes
  25. Database Buffers     138412032 bytes
  26. Redo Buffers         3780608 bytes
  27. Database mounted.
  28. 18:57:44 SYS @ slow >select name,database_role,protection_mode from v$database;

  30. NAME     DATABASE_ROLE PROTECTION_MODE
  31. --------- ---------------- --------------------
  32. SLOW     PRIMARY     MAXIMUM PROTECTION

  34. 1 row selected.

  36. Elapsed: 00:00:00.01
  37. 18:58:20 SYS @ slow >select status from v$instance;

  39. STATUS
  40. ------------
  41. MOUNTED

  43. 1 row selected.

  45. Elapsed: 00:00:00.01
  46. 18:58:39 SYS @ slow >alter database set standby database to maximize availability;

  48. Database altered.

  50. Elapsed: 00:00:00.00
  51. 19:00:09 SYS @ slow >alter database open;

  53. Database altered.

  55. Elapsed: 00:00:03.03
  56. 19:00:25 SYS @ slow >select name,database_role,protection_mode from v$database;

  58. NAME     DATABASE_ROLE PROTECTION_MODE
  59. --------- ---------------- --------------------
  60. SLOW     PRIMARY     MAXIMUM AVAILABILITY

  62. 1 row selected.

  64. Elapsed: 00:00:00.00
  65. 19:01:20 SYS @ slow >

備庫(kù)之前的狀態(tài)，主庫(kù)執(zhí)行轉(zhuǎn)換語(yǔ)句，備庫(kù)之后的狀態(tài)  ，，，一切正常，轉(zhuǎn)換成功?。?！

  1. 14:56:33 SYS @ gotime >select name,database_role,protection_mode from v$database;

  3. NAME     DATABASE_ROLE PROTECTION_MODE
  4. --------- ---------------- --------------------
  5. SLOW     PHYSICAL STANDBY MAXIMUM PROTECTION

  7. 1 row selected.

  9. Elapsed: 00:00:00.00
  10. 14:57:21 SYS @ gotime >select status from v$instance;

  12. STATUS
  13. ------------
  14. OPEN

  16. 1 row selected.

  18. Elapsed: 00:00:00.00
  19. 18:56:45 SYS @ gotime >startup mount force;
  20. ORACLE instance started.

  22. Total System Global Area 521936896 bytes
  23. Fixed Size         2254824 bytes
  24. Variable Size         377489432 bytes
  25. Database Buffers     138412032 bytes
  26. Redo Buffers         3780608 bytes
  27. Database mounted.
  28. 18:57:07 SYS @ gotime >select name,database_role,protection_mode from v$database;

  30. NAME     DATABASE_ROLE PROTECTION_MODE
  31. --------- ---------------- --------------------
  32. SLOW     PHYSICAL STANDBY MAXIMUM AVAILABILITY

  34. 1 row selected.

  36. Elapsed: 00:00:00.04
  37. 19:02:08 SYS @ gotime >





分享題目：maximumprotection轉(zhuǎn)maximumavailability
本文來(lái)源：http://muchs.cn/article32/ghijpc.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供品牌網(wǎng)站制作、網(wǎng)站設(shè)計(jì)公司、云服務(wù)器、App開(kāi)發(fā)、網(wǎng)站制作、微信公眾號(hào)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)

成都網(wǎng)頁(yè)設(shè)計(jì)公司