ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > Oracle primary DB 到 snapshot DB第二部分

Oracle primary DB 到 snapshot DB第二部分

原创 Oracle 作者：大鲨鱼o0O 时间：2018-01-12 22:49:26 0 删除 编辑

确认备库dest1和dest2

  1. 17:02:29 SYS @ gotime >show parameter dest;

  3. NAME                 TYPE     VALUE
  4. ------------------------------------ ----------- ------------------------------
  5. audit_file_dest          string     /u01/app/oracle/admin/gotime/a
  6.                          dump
  7. background_dump_dest         string     /u01/app/oracle/diag/rdbms/got
  8.                          ime/gotime/trace
  9. core_dump_dest             string     /u01/app/oracle/diag/rdbms/got
  10.                          ime/gotime/cdump
  11. cursor_bind_capture_destination string     memory+disk
  12. db_create_file_dest         string
  13. db_create_online_log_dest_1     string
  14. db_create_online_log_dest_2     string
  15. db_create_online_log_dest_3     string

  17. NAME                 TYPE     VALUE
  18. ------------------------------------ ----------- ------------------------------
  19. db_create_online_log_dest_4     string
  20. db_create_online_log_dest_5     string
  21. db_recovery_file_dest         string     /dsk1/gotime_recover/
  22. db_recovery_file_dest_size     big integer 4G
  23. diagnostic_dest          string     /u01/app/oracle
  24. log_archive_dest         string
  25. log_archive_dest_1         string     LOCATION=/dsk1/arch_gotime/
  26.                          VALID_FOR=(ALL_LOGFILES,ALL_
  27.                          ROLES)
  28.                          DB_UNIQUE_NAME=gotime
  29. log_archive_dest_10         string

  31. NAME                 TYPE     VALUE
  32. ------------------------------------ ----------- ------------------------------
  33. log_archive_dest_11         string
  34. log_archive_dest_12         string
  35. log_archive_dest_13         string
  36. log_archive_dest_14         string
  37. log_archive_dest_15         string
  38. log_archive_dest_16         string
  39. log_archive_dest_17         string
  40. log_archive_dest_18         string
  41. log_archive_dest_19         string
  42. log_archive_dest_2         string     SERVICE=slow ASYNC
  43.                          VALID_FOR=(ONLINE_LOGFILES,P

  45. NAME                 TYPE     VALUE
  46. ------------------------------------ ----------- ------------------------------
  47.                          RIMARY_ROLE)
  48.                          DB_UNIQUE_NAME=slow
  49. log_archive_dest_20         string
  50. log_archive_dest_21         string
  51. log_archive_dest_22         string
  52. log_archive_dest_23         string
  53. log_archive_dest_24         string
  54. log_archive_dest_25         string
  55. log_archive_dest_26         string
  56. log_archive_dest_27         string
  57. log_archive_dest_28         string

  59. NAME                 TYPE     VALUE
  60. ------------------------------------ ----------- ------------------------------
  61. log_archive_dest_29         string
  62. log_archive_dest_3         string
  63. log_archive_dest_30         string
  64. log_archive_dest_31         string
  65. log_archive_dest_4         string
  66. log_archive_dest_5         string
  67. log_archive_dest_6         string
  68. log_archive_dest_7         string
  69. log_archive_dest_8         string
  70. log_archive_dest_9         string
  71. log_archive_dest_state_1     string     ENABLE

  73. NAME                 TYPE     VALUE
  74. ------------------------------------ ----------- ------------------------------
  75. log_archive_dest_state_10     string     enable
  76. log_archive_dest_state_11     string     enable
  77. log_archive_dest_state_12     string     enable
  78. log_archive_dest_state_13     string     enable
  79. log_archive_dest_state_14     string     enable
  80. log_archive_dest_state_15     string     enable
  81. log_archive_dest_state_16     string     enable
  82. log_archive_dest_state_17     string     enable
  83. log_archive_dest_state_18     string     enable
  84. log_archive_dest_state_19     string     enable
  85. log_archive_dest_state_2     string     ENABLE

  87. NAME                 TYPE     VALUE
  88. ------------------------------------ ----------- ------------------------------
  89. log_archive_dest_state_20     string     enable
  90. log_archive_dest_state_21     string     enable
  91. log_archive_dest_state_22     string     enable
  92. log_archive_dest_state_23     string     enable
  93. log_archive_dest_state_24     string     enable
  94. log_archive_dest_state_25     string     enable
  95. log_archive_dest_state_26     string     enable
  96. log_archive_dest_state_27     string     enable
  97. log_archive_dest_state_28     string     enable
  98. log_archive_dest_state_29     string     enable
  99. log_archive_dest_state_3     string     enable

  101. NAME                 TYPE     VALUE
  102. ------------------------------------ ----------- ------------------------------
  103. log_archive_dest_state_30     string     enable
  104. log_archive_dest_state_31     string     enable
  105. log_archive_dest_state_4     string     enable
  106. log_archive_dest_state_5     string     enable
  107. log_archive_dest_state_6     string     enable
  108. log_archive_dest_state_7     string     enable
  109. log_archive_dest_state_8     string     enable
  110. log_archive_dest_state_9     string     enable
  111. log_archive_duplex_dest      string
  112. log_archive_min_succeed_dest     integer     1
  113. standby_archive_dest         string     ?/dbs/arch

  115. NAME                 TYPE     VALUE
  116. ------------------------------------ ----------- ------------------------------
  117. user_dump_dest             string     /u01/app/oracle/diag/rdbms/got
  118.                          ime/gotime/trace
  119. 17:06:51 SYS @ gotime >

