溫馨提示×

溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務(wù)條款》

maximum performance 轉(zhuǎn)換 maximum protection

發(fā)布時間：2020-08-07 11:54:29 來源：ITPUB博客 閱讀：214 作者：大鯊魚o0O 欄目：關(guān)系型數(shù)據(jù)庫



這部分需要添加standby redo log，添加日志相關(guān)操作請參照與DG physical DB 轉(zhuǎn) snapshot DB第一部分，
以下內(nèi)容摘自physical DB 轉(zhuǎn) snapshot DB第一部分

在備庫設(shè)置快速恢復(fù)區(qū)，大小，路徑，創(chuàng)建4組standby redo log

  1. [root@sink ~]# su - oracle
  2. [oracle@sink ~]$ echo $ORACLE_SID
  3. sink
  4. [oracle@sink ~]$ export ORACLE_SID=gotime
  5. [oracle@sink ~]$ echo $ORACLE_SID
  6. gotime
  7. [oracle@sink ~]$ !sql
  8. sqlplus / as sysdba
  9. SQL*Plus: Release 11.2.0.4.0 Production on Fri Jan 12 10:25:51 2018
  10. Copyright (c) 1982, 2013, Oracle. All rights reserved.
  11. Connected to:
  12. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  13. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  14. 10:25:51 SYS @ gotime >select status from v$instance;

  16. STATUS
  17. ------------
  18. MOUNTED

  20. 1 row selected.

  22. Elapsed: 00:00:00.01
  23. 10:26:03 SYS @ gotime >select name,database_role,protection_mode,open_mode from v$database;
  24. NAME     DATABASE_ROLE PROTECTION_MODE    OPEN_MODE
  25. --------- ---------------- -------------------- --------------------
  26. SLOW     PHYSICAL STANDBY MAXIMUM PERFORMANCE    MOUNTED
  27. 1 row selected.
  28. Elapsed: 00:00:00.02
  29. 10:26:54 SYS @ gotime >show parameter recover
  30. NAME                 TYPE     VALUE
  31. ------------------------------------ ----------- ------------------------------
  32. db_recovery_file_dest         string
  33. db_recovery_file_dest_size     big integer 0
  34. db_unrecoverable_scn_tracking     boolean     TRUE
  35. recovery_parallelism         integer     0
  36. 10:29:42 SYS @ gotime >recover managed standby database cancel;
  37. ORA-16136: Managed Standby Recovery not active
  38. 10:30:31 SYS @ gotime >alter system set db_recovery_file_dest_size=4g;
  39. System altered.
  40. Elapsed: 00:00:00.00
  41. 10:32:25 SYS @ gotime >edit
  42. Wrote file afiedt.buf
  43.   1* alter system set db_recovery_file_dest='/dsk1'
  44. 10:32:36 SYS @ gotime >r
  45.   1* alter system set db_recovery_file_dest='/dsk1'
  46. System altered.
  47. Elapsed: 00:00:00.00
  48. 10:32:37 SYS @ gotime >show parameter recover;
  49. NAME                 TYPE     VALUE
  50. ------------------------------------ ----------- ------------------------------
  51. db_recovery_file_dest         string     /dsk1
  52. db_recovery_file_dest_size     big integer 4G
  53. db_unrecoverable_scn_tracking     boolean     TRUE
  54. recovery_parallelism         integer     0
  55. 10:39:51 SYS @ gotime >edit
  56. Wrote file afiedt.buf
  57.   1* alter system set db_recovery_file_dest_size=6g
  58. 10:40:14 SYS @ gotime >r
  59.   1* alter system set db_recovery_file_dest_size=6g
  60. System altered.
  61. Elapsed: 00:00:00.00
  62. 10:40:15 SYS @ gotime >alter database convert to snapshot standby;
  63. alter database convert to snapshot standby
  64. *
  65. ERROR at line 1:
  66. ORA-38784: Cannot create restore point 'SNAPSHOT_STANDBY_REQUIRED_01/12/2018 10:40:26'.
  67. ORA-38788: More standby database recovery is needed
  68. Elapsed: 00:00:00.00
  69. ----------------意思是提示備庫沒有創(chuàng)建standby redo log所以下面創(chuàng)建4組-------------------
  70. 13:16:50 SYS @ gotime >alter system set db_recovery_file_dest_size=4g;
  71. System altered.
  72. Elapsed: 00:00:00.01
  73. 13:18:31 SYS @ gotime >edit
  74. Wrote file afiedt.buf
  75.   1* select group#,thread#,sequence#,archived,status from v$standby_log
  76. 13:18:55 SYS @ gotime >r
  77.   1* select group#,thread#,sequence#,archived,status from v$standby_log
  78. no rows selected
  79. Elapsed: 00:00:00.00
  80. 13:18:55 SYS @ gotime >select member from v$logfile;
  81. MEMBER
  82. ------------------------
  83. /u01/app/oracle/oradata/gotime/redo01a.log
  84. /u01/app/oracle/oradata/gotime/redo01b.log
  85. /u01/app/oracle/oradata/gotime/redo02a.log
  86. /u01/app/oracle/oradata/gotime/redo02b.log
  87. /u01/app/oracle/oradata/gotime/redo03a.log
  88. /u01/app/oracle/oradata/gotime/redo03b.log
  89. 6 rows selected.
  90. Elapsed: 00:00:00.01
 

