快上网专注成都网站设计 成都网站制作 成都网站建设
成都网站建设公司服务热线:028-86922220

网站建设知识

十年网站开发经验 + 多家企业客户 + 靠谱的建站团队

量身定制 + 运营维护+专业推广+无忧售后,网站问题一站解决

maximumprotection转maximumavailability

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

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

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

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

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

  5. 1 row selected.

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

  8. STATUS
  9. ------------
  10. OPEN

  11. 1 row selected.

  12. Elapsed: 00:00:00.00
  13. 18:57:24 SYS @ slow >startup mount force;
  14. ORACLE instance started.

  15. Total System Global Area 521936896 bytes
  16. Fixed Size         2254824 bytes
  17. Variable Size         377489432 bytes
  18. Database Buffers     138412032 bytes
  19. Redo Buffers         3780608 bytes
  20. Database mounted.
  21. 18:57:44 SYS @ slow >select name,database_role,protection_mode from v$database;

  22. NAME     DATABASE_ROLE PROTECTION_MODE
  23. --------- ---------------- --------------------
  24. SLOW     PRIMARY     MAXIMUM PROTECTION

  25. 1 row selected.

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

  28. STATUS
  29. ------------
  30. MOUNTED

  31. 1 row selected.

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

  34. Database altered.

  35. Elapsed: 00:00:00.00
  36. 19:00:09 SYS @ slow >alter database open;

  37. Database altered.

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

  40. NAME     DATABASE_ROLE PROTECTION_MODE
  41. --------- ---------------- --------------------
  42. SLOW     PRIMARY     MAXIMUM AVAILABILITY

  43. 1 row selected.

  44. Elapsed: 00:00:00.00
  45. 19:01:20 SYS @ slow >

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

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

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

  5. 1 row selected.

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

  8. STATUS
  9. ------------
  10. OPEN

  11. 1 row selected.

  12. Elapsed: 00:00:00.00
  13. 18:56:45 SYS @ gotime >startup mount force;
  14. ORACLE instance started.

  15. Total System Global Area 521936896 bytes
  16. Fixed Size         2254824 bytes
  17. Variable Size         377489432 bytes
  18. Database Buffers     138412032 bytes
  19. Redo Buffers         3780608 bytes
  20. Database mounted.
  21. 18:57:07 SYS @ gotime >select name,database_role,protection_mode from v$database;

  22. NAME     DATABASE_ROLE PROTECTION_MODE
  23. --------- ---------------- --------------------
  24. SLOW     PHYSICAL STANDBY MAXIMUM AVAILABILITY

  25. 1 row selected.

  26. Elapsed: 00:00:00.04
  27. 19:02:08 SYS @ gotime >






分享名称:maximumprotection转maximumavailability
文章位置:http://6mz.cn/article/ghijpc.html

其他资讯