maximumprotection转maximumavailability

PS：该实验建立在之前DG博客的基础之上的

主库之前的状态，执行转换语句，主库之后的状态

创新互联专业为企业提供铜梁网站建设、铜梁做网站、铜梁网站设计、铜梁网站制作等企业网站建设、网页设计与制作、铜梁企业网站模板建站服务，10年铜梁做网站经验，不只是建网站，更提供有价值的思路和整体网络服务。

  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 >

备库之前的状态，主库执行转换语句，备库之后的状态  ，，，一切正常，转换成功！！！

  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转maximumavailability
本文来源：https://www.cdcxhl.com/article32/ghijpc.html

成都网站建设公司_创新互联，为您提供品牌网站制作、网站设计公司、云服务器、App开发、网站制作、微信公众号

广告

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联

猜你还喜欢下面的内容

成都网页设计公司

云服务器知识

行业网站建设