備庫上依據(jù)redo log的路徑建立4組standby redo log

  1. 13:21:44 SYS @ gotime >edit
  2. Wrote file afiedt.buf
  3.   1 alter database add standby logfile group 4
  4.   2* ('/u01/app/oracle/oradata/gotime/&a') size 200m
  5. 13:22:33 SYS @ gotime >r
  6.   1 alter database add standby logfile group 4
  7.   2* ('/u01/app/oracle/oradata/gotime/&a') size 200m
  8. Enter value for a: standby04.log
  9. old 2: ('/u01/app/oracle/oradata/gotime/&a') size 200m
  10. new 2: ('/u01/app/oracle/oradata/gotime/standby04.log') size 200m
  11. Database altered.
  12. Elapsed: 00:00:01.74
  13. 13:23:02 SYS @ gotime >edit
  14. Wrote file afiedt.buf
  15.   1* alter database add standby logfile group 4
  16. 13:23:12 SYS @ gotime >edit
  17. Wrote file afiedt.buf
  18.   1* alter database add standby logfile group &a ('/u01/app/oracle/oradata/gotime/&b') size 200m
  19. 13:23:58 SYS @ gotime >r
  20.   1* alter database add standby logfile group &a ('/u01/app/oracle/oradata/gotime/&b') size 200m
  21. Enter value for a: 5
  22. Enter value for b: standby05.log
  23. old 1: alter database add standby logfile group &a ('/u01/app/oracle/oradata/gotime/&b')size 200m
  24. new 1: alter database add standby logfile group 5 ('/u01/app/oracle/oradata/gotime/standby05.log') size 200m
  25. Database altered.
  26. Elapsed: 00:00:02.02
  27. 13:24:16 SYS @ gotime >r
  28.   1* alter database add standby logfile group &a ('/u01/app/oracle/oradata/gotime/&b') size 200m
  29. Enter value for a: 6
  30. Enter value for b: standby06.log
  31. old 1: alter database add standby logfile group &a ('/u01/app/oracle/oradata/gotime/&b')size 200m
  32. new 1: alter database add standby logfile group 6 ('/u01/app/oracle/oradata/gotime/standby06.log') size 200m

  34. Database altered.

  36. Elapsed: 00:00:01.98
  37. 13:24:35 SYS @ gotime >r
  38.   1* alter database add standby logfile group &a ('/u01/app/oracle/oradata/gotime/&b') size 200m
  39. Enter value for a: 7
  40. Enter value for b: standby07.log
  41. old 1: alter database add standby logfile group &a ('/u01/app/oracle/oradata/gotime/&b')size 200m
  42. new 1: alter database add standby logfile group 7 ('/u01/app/oracle/oradata/gotime/standby07.log') size 200m

  44. Database altered.

  46. Elapsed: 00:00:01.69
  47. 13:24:50 SYS @ gotime >select group#,thread#,sequence#,archived,status from v$standby_log
  48. 13:25:15 2 ;

  50.     GROUP# THREAD# SEQUENCE# ARC STATUS
  51. ---------- ---------- ---------- --- ----------
  52.      4 0 0 YES UNASSIGNED
  53.      5 0 0 YES UNASSIGNED
  54.      6 0 0 YES UNASSIGNED
  55.      7 0 0 YES UNASSIGNED

  57. 4 rows selected.

  59. Elapsed: 00:00:00.00
  60. 13:25:16 SYS @ gotime >

