11g 最大保護模式 standby database網路故障導致主庫當機

哎呀我的天吶發表於2015-06-12
模式Database
主庫：

點選(此處)摺疊或開啟

  1. [oracle@primary ~]$ sqlplus / as sysdba

  3. SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 12 10:04:03 2015

  5. Copyright (c) 1982, 2011, Oracle. All rights reserved.


  8. Connected to:
  9. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
  10. With the Partitioning, OLAP, Data Mining and Real Application Testing options

  12. SQL> select status from v$instance;

  14. STATUS
  15. ------------
  16. MOUNTED

  18. SQL> alter database open;
  19. alter database open
  20. *
  21. ERROR at line 1:
  22. ORA-03113: end-of-file on communication channel
  23. Process ID: 3896
  24. Session ID: 1 Serial number: 5
open不了

主備庫之間網路中斷，網路弄好後，重啟備庫並應用，其實備庫是不會被關閉的，這是我重啟的備庫。

點選(此處)摺疊或開啟

  1. [oracle@standby ~]$ sqlplus / as sysdba

  3. SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 12 10:03:50 2015

  5. Copyright (c) 1982, 2011, Oracle. All rights reserved.

  7. Connected to an idle instance.

  9. SQL> startup;
  10. ORACLE instance started.

  12. Total System Global Area 839282688 bytes
  13. Fixed Size         2233000 bytes
  14. Variable Size         520097112 bytes
  15. Database Buffers     314572800 bytes
  16. Redo Buffers         2379776 bytes
  17. Database mounted.
  18. Database opened.
  19. SQL>
  20. SQL> select protection_mode ,protection_level , open_mode from v$database;

  22. PROTECTION_MODE      PROTECTION_LEVEL      OPEN_MODE
  23. -------------------- -------------------- --------------------
  24. MAXIMUM PROTECTION   MAXIMUM PROTECTION    READ ONLY

  26. SQL> alter database recover managed standby database disconnect from session;

  28. Database altered.
然後主庫啟動這樣就好了

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29990276/viewspace-1696517/，如需轉載，請註明出處，否則將追究法律責任。

相關文章