确认主库dest1和dest2

  1. 17:34:18 SYS @ slow >show parameter dest;

  3. NAME                 TYPE     VALUE
  4. ------------------------------------ ----------- ------------------------------
  5. audit_file_dest          string     /u01/app/oracle/admin/slow/adu
  6.                          mp
  7. background_dump_dest         string     /u01/app/oracle/diag/rdbms/slo
  8.                          w/slow/trace
  9. core_dump_dest             string     /u01/app/oracle/diag/rdbms/slo
  10.                          w/slow/cdump
  11. cursor_bind_capture_destination string     memory+disk
  12. db_create_file_dest         string
  13. db_create_online_log_dest_1     string
  14. db_create_online_log_dest_2     string
  15. db_create_online_log_dest_3     string

  17. NAME                 TYPE     VALUE
  18. ------------------------------------ ----------- ------------------------------
  19. db_create_online_log_dest_4     string
  20. db_create_online_log_dest_5     string
  21. db_recovery_file_dest         string
  22. db_recovery_file_dest_size     big integer 0
  23. diagnostic_dest          string     /u01/app/oracle
  24. log_archive_dest         string
  25. log_archive_dest_1         string     LOCATION=/dsk1/arch_slow/
  26.                          VALID_FOR=(ALL_LOGFILES,ALL_
  27.                          ROLES)
  28.                          DB_UNIQUE_NAME=slow
  29. log_archive_dest_10         string

  31. NAME                 TYPE     VALUE
  32. ------------------------------------ ----------- ------------------------------
  33. log_archive_dest_11         string
  34. log_archive_dest_12         string
  35. log_archive_dest_13         string
  36. log_archive_dest_14         string
  37. log_archive_dest_15         string
  38. log_archive_dest_16         string
  39. log_archive_dest_17         string
  40. log_archive_dest_18         string
  41. log_archive_dest_19         string
  42. log_archive_dest_2         string     SERVICE=gotime ASYNC
  43.                          VALID_FOR=(ONLINE_LOGFILES,P

  45. NAME                 TYPE     VALUE
  46. ------------------------------------ ----------- ------------------------------
  47.                          RIMARY_ROLE)
  48.                          DB_UNIQUE_NAME=gotime
  49. log_archive_dest_20         string
  50. log_archive_dest_21         string
  51. log_archive_dest_22         string
  52. log_archive_dest_23         string
  53. log_archive_dest_24         string
  54. log_archive_dest_25         string
  55. log_archive_dest_26         string
  56. log_archive_dest_27         string
  57. log_archive_dest_28         string

  59. NAME                 TYPE     VALUE
  60. ------------------------------------ ----------- ------------------------------
  61. log_archive_dest_29         string
  62. log_archive_dest_3         string
  63. log_archive_dest_30         string
  64. log_archive_dest_31         string
  65. log_archive_dest_4         string
  66. log_archive_dest_5         string
  67. log_archive_dest_6         string
  68. log_archive_dest_7         string
  69. log_archive_dest_8         string
  70. log_archive_dest_9         string
  71. log_archive_dest_state_1     string     ENABLE

  73. NAME                 TYPE     VALUE
  74. ------------------------------------ ----------- ------------------------------
  75. log_archive_dest_state_10     string     enable
  76. log_archive_dest_state_11     string     enable
  77. log_archive_dest_state_12     string     enable
  78. log_archive_dest_state_13     string     enable
  79. log_archive_dest_state_14     string     enable
  80. log_archive_dest_state_15     string     enable
  81. log_archive_dest_state_16     string     enable
  82. log_archive_dest_state_17     string     enable
  83. log_archive_dest_state_18     string     enable
  84. log_archive_dest_state_19     string     enable
  85. log_archive_dest_state_2     string     ENABLE

  87. NAME                 TYPE     VALUE
  88. ------------------------------------ ----------- ------------------------------
  89. log_archive_dest_state_20     string     enable
  90. log_archive_dest_state_21     string     enable
  91. log_archive_dest_state_22     string     enable
  92. log_archive_dest_state_23     string     enable
  93. log_archive_dest_state_24     string     enable
  94. log_archive_dest_state_25     string     enable
  95. log_archive_dest_state_26     string     enable
  96. log_archive_dest_state_27     string     enable
  97. log_archive_dest_state_28     string     enable
  98. log_archive_dest_state_29     string     enable
  99. log_archive_dest_state_3     string     enable

  101. NAME                 TYPE     VALUE
  102. ------------------------------------ ----------- ------------------------------
  103. log_archive_dest_state_30     string     enable
  104. log_archive_dest_state_31     string     enable
  105. log_archive_dest_state_4     string     enable
  106. log_archive_dest_state_5     string     enable
  107. log_archive_dest_state_6     string     enable
  108. log_archive_dest_state_7     string     enable
  109. log_archive_dest_state_8     string     enable
  110. log_archive_dest_state_9     string     enable
  111. log_archive_duplex_dest      string
  112. log_archive_min_succeed_dest     integer     1
  113. standby_archive_dest         string     ?/dbs/arch

  115. NAME                 TYPE     VALUE
  116. ------------------------------------ ----------- ------------------------------
  117. user_dump_dest             string     /u01/app/oracle/diag/rdbms/slo
  118.                          w/slow/trace