打開主庫，設(shè)置快速恢復(fù)區(qū)大小，路徑，

  1. 10:24:42 SYS @ slow >startup
  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. 10:24:57 SYS @ slow >select name,database_role,protection_mode,open_mode from v$database;

  13. NAME     DATABASE_ROLE PROTECTION_MODE    OPEN_MODE
  14. --------- ---------------- -------------------- --------------------
  15. SLOW     PRIMARY     MAXIMUM PERFORMANCE    READ WRITE

  17. 1 row selected.

  19. Elapsed: 00:00:00.02
  20. 10:28:35 SYS @ slow >show parameter recover;

  22. NAME                 TYPE     VALUE
  23. ------------------------------------ ----------- ------------------------------
  24. db_recovery_file_dest         string
  25. db_recovery_file_dest_size     big integer 0
  26. db_unrecoverable_scn_tracking     boolean     TRUE
  27. recovery_parallelism         integer     0
  28. 10:37:21 SYS @ slow >alter system set db_recovery_file_dest_size=4g;

  30. System altered.

  32. Elapsed: 00:00:00.00
  33. 10:37:54 SYS @ slow >alter system set db_recovery_file_dest='/dsk1';

  35. System altered.

  37. Elapsed: 00:00:00.01
  38. 10:38:19 SYS @ slow >select member from v$logfile;

  40. MEMBER
  41. -----------------------------------------
  42. /u01/app/oracle/oradata/slow/redo01a.log
  43. /u01/app/oracle/oradata/slow/redo01b.log
  44. /u01/app/oracle/oradata/slow/redo02a.log
  45. /u01/app/oracle/oradata/slow/redo02b.log
  46. /u01/app/oracle/oradata/slow/redo03a.log
  47. /u01/app/oracle/oradata/slow/redo03b.log

  49. 6 rows selected.

  51. Elapsed: 00:00:00.01

主庫上依據(jù)redo log的路徑建立4組standby redo log

  1. 13:26:06 SYS @ slow >edit
  2. Wrote file afiedt.buf

  4.   1* alter database add standby logfile group &a ('/u01/app/oracle/oradata/slow/&b') size 200m
  5. 13:27:02 SYS @ slow >r
  6.   1* alter database add standby logfile group &a ('/u01/app/oracle/oradata/slow/&b') size 200m
  7. Enter value for a: 4
  8. Enter value for b: standby04.log
  9. old 1: alter database add standby logfile group &a ('/u01/app/oracle/oradata/slow/&b') size200m
  10. new 1: alter database add standby logfile group 4 ('/u01/app/oracle/oradata/slow/standby04.log') size 200m

  12. Database altered.

  14. Elapsed: 00:00:02.73
  15. 13:27:19 SYS @ slow >r
  16.   1* alter database add standby logfile group &a ('/u01/app/oracle/oradata/slow/&b') size 200m
  17. Enter value for a: 5 
  18. Enter value for b: standby05.log
  19. old 1: alter database add standby logfile group &a ('/u01/app/oracle/oradata/slow/&b') size200m
  20. new 1: alter database add standby logfile group 5 ('/u01/app/oracle/oradata/slow/standby05.log') size 200m

  22. Database altered.

  24. Elapsed: 00:00:03.50
  25. 13:27:44 SYS @ slow >r
  26.   1* alter database add standby logfile group &a ('/u01/app/oracle/oradata/slow/&b') size 200m
  27. Enter value for a: 6
  28. Enter value for b: standby06.log
  29. old 1: alter database add standby logfile group &a ('/u01/app/oracle/oradata/slow/&b') size200m
  30. new 1: alter database add standby logfile group 6 ('/u01/app/oracle/oradata/slow/standby06.log') size 200m

  32. Database altered.

  34. Elapsed: 00:00:02.04
  35. 13:28:03 SYS @ slow >r
  36.   1* alter database add standby logfile group &a ('/u01/app/oracle/oradata/slow/&b') size 200m
  37. Enter value for a: 7 
  38. Enter value for b: standby07.log
  39. old 1: alter database add standby logfile group &a ('/u01/app/oracle/oradata/slow/&b') size200m
  40. new 1: alter database add standby logfile group 7 ('/u01/app/oracle/oradata/slow/standby07.log') size 200m

  42. Database altered.

  44. Elapsed: 00:00:02.33
  45. 13:28:19 SYS @ slow >select group#,thread#,sequence#,archived,status from v$standby_log;

  47.     GROUP# THREAD# SEQUENCE# ARC STATUS
  48. ---------- ---------- ---------- --- ----------
  49.      4     0     0 YES UNASSIGNED
  50.      5     0     0 YES UNASSIGNED
  51.      6     0     0 YES UNASSIGNED
  52.      7     0     0 YES UNASSIGNED

  54. 4 rows selected.

  56. Elapsed: 00:00:00.00



