千家信息网

请输入关键字词

热门搜索排行

最新搜索排行

导航： 首页 > 数据库 >

maximum performance 转换 maximum protection

发表于：2025-11-13 作者：千家信息网编辑
千家信息网最后更新 2025年11月13日，这部分需要添加standby redo log，添加日志相关操作请参照与DG physical DB 转 snapshot DB第一部分，以下内容摘自physical DB 转 snapshot DB
千家信息网最后更新 2025年11月13日maximum performance 转换 maximum protection



这部分需要添加standby redo log，添加日志相关操作请参照与DG physical DB 转 snapshot DB第一部分，
以下内容摘自physical DB 转 snapshot DB第一部分

在备库设置快速恢复区，大小，路径，创建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. ----------------意思是提示备库没有创建standby redo log所以下面创建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

备库上依据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 >

打开主库，设置快速恢复区大小，路径，

  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

主库上依据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 ，下面备库也将跟着修改

    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


    备库没有设置spfile，是以pfile打开库的，所以创建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 >


    主库开始转换，成功的从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 >

    主库转换成功之后，备库的状态也随着改变了

    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操作，但是最后一步没有提交

    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并应用日志（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 >

    这个时候我们把备库的网络切断，然后再备库提交试试看...

    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

    14. TNS-12543: TNS:destination host unreachable
    15. ns secondary err code: 12560
    16. nt main err code: 513

    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


    最后我们去备库虚拟机的界面，进入后ifconfig eth0 up




    接着通过Xshell连接到备库的虚拟主机，查看状态恢复正常

    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



    很赞哦！
    路径 成功 信息 日志 大小 状态 第一部 主机 内容 后主 意思 方式 时候 模式 界面 网络 虚拟主机 跟着 传输 应用 数据库的安全要保护哪些东西 数据库安全各自的含义是什么 生产安全数据库录入 数据库的安全性及管理 数据库安全策略包含哪些 海淀数据库安全审计系统 建立农村房屋安全信息数据库 易用的数据库客户端支持安全管理 连接数据库失败ssl安全错误 数据库的锁怎样保障安全 海南雨点网络技术有限公司 广东省网络安全教育宣传周 apex匹配连接服务器超时 杭州智能互联网科技有限公司 银行软件开发部工作 计算机服务器可以放在小区么 沈阳尖峰软件开发骗局 网络安全政策利好 如何防范网络安全小知识 吉林棋牌游戏软件开发 杭州电脑软件开发亿连信 公安网的网络安全概述 传奇什么软件开发的 数据库控制电路 先学后付费的软件开发学校 关于保护青少年网络安全的法律 检测服务器维护工作 加强平台基础数据库建设 贝壳视频软件开发 邮箱服务器输入密码无效 庐江电话网络技术服务哪家好 学校如何引导大学生的网络安全 网络技术及信息数据费 检索国内博硕士学位论文数据库有 江西数据库安全审计系统 万卡显示服务器异常 本地请求服务器接口算跨域吗 个人服务器如何备案 一条街网络技术 微信数据是什么数据库文件夹

    相关文章

    0