主库做一些DML操作，提交，并切换日志处罚ARCH归档日志

  1. 17:36:32 SYS @ slow >create table t2 as select * from scott.emp;

  3. Table created.

  5. Elapsed: 00:00:00.10
  6. 17:38:43 SYS @ slow >commit;

  8. Commit complete.

  10. Elapsed: 00:00:00.00
  11. 17:38:47 SYS @ slow >alter system switch logfile;

  13. System altered.

  15. Elapsed: 00:00:00.01
  16. 17:38:58 SYS @ slow >

查看备库的告警日志，是否接收到日志，此时已处罚RFS（remote file server）故主备连接没有问题

  1. RFS[1]: Assigned to RFS process 4339
  2. RFS[1]: Selected log 4 for thread 1 sequence 16 dbid 1147482511 branch 963616975
  3. Fri Jan 12 17:33:36 2018
  4. RFS[2]: Assigned to RFS process 4335
  5. RFS[2]: Opened log for thread 1 sequence 10 dbid 1147482511 branch 963616975
  6. Archived Log entry 1 added for thread 1 sequence 10 rlc 963616975 ID 0x4465718f dest 2:
  7. RFS[1]: Opened log for thread 1 sequence 12 dbid 1147482511 branch 963616975
  8. RFS[2]: Opened log for thread 1 sequence 13 dbid 1147482511 branch 963616975
  9. Fri Jan 12 17:33:36 2018
  10. Archived Log entry 2 added for thread 1 sequence 16 ID 0x4465718f dest 1:
  11. Fri Jan 12 17:33:36 2018
  12. RFS[3]: Assigned to RFS process 4343
  13. RFS[3]: Opened log for thread 1 sequence 11 dbid 1147482511 branch 963616975
  14. Archived Log entry 3 added for thread 1 sequence 13 rlc 963616975 ID 0x4465718f dest 2:
  15. RFS[2]: Opened log for thread 1 sequence 14 dbid 1147482511 branch 963616975
  16. Archived Log entry 4 added for thread 1 sequence 14 rlc 963616975 ID 0x4465718f dest 2:
  17. RFS[2]: Opened log for thread 1 sequence 15 dbid 1147482511 branch 963616975
  18. Archived Log entry 5 added for thread 1 sequence 15 rlc 963616975 ID 0x4465718f dest 2:
  19. Archived Log entry 6 added for thread 1 sequence 11 rlc 963616975 ID 0x4465718f dest 2:
我上一次搭建DG的时候主库是startup pfile=xxxx 所以隔天我来做主备互换的时候是startup，主备无法连接，折
腾一下午终于找出原因了，通过以上的一些验证证明没有问题之后我们继续下面的操作

执行此命令将备库开启到snapshot mode

  1. 17:42:10 SYS @ gotime >r
  2.   1* alter database convert to snapshot standby

  4. Database altered.

  6. Elapsed: 00:00:02.37

查看备库告警日志

  1. Created guaranteed restore point SNAPSHOT_STANDBY_REQUIRED_01/12/2018 17:42:11
  2. Killing 4 processes with pids 4406,4385,4389,4393 (all RFS) in order to disallow current and futions. Requested by OS process 3844
  3. Begin: Standby Redo Logfile archival
  4. End: Standby Redo Logfile archival
  5. RESETLOGS after incomplete recovery UNTIL CHANGE 336029
  6. Resetting resetlogs activation ID 1147498895 (0x4465718f)
  7. Online log /u01/app/oracle/oradata/gotime/redo01a.log: Thread 1 Group 1 was previously cleared
  8. Online log /u01/app/oracle/oradata/gotime/redo01b.log: Thread 1 Group 1 was previously cleared
  9. Online log /u01/app/oracle/oradata/gotime/redo02a.log: Thread 1 Group 2 was previously cleared
  10. Online log /u01/app/oracle/oradata/gotime/redo02b.log: Thread 1 Group 2 was previously cleared
  11. Online log /u01/app/oracle/oradata/gotime/redo03a.log: Thread 1 Group 3 was previously cleared
  12. Online log /u01/app/oracle/oradata/gotime/redo03b.log: Thread 1 Group 3 was previously cleared
  13. Standby became primary SCN: 336027
  14. Fri Jan 12 17:42:13 2018
  15. Setting recovery target incarnation to 2
  16. CONVERT TO SNAPSHOT STANDBY: Complete - Database mounted as snapshot standby
  17. Completed: alter database convert to snapshot standby
  18. Fri Jan 12 17:43:05 2018
  19. ARC1: Becoming the 'no SRL' ARCH

此时备库的 状态是mounted，我们下面可以将他转换成open read write 状态了

  1. 17:56:17 SYS @ gotime >select status from v$instance;

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

  7. 1 row selected.

  9. Elapsed: 00:00:00.00

现在可以以read write的方式打开备库了！！！因为转换成功了

  1. 17:56:25 SYS @ gotime >alter database open read write;

  3. Database altered.

  5. Elapsed: 00:00:01.01
  6. 17:58:12 SYS @ gotime >

查看转换后的database_role是snapshot standby ！！！

  1. 18:00:55 SYS @ gotime >select name,database_role,protection_mode,open_mode fromv$database;

  3. NAME     DATABASE_ROLE PROTECTION_MODE    OPEN_MODE
  4. --------- ---------------- -------------------- --------------------
  5. SLOW     SNAPSHOT STANDBY MAXIMUM PERFORMANCE    READ WRITE

  7. 1 row selected.

  9. Elapsed: 00:00:00.01
  10. 18:02:03 SYS @ gotime >