主庫修改傳輸方式sync affirm ，下面?zhèn)鋷煲矊⒏薷?

  1. 13:55:51 SYS @ slow >r
  2.   1* alter system set log_archive_dest_2='SERVICE=gotime OPTIONAL LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=gotime' scope=spfile

  4. System altered.

  6. Elapsed: 00:00:00.00


備庫沒有設(shè)置spfile，是以pfile打開庫的，所以創(chuàng)建spifle，以spfile打開，才能修改

  1. 13:57:43 SYS @ gotime >edit
  2. Wrote file afiedt.buf

  4.   1* alter system set log_archive_dest_2='SERVICE=slow optional sync AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=slow' scope=spfile
  5. 13:58:01 SYS @ gotime >r
  6.   1* alter system set log_archive_dest_2='SERVICE=slow optional sync AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=slow' scope=spfile
  7. alter system set log_archive_dest_2='SERVICE=slow optional sync AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=slow' scope=spfile
  8. *
  9. ERROR at line 1:
  10. ORA-32001: write to SPFILE requested but no SPFILE is in use


  13. Elapsed: 00:00:00.00
  14. 13:58:02 SYS @ gotime >create pfile from spfile;
  15. create pfile from spfile
  16. *
  17. ERROR at line 1:
  18. ORA-01565: error in identifying file '?/dbs/spfile@.ora'
  19. ORA-27037: unable to obtain file status
  20. Linux-x86_64 Error: 2: No such file or directory
  21. Additional information: 3


  24. Elapsed: 00:00:00.00
  25. 13:59:06 SYS @ gotime >create spfile from pfile;

  27. File created.

  29. Elapsed: 00:00:00.02
  30. 14:00:45 SYS @ gotime >alter system set log_archive_dest_2='SERVICE=slow optional sync AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=slow' scope=spfile;
  31. alter system set log_archive_dest_2='SERVICE=slow optional sync AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=slow' scope=spfile
  32. *
  33. ERROR at line 1:
  34. ORA-32001: write to SPFILE requested but no SPFILE is in use


  37. Elapsed: 00:00:00.00
  38. 14:01:06 SYS @ gotime >shutdown immediate;
  39. ORA-01109: database not open


  42. Database dismounted.
  43. ORACLE instance shut down.
  44. 14:01:37 SYS @ gotime >startup mount;
  45. ORACLE instance started.

  47. Total System Global Area 521936896 bytes
  48. Fixed Size         2254824 bytes
  49. Variable Size         377489432 bytes
  50. Database Buffers     138412032 bytes
  51. Redo Buffers         3780608 bytes
  52. Database mounted.
  53. 14:01:57 SYS @ gotime >alter system set log_archive_dest_2='SERVICE=slow optional sync AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=slow' scope=spfile;

  55. System altered.

  57. Elapsed: 00:00:00.01
  58. 14:02:09 SYS @ gotime >