做一些DML操作，提交，好等备库回到snapshot DB之前做对比

  1. 18:00:30 SYS @ gotime >r
  2.   1* create table t2018 as select * from scott.emp

  4. Table created.

  6. Elapsed: 00:00:00.04
  7. 18:00:30 SYS @ gotime >select * from t2018;

  9.      EMPNO ENAME JOB     MGR HIREDATE     SAL COMM DEPTNO
  10. ---------- ---------- --------- ---------- --------- ---------- ---------- ----------
  11.       7369 SMITH CLERK     7902 17-DEC-80     800          20
  12.       7499 ALLEN SALESMAN     7698 20-FEB-81     1600 300     30
  13.       7521 WARD SALESMAN     7698 22-FEB-81     1250 500     30
  14.       7566 JONES MANAGER     7839 02-APR-81     2975          20
  15.       7654 MARTIN SALESMAN     7698 28-SEP-81     1250 1400     30
  16.       7698 BLAKE MANAGER     7839 01-MAY-81     2850          30
  17.       7782 CLARK MANAGER     7839 09-JUN-81     2450          10
  18.       7788 SCOTT ANALYST     7566 19-APR-87     3000          20
  19.       7839 KING PRESIDENT      17-NOV-81     5000          10
  20.       7844 TURNER SALESMAN     7698 08-SEP-81     1500      0     30
  21.       7876 ADAMS CLERK     7788 23-MAY-87     1100          20

  23.      EMPNO ENAME JOB     MGR HIREDATE     SAL COMM DEPTNO
  24. ---------- ---------- --------- ---------- --------- ---------- ---------- ----------
  25.       7900 JAMES CLERK     7698 03-DEC-81     950          30
  26.       7902 FORD ANALYST     7566 03-DEC-81     3000          20
  27.       7934 MILLER CLERK     7782 23-JAN-82     1300          10

  29. 14 rows selected.

  31. Elapsed: 00:00:00.00
  32. 18:00:42 SYS @ gotime >commit;

  34. Commit complete.

  36. Elapsed: 00:00:00.00
  37. 18:00:55 SYS @ gotime >

这时候刚才创建的standby redo log被使用了

  1. 18:02:03 SYS @ gotime >select group#,thread#,sequence#,archived,status from v$standby_log;

  3.     GROUP# THREAD# SEQUENCE# ARC STATUS
  4. ---------- ---------- ---------- --- ----------
  5.      4     1     22 YES ACTIVE
  6.      5     1     0 NO UNASSIGNED
  7.      6     0     0 YES UNASSIGNED
  8.      7     0     0 YES UNASSIGNED

  10. 4 rows selected.

  12. Elapsed: 00:00:00.00
  13. 18:03:39 SYS @ gotime >

主库做一些DML操作，提交，好等备库回到snapshot DB之前做对比

  1. 17:38:58 SYS @ slow >create table t2017 as select * from scott.dept;

  3. Table created.

  5. Elapsed: 00:00:00.06
  6. 18:08:04 SYS @ slow >select * from t2017;

  8.     DEPTNO DNAME     LOC
  9. ---------- -------------- -------------
  10.     10 ACCOUNTING     NEW YORK
  11.     20 RESEARCH     DALLAS
  12.     30 SALES     CHICAGO
  13.     40 OPERATIONS     BOSTON

  15. 4 rows selected.

  17. Elapsed: 00:00:00.01
  18. 18:08:13 SYS @ slow >commit;

  20. Commit complete.

  22. Elapsed: 00:00:00.00
  23. 18:08:19 SYS @ slow >alter system switch logfile;

  25. System altered.

  27. Elapsed: 00:00:00.01
  28. 18:10:28 SYS @ slow >