主庫開始轉(zhuǎn)換，成功的從maximum performance 到 maximum protection模式

  1. 13:55:52 SYS @ slow >startup mount 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. 14:09:15 SYS @ slow >select status from v$instance;

  12. STATUS
  13. ------------
  14. MOUNTED

  16. 1 row selected.

  18. Elapsed: 00:00:00.01
  19. 14:09:29 SYS @ slow >select name,database_role,protection_mode from v$database;

  21. NAME     DATABASE_ROLE PROTECTION_MODE
  22. --------- ---------------- --------------------
  23. SLOW     PRIMARY     MAXIMUM PERFORMANCE

  25. 1 row selected.

  27. Elapsed: 00:00:00.01
  28. 14:10:02 SYS @ slow >alter database set standby database to maximize protection;

  30. Database altered.

  32. Elapsed: 00:00:00.01
  33. 14:10:52 SYS @ slow >alter database open;

  35. Database altered.

  37. Elapsed: 00:00:03.83
  38. 14:11:20 SYS @ slow >select name,database_role,protection_mode from v$database;

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

  44. 1 row selected.

  46. Elapsed: 00:00:00.00
  47. 14:11:45 SYS @ slow >

主庫轉(zhuǎn)換成功之后，備庫的狀態(tài)也隨著改變了

  1. 14:14:09 SYS @ gotime >select status from v$instance;

  3. STATUS
  4. ------------
  5. MOUNTED

  7. 1 row selected.

  9. Elapsed: 00:00:00.01
  10. 14:14:38 SYS @ gotime >select name,database_role,protection_mode from v$database;

  12. NAME     DATABASE_ROLE PROTECTION_MODE
  13. --------- ---------------- --------------------
  14. SLOW     PHYSICAL STANDBY MAXIMUM PROTECTION

  16. 1 row selected.

  18. Elapsed: 00:00:00.00
  19. 14:15:03 SYS @ gotime >alter database open;

  21. Database altered.

  23. Elapsed: 00:00:00.41
  24. 14:15:10 SYS @ gotime >select name,database_role,protection_mode from v$database;

  26. NAME     DATABASE_ROLE PROTECTION_MODE
  27. --------- ---------------- --------------------
  28. SLOW     PHYSICAL STANDBY MAXIMUM PROTECTION

  30. 1 row selected.

  32. Elapsed: 00:00:00.01



主庫做一些DML操作，但是最后一步?jīng)]有提交

  1. 14:18:31 SYS @ slow >select * from t2017;

  3.     DEPTNO DNAME     LOC
  4. ---------- -------------- -------------
  5.     10 ACCOUNTING     NEW YORK
  6.     20 RESEARCH     DALLAS
  7.     30 SALES     CHICAGO
  8.     40 OPERATIONS     BOSTON

  10. 4 rows selected.

  12. Elapsed: 00:00:00.00
  13. 14:18:46 SYS @ slow >insert into t2017 select * from t2017;

  15. 4 rows created.

  17. Elapsed: 00:00:00.00
  18. 14:19:29 SYS @ slow >select * from t2017;

  20.     DEPTNO DNAME     LOC
  21. ---------- -------------- -------------
  22.     10 ACCOUNTING     NEW YORK
  23.     20 RESEARCH     DALLAS
  24.     30 SALES     CHICAGO
  25.     40 OPERATIONS     BOSTON
  26.     10 ACCOUNTING     NEW YORK
  27.     20 RESEARCH     DALLAS
  28.     30 SALES     CHICAGO
  29.     40 OPERATIONS     BOSTON

  31. 8 rows selected.

  33. Elapsed: 00:00:00.00
  34. 14:19:43 SYS @ slow >commit;

  36. Commit complete.

  38. Elapsed: 00:00:00.00
  39. 14:19:45 SYS @ slow >insert into t2017 select * from t2017;

  41. 8 rows created.

  43. Elapsed: 00:00:00.00
  44. 14:20:42 SYS @ slow >select * from t2017;

  46.     DEPTNO DNAME     LOC
  47. ---------- -------------- -------------
  48.     10 ACCOUNTING     NEW YORK
  49.     20 RESEARCH     DALLAS
  50.     30 SALES     CHICAGO
  51.     40 OPERATIONS     BOSTON
  52.     10 ACCOUNTING     NEW YORK
  53.     20 RESEARCH     DALLAS
  54.     30 SALES     CHICAGO
  55.     40 OPERATIONS     BOSTON
  56.     10 ACCOUNTING     NEW YORK
  57.     20 RESEARCH     DALLAS
  58.     30 SALES     CHICAGO

  60.     DEPTNO DNAME     LOC
  61. ---------- -------------- -------------
  62.     40 OPERATIONS     BOSTON
  63.     10 ACCOUNTING     NEW YORK
  64.     20 RESEARCH     DALLAS
  65.     30 SALES     CHICAGO
  66.     40 OPERATIONS     BOSTON

  68. 16 rows selected.

  70. Elapsed: 00:00:00.00
  71. 14:21:18 SYS @ slow >alter system switch logfile;

  73. System altered.

  75. Elapsed: 00:00:00.12
  76. 14:23:28 SYS @ slow >


備庫重新mount并應(yīng)用日志（media recover）查詢信息，查不到最后沒有提交的信息，正常！

  1. 14:23:38 SYS @ gotime >startup mount 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. 14:24:22 SYS @ gotime >recover managed standby database disconnect;
  11. Media recovery complete.
  12. 14:24:51 SYS @ gotime >select * from t2017;
  13. select * from t2017
  14.               *
  15. ERROR at line 1:
  16. ORA-01219: database not open: queries allowed on fixed tables/views only


  19. Elapsed: 00:00:00.00
  20. 14:25:07 SYS @ gotime >alter database open;
  21. alter database open
  22. *
  23. ERROR at line 1:
  24. ORA-10456: cannot open standby database; media recovery session may be in progress


  27. Elapsed: 00:00:00.00
  28. 14:25:18 SYS @ gotime >recover managed standby database cancel;
  29. Media recovery complete.
  30. 14:25:42 SYS @ gotime >alter database open;

  32. Database altered.

  34. Elapsed: 00:00:00.21
  35. 14:25:47 SYS @ gotime >select * from t2017;

  37.     DEPTNO DNAME     LOC
  38. ---------- -------------- -------------
  39.     10 ACCOUNTING     NEW YORK
  40.     20 RESEARCH     DALLAS
  41.     30 SALES     CHICAGO
  42.     40 OPERATIONS     BOSTON
  43.     10 ACCOUNTING     NEW YORK
  44.     20 RESEARCH     DALLAS
  45.     30 SALES     CHICAGO
  46.     40 OPERATIONS     BOSTON

  48. 8 rows selected.

  50. Elapsed: 00:00:00.01
  51. 14:25:57 SYS @ gotime >

這個時候我們把備庫的網(wǎng)絡(luò)切斷，然后再備庫提交試試看...

  1. [root@sink ~]# ifconfig
  2. eth0 Link encap:Ethernet HWaddr 08:00:27:03:A5:94
  3.           inet addr:192.168.10.6 Bcast:192.168.10.255 Mask:255.255.255.0
  4.           UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
  5.           RX packets:29770 errors:0 dropped:0 overruns:0 frame:0
  6.           TX packets:13633 errors:0 dropped:0 overruns:0 carrier:0
  7.           collisions:0 txqueuelen:1000
  8.           RX bytes:32088544 (30.6 MiB) TX bytes:1186858 (1.1 MiB)

  10. lo Link encap:Local Loopback
  11.           inet addr:127.0.0.1 Mask:255.0.0.0
  12.           UP LOOPBACK RUNNING MTU:16436 Metric:1
  13.           RX packets:4899 errors:0 dropped:0 overruns:0 frame:0
  14.           TX packets:4899 errors:0 dropped:0 overruns:0 carrier:0
  15.           collisions:0 txqueuelen:0
  16.           RX bytes:3552488 (3.3 MiB) TX bytes:3552488 (3.3 MiB)

  18. [root@sink ~]# ifconfig eth0 down

  20. Connection closed by foreign host.

  22. Disconnected from remote host(sink_root) at 14:26:42.

  24. Type `help


主庫探知備庫down，大約5~6分鐘之后主庫自己也選擇自殺了（shutdown abort）

  1. 14:26:28 SYS @ slow >commit;
  2. commit
  3. *
  4. ERROR at line 1:
  5. ORA-03113: end-of-file on communication channel
  6. Process ID: 4226
  7. Session ID: 1 Serial number: 5


  10. Elapsed: 00:05:22.15
  11. 14:31:54 SYS @ slow >select status from v$instance;
  12. ERROR:
  13. ORA-03114: not connected to ORACLE


  16. Elapsed: 00:00:00.00
  17. 14:34:54 SYS @ slow >


主庫最后的告警日志信息

  1. ***********************************************************************

  3. Fatal NI connect error 12543, connecting to:
  4.  (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sink)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=gotime)(CID=(PROGRAM=oracle)(HOST=slow)(USER=oracle))))

  6.   VERSION INFORMATION:
  7.     TNS for Linux: Version 11.2.0.4.0 - Production
  8.     TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
  9.   Time: 13-JAN-2018 14:31:54
  10.   Tracing not turned on.
  11.   Tns error struct:
  12.     ns main err code: 12543
  13.     
  14. TNS-12543: TNS:destination host unreachable
  15.     ns secondary err code: 12560
  16.     nt main err code: 513
  17.     
  18. TNS-00513: Destination host unreachable
  19.     nt secondary err code: 113
  20.     nt OS err code: 0
  21. Error 12543 received logging on to the standby
  22. Sat Jan 13 14:31:54 2018
  23. LGWR: Error 12543 attaching to RFS for reconnect
  24. Error 16198 for archive log file 3 to 'gotime'
  25. Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED
  26. LGWR: All standby destinations have failed
  27. ******************************************************
  28. WARNING: All standby database destinations have failed
  29. WARNING: Instance shutdown required to protect primary
  30. ******************************************************
  31. LGWR (ospid: 4180): terminating the instance due to error 16098
  32. Sat Jan 13 14:31:54 2018
  33. System state dump requested by (instance=1, osid=4180 (LGWR)), summary=[abnormal instance termination].
  34. System State dumped to trace file /u01/app/oracle/diag/rdbms/slow/slow/trace/slow_diag_4160_20180113143154.trc
  35. Dumping diagnostic data in directory=[cdmp_20180113143154], requested by (instance=1, osid=4180 (LGWR)), summary=[abnormal instance termination].
  36. Instance terminated by LGWR, pid = 4180


最后我們?nèi)鋷焯摂M機的界面，進入后ifconfig eth0 up
maximum performance 轉(zhuǎn)換 maximum protection



接著通過Xshell連接到備庫的虛擬主機，查看狀態(tài)恢復(fù)正常

  1. Connecting to 192.168.10.6:22...
  2. Connection established.
  3. To escape to local shell, press 'Ctrl+Alt+]'.

  5. Last login: Sat Jan 13 14:37:06 2018
  6. [root@sink ~]# su - oracle
  7. [oracle@sink ~]$ echo $ORACLE_SID
  8. sink
  9. [oracle@sink ~]$ export ORACLE_SID=gotime
  10. [oracle@sink ~]$ echo $ORACLE_SID
  11. gotime
  12. [oracle@sink ~]$ !sql
  13. sqlplus / as sysdba

  15. SQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 13 14:56:19 2018

  17. Copyright (c) 1982, 2013, Oracle. All rights reserved.


  20. Connected to:
  21. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  22. With the Partitioning, OLAP, Data Mining and Real Application Testing options

  24. 14:56:19 SYS @ gotime >select status from v$instance;

  26. STATUS
  27. ------------
  28. OPEN

  30. 1 row selected.

  32. Elapsed: 00:00:00.01
  33. 14:56:33 SYS @ gotime >select name,database_role,protection_mode from v$database;

  35. NAME     DATABASE_ROLE PROTECTION_MODE
  36. --------- ---------------- --------------------
  37. SLOW     PHYSICAL STANDBY MAXIMUM PROTECTION

  39. 1 row selected.

  41. Elapsed: 00:00:00.00
  42. 14:57:21 SYS @ gotime >

主庫再啟動到open，因為是自殺（shutdown abort）所以會比較就一點，好了，一切正常！成功！

  1. 14:34:54 SYS @ slow >select status form v$instance;
  2. ERROR:
  3. ORA-03114: not connected to ORACLE


  6. Elapsed: 00:00:00.00
  7. 14:58:55 SYS @ slow >startup
  8. ORA-24324: service handle not initialized
  9. ORA-01041: internal error. hostdef extension doesn't exist
  10. 14:58:59 SYS @ slow >exit
  11. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  12. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  13. [oracle@slow ~]$ !sql
  14. sqlplus '/as sysdba



向AI問一下細節(jié)

免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點不代表本網(wǎng)站立場，如果涉及侵權(quán)請聯(lián)系站長郵箱：is@yisu.com進行舉報，并提供相關(guān)證據(jù)，一經(jīng)查實，將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI
助
手