关闭备库，重新启动到mounted然后转换回physical standby DB

  1. 18:11:34 SYS @ gotime >shutdown immediate;
  2. Database closed.
  3. Database dismounted.
  4. ORACLE instance shut down.
  5. 18:12:42 SYS @ gotime >startup mount;
  6. ORACLE instance started.

  8. Total System Global Area 521936896 bytes
  9. Fixed Size         2254824 bytes
  10. Variable Size         377489432 bytes
  11. Database Buffers     138412032 bytes
  12. Redo Buffers         3780608 bytes
  13. Database mounted.
  14. 18:12:57 SYS @ gotime >alter database convert to physical standby;

  16. Database altered.

  18. Elapsed: 00:00:02.23
  19. 18:13:18 SYS @ gotime >

转换回physical standby DB告警日志的情况

  1. alter database convert to physical standby
  2. ALTER DATABASE CONVERT TO PHYSICAL STANDBY (gotime)
  3. Killing 3 processes with pids 4994,4998,5002 (all RFS) in order to disallow current and future RFS connections. Requested by OS process 4988
  4. Flashback Restore Start
  5. Flashback Restore Complete
  6. Drop guaranteed restore point 
  7. Stopping background process RVWR
  8. Deleted Oracle managed file/dsk1/gotime_recover/GOTIME/flashback/o1_mf_f5k0qmlb_.flb
  9. Deleted Oracle managed file/dsk1/gotime_recover/GOTIME/flashback/o1_mf_f5k0qoco_.flb
  10. Guaranteed restore point dropped
  11. Clearing standby activation ID 1149107987 (0x447dff13)
  12. The primary database controlfile was created using the
  13. 'MAXLOGFILES 10' clause.
  14. There is space for up to 7 standby redo logfiles
  15. Use the following SQL commands on the standby database to create
  16. standby redo logfiles that match the primary database:
  17. ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 104857600;
  18. ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 104857600;
  19. ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 104857600;
  20. ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 104857600;
  21. Shutting down archive processes
  22. Archiving is disabled
  23. Fri Jan 12 18:13:17 2018
  24. ARCH shutting down
  25. ARC3: Archival stopped
  26. Fri Jan 12 18:13:17 2018
  27. ARCH shutting down
  28. ARC2: Archival stopped
  29. Fri Jan 12 18:13:17 2018
  30. ARCH shutting down
  31. ARC1: Archival stopped
  32. Fri Jan 12 18:13:17 2018
  33. ARCH shutting down
  34. ARC0: Archival stopped
  35. Completed: alter database convert to physical standby

打开备库查看数据库模式role和状态

  1. 18:13:18 SYS @ gotime >select name,database_role,protection_mode,open_mode fromv$database; select name,database_role,protection_mode,open_mode from v$database
  2.                                                          *
  3. ERROR at line 1:
  4. ORA-01507: database not mounted


  7. Elapsed: 00:00:00.01
  8. 18:15:42 SYS @ gotime >select name,database_role,protection_mode,open_mode fromv$database;
  9. select name,database_role,protection_mode,open_mode from v$database
  10.                                                          *
  11. ERROR at line 1:
  12. ORA-01507: database not mounted


  15. Elapsed: 00:00:00.00
  16. 18:15:51 SYS @ gotime >recover managed standby database disconnect;
  17. ORA-01507: database not mounted


  20. 18:16:37 SYS @ gotime >select status from v$instance;

  22. STATUS
  23. ------------
  24. STARTED

  26. 1 row selected.

  28. Elapsed: 00:00:00.01
  29. 18:17:00 SYS @ gotime >alter database mount; 
  30. alter database mount
  31. *
  32. ERROR at line 1:
  33. ORA-00750: database has been previously mounted and dismounted


  36. Elapsed: 00:00:00.00
  37. 18:17:13 SYS @ gotime >startup mount;
  38. ORA-01081: cannot start already-running ORACLE - shut it down first
  39. 18:17:26 SYS @ gotime >shutdown immediate;
  40. ORA-01507: database not mounted


  43. ORACLE instance shut down.
  44. 18:18:58 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. 18:19:10 SYS @ gotime >select name,database_role,protection_mode,open_mode fromv$database;

  55. NAME     DATABASE_ROLE PROTECTION_MODE    OPEN_MODE
  56. --------- ---------------- -------------------- --------------------
  57. SLOW     PHYSICAL STANDBY MAXIMUM PERFORMANCE    MOUNTED

  59. 1 row selected.

  61. Elapsed: 00:00:00.02
  62. 18:19:17 SYS @ gotime >

重新恢复到physical DB之后，对积压的主库传过来的日志进行media recover 应用

  1. 18:19:17 SYS @ gotime >recover managed standby database disconnect;
  2. Media recovery complete.

此时备库告警日志信息

  1. MRP0 started with pid=27, OS id=5221 
  2. MRP0: Background Managed Standby Recovery process started (gotime)
  3. Serial Media Recovery started
  4. Managed Standby Recovery not using Real Time Apply
  5. Waiting for all non-current ORLs to be archived...
  6. All non-current ORLs have been archived.
  7. Clearing online redo logfile 1 /u01/app/oracle/oradata/gotime/redo01a.log
  8. Clearing online log 1 of thread 1 sequence number 25
  9. Completed: ALTER DATABASE RECOVER managed standby database disconnect 
  10. Clearing online redo logfile 1 complete
  11. Clearing online redo logfile 2 /u01/app/oracle/oradata/gotime/redo02a.log
  12. Clearing online log 2 of thread 1 sequence number 2
  13. Clearing online redo logfile 2 complete
  14. Clearing online redo logfile 3 /u01/app/oracle/oradata/gotime/redo03a.log
  15. Clearing online log 3 of thread 1 sequence number 24
  16. Fri Jan 12 18:21:56 2018
  17. Clearing online redo logfile 3 complete
  18. Media Recovery Log /dsk1/arch_gotime/1_21_963616975.arc
  19. Media Recovery Log /dsk1/arch_gotime/1_22_963616975.arc
  20. Media Recovery Log /dsk1/arch_gotime/1_23_963616975.arc
  21. Media Recovery Log /dsk1/arch_gotime/1_24_963616975.arc
  22. Media Recovery Waiting for thread 1 sequence 25 (in transit)

以只读的方式打开数据库，此时备库snapshot DB期间主库所做的操作都应用到备库了

  1. 18:21:51 SYS @ gotime >alter database open;
  2. alter database open
  3. *
  4. ERROR at line 1:
  5. ORA-10456: cannot open standby database; media recovery session may be in progress


  8. Elapsed: 00:00:00.00
  9. 18:24:11 SYS @ gotime >recover managed standby database cancel;
  10. Media recovery complete.
  11. 18:24:34 SYS @ gotime >alter database open ;

  13. Database altered.

  15. Elapsed: 00:00:00.28
  16. 18:24:41 SYS @ gotime >select name,database_role,protection_mode,open_mode fromv$database;

  18. NAME     DATABASE_ROLE PROTECTION_MODE    OPEN_MODE
  19. --------- ---------------- -------------------- --------------------
  20. SLOW     PHYSICAL STANDBY MAXIMUM PERFORMANCE    READ ONLY

  22. 1 row selected.

  24. Elapsed: 00:00:00.01
  25. 18:25:15 SYS @ gotime >

在备库上对比查询，t2017（主库DML）存在，t2018（备库DML）消失，snapshot DB转换成功！！！

  1. 18:25:15 SYS @ gotime >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.01
  13. 18:26:51 SYS @ gotime >select * from t2018;
  14. select * from t2018
  15.               *
  16. ERROR at line 1:
  17. ORA-00942: table or view does not exist


  20. Elapsed: 00:00:00.00
  21. 18:27:01 SYS @ gotime >
2017悄然逝去已成历史，我们无法改变，2018还像一张白纸，等我们认真填写，我那时候站在2019回望2018又会不会呆着遗憾呢，期待2018。。。
我做的所有改变只为我心中不变，应对变化的只有改变


来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31405474/viewspace-2150108/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： Oracle primary DB 到 snapshot DB 第一部分
下一篇： maximum performance 转换 maximum protection
请登录后发表评论 登录
全部评论
大鲨鱼o0O

注册时间：2016-10-26

  • 博文量
    32
  • 访问量
    32863

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593