DG,备库端:ORA-00313 & ORA-00312 & ORA-27037 + REDO与STANDBY LOG的重建
今天在DG的备库端的数据库里看到了大量如题所示的错误,具体如下:[……]
Adamhuan's Data Center - 【逻辑驱动数据】
数据玩物、代码屋、1/0游戏:(零和博弈)/ 禅宗意志 / 规则战争 / 解放数据力量 / 技术的飞速发展并没有改变这个世界,因为,这个世界从没有变,它只是越来越趋近于它本来的模样。
今天在DG的备库端的数据库里看到了大量如题所示的错误,具体如下:[……]
我的测试环境中有个12c的DG出现了问题,主库端的ARCHIVE LOG一直无法传送到备库端。
主库端:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 |
suse-1:~ # su - oracle oracle@suse-1:~> sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 18 18:36:19 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> set linesize 400 SQL> col member for a65 SQL> select * from v$log order by group#; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- ---------- 1 1 97 209715200 512 1 YES INACTIVE 7379778 18-DEC-18 7383387 18-DEC-18 0 2 1 98 209715200 512 1 NO CURRENT 7383387 18-DEC-18 1.8447E+19 0 3 1 96 209715200 512 1 YES INACTIVE 7379737 18-DEC-18 7379778 18-DEC-18 0 SQL> SQL> select * from v$logfile order by group#; GROUP# STATUS TYPE MEMBER IS_ CON_ID ---------- ------- ------- ----------------------------------------------------------------- --- ---------- 1 ONLINE /oradata/orcl/redo01.log NO 0 2 ONLINE /oradata/orcl/redo02.log NO 0 3 ONLINE /oradata/orcl/redo03.log NO 0 4 STANDBY /oradata/orcl/stdby_logfile_1.log NO 0 5 STANDBY /oradata/orcl/stdby_logfile_2.log NO 0 6 STANDBY /oradata/orcl/stdby_logfile_3.log NO 0 6 rows selected. SQL> SQL> set linesize 400 SQL> col name for a65 SQL> select name,thread#,sequence#,to_char(first_time,'yyyy-mm-dd hh24:mi:ss') "First",to_char(next_time,'yyyy-mm-dd hh24:mi:ss') "Next",applied from v$archived_log order by sequence#; NAME THREAD# SEQUENCE# First Next APPLIED ----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- --------- /oradata/log_archive_dest_1/1_2_992771642.dbf 1 2 2018-11-21 10:05:10 2018-11-21 14:32:22 NO /oradata/log_archive_dest_1/1_3_992771642.dbf 1 3 2018-11-21 14:32:22 2018-11-21 14:47:31 NO /oradata/log_archive_dest_1/1_4_992771642.dbf 1 4 2018-11-21 14:47:31 2018-11-21 16:35:31 NO /oradata/log_archive_dest_1/1_5_992771642.dbf 1 5 2018-11-21 16:35:31 2018-11-21 16:35:36 NO /oradata/log_archive_dest_1/1_6_992771642.dbf 1 6 2018-11-21 16:35:36 2018-11-21 17:10:06 NO orclstdby 1 6 2018-11-21 16:35:36 2018-11-21 17:10:06 YES /oradata/log_archive_dest_1/1_7_992771642.dbf 1 7 2018-11-21 17:10:06 2018-11-21 17:11:44 NO orclstdby 1 7 2018-11-21 17:10:06 2018-11-21 17:11:44 YES /oradata/log_archive_dest_1/1_8_992771642.dbf 1 8 2018-11-21 17:11:44 2018-11-21 17:41:53 NO orclstdby 1 8 2018-11-21 17:11:44 2018-11-21 17:41:53 YES /oradata/log_archive_dest_1/1_9_992771642.dbf 1 9 2018-11-21 17:41:53 2018-11-21 17:41:59 NO NAME THREAD# SEQUENCE# First Next APPLIED ----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- --------- orclstdby 1 9 2018-11-21 17:41:53 2018-11-21 17:41:59 YES /oradata/log_archive_dest_1/1_10_992771642.dbf 1 10 2018-11-21 17:41:59 2018-11-21 17:42:03 NO orclstdby 1 10 2018-11-21 17:41:59 2018-11-21 17:42:03 YES /oradata/log_archive_dest_1/1_11_992771642.dbf 1 11 2018-11-21 17:42:03 2018-11-21 17:50:20 NO orclstdby 1 11 2018-11-21 17:42:03 2018-11-21 17:50:20 YES /oradata/log_archive_dest_1/1_12_992771642.dbf 1 12 2018-11-21 17:50:20 2018-11-21 17:56:24 NO orclstdby 1 12 2018-11-21 17:50:20 2018-11-21 17:56:24 YES /oradata/log_archive_dest_1/1_13_992771642.dbf 1 13 2018-11-21 17:56:24 2018-11-21 17:56:26 NO orclstdby 1 13 2018-11-21 17:56:24 2018-11-21 17:56:26 YES orclstdby 1 14 2018-11-21 17:56:26 2018-11-21 17:56:32 YES /oradata/log_archive_dest_1/1_14_992771642.dbf 1 14 2018-11-21 17:56:26 2018-11-21 17:56:32 NO NAME THREAD# SEQUENCE# First Next APPLIED ----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- --------- /oradata/log_archive_dest_1/1_15_992771642.dbf 1 15 2018-11-21 17:56:32 2018-11-21 17:56:34 NO orclstdby 1 15 2018-11-21 17:56:32 2018-11-21 17:56:34 YES /oradata/log_archive_dest_1/1_16_992771642.dbf 1 16 2018-11-21 17:56:34 2018-11-21 17:56:50 NO orclstdby 1 16 2018-11-21 17:56:34 2018-11-21 17:56:50 YES /oradata/log_archive_dest_1/1_17_992771642.dbf 1 17 2018-11-21 17:56:50 2018-11-21 17:56:51 NO orclstdby 1 17 2018-11-21 17:56:50 2018-11-21 17:56:51 YES /oradata/log_archive_dest_1/1_18_992771642.dbf 1 18 2018-11-21 17:56:51 2018-11-21 17:56:58 NO orclstdby 1 18 2018-11-21 17:56:51 2018-11-21 17:56:58 YES /oradata/log_archive_dest_1/1_19_992771642.dbf 1 19 2018-11-21 17:56:58 2018-11-21 17:56:59 NO orclstdby 1 19 2018-11-21 17:56:58 2018-11-21 17:56:59 YES orclstdby 1 20 2018-11-21 17:56:59 2018-11-21 17:57:06 YES NAME THREAD# SEQUENCE# First Next APPLIED ----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- --------- /oradata/log_archive_dest_1/1_20_992771642.dbf 1 20 2018-11-21 17:56:59 2018-11-21 17:57:06 NO orclstdby 1 21 2018-11-21 17:57:06 2018-11-21 17:57:09 YES /oradata/log_archive_dest_1/1_21_992771642.dbf 1 21 2018-11-21 17:57:06 2018-11-21 17:57:09 NO orclstdby 1 22 2018-11-21 17:57:09 2018-11-21 23:38:50 YES /oradata/log_archive_dest_1/1_22_992771642.dbf 1 22 2018-11-21 17:57:09 2018-11-21 23:38:50 NO orclstdby 1 23 2018-11-21 23:38:50 2018-11-22 22:00:37 YES /oradata/log_archive_dest_1/1_23_992771642.dbf 1 23 2018-11-21 23:38:50 2018-11-22 22:00:37 NO orclstdby 1 24 2018-11-22 22:00:37 2018-11-23 07:32:26 YES /oradata/log_archive_dest_1/1_24_992771642.dbf 1 24 2018-11-22 22:00:37 2018-11-23 07:32:26 NO orclstdby 1 25 2018-11-23 07:32:26 2018-11-24 00:48:01 YES /oradata/log_archive_dest_1/1_25_992771642.dbf 1 25 2018-11-23 07:32:26 2018-11-24 00:48:01 NO NAME THREAD# SEQUENCE# First Next APPLIED ----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- --------- orclstdby 1 26 2018-11-24 00:48:01 2018-11-24 10:00:37 YES /oradata/log_archive_dest_1/1_26_992771642.dbf 1 26 2018-11-24 00:48:01 2018-11-24 10:00:37 NO orclstdby 1 27 2018-11-24 10:00:37 2018-11-24 15:20:30 YES /oradata/log_archive_dest_1/1_27_992771642.dbf 1 27 2018-11-24 10:00:37 2018-11-24 15:20:30 NO orclstdby 1 28 2018-11-24 15:20:30 2018-11-24 22:00:58 YES /oradata/log_archive_dest_1/1_28_992771642.dbf 1 28 2018-11-24 15:20:30 2018-11-24 22:00:58 NO orclstdby 1 29 2018-11-24 22:00:58 2018-11-25 07:23:33 YES /oradata/log_archive_dest_1/1_29_992771642.dbf 1 29 2018-11-24 22:00:58 2018-11-25 07:23:33 NO orclstdby 1 30 2018-11-25 07:23:33 2018-11-25 13:04:44 YES /oradata/log_archive_dest_1/1_30_992771642.dbf 1 30 2018-11-25 07:23:33 2018-11-25 13:04:44 NO orclstdby 1 31 2018-11-25 13:04:44 2018-11-25 19:25:37 YES NAME THREAD# SEQUENCE# First Next APPLIED ----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- --------- /oradata/log_archive_dest_1/1_31_992771642.dbf 1 31 2018-11-25 13:04:44 2018-11-25 19:25:37 NO /oradata/log_archive_dest_1/1_32_992771642.dbf 1 32 2018-11-25 19:25:37 2018-11-26 01:06:30 NO orclstdby 1 32 2018-11-25 19:25:37 2018-11-26 01:06:30 YES /oradata/log_archive_dest_1/1_33_992771642.dbf 1 33 2018-11-26 01:06:30 2018-11-26 23:10:21 NO orclstdby 1 33 2018-11-26 01:06:30 2018-11-26 23:10:21 YES /oradata/log_archive_dest_1/1_34_992771642.dbf 1 34 2018-11-26 23:10:21 2018-11-27 18:05:50 NO orclstdby 1 34 2018-11-26 23:10:21 2018-11-27 18:05:50 YES /oradata/log_archive_dest_1/1_35_992771642.dbf 1 35 2018-11-27 18:05:50 2018-11-28 03:00:48 NO orclstdby 1 35 2018-11-27 18:05:50 2018-11-28 03:00:48 YES /oradata/log_archive_dest_1/1_36_992771642.dbf 1 36 2018-11-28 03:00:48 2018-11-28 23:15:46 NO orclstdby 1 36 2018-11-28 03:00:48 2018-11-28 23:15:46 YES NAME THREAD# SEQUENCE# First Next APPLIED ----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- --------- /oradata/log_archive_dest_1/1_37_992771642.dbf 1 37 2018-11-28 23:15:46 2018-11-29 12:04:22 NO orclstdby 1 37 2018-11-28 23:15:46 2018-11-29 12:04:22 YES /oradata/log_archive_dest_1/1_38_992771642.dbf 1 38 2018-11-29 12:04:22 2018-11-30 02:00:39 NO orclstdby 1 38 2018-11-29 12:04:22 2018-11-30 02:00:39 YES /oradata/log_archive_dest_1/1_39_992771642.dbf 1 39 2018-11-30 02:00:39 2018-11-30 22:02:00 NO orclstdby 1 39 2018-11-30 02:00:39 2018-11-30 22:02:00 YES /oradata/log_archive_dest_1/1_40_992771642.dbf 1 40 2018-11-30 22:02:00 2018-12-01 07:04:05 NO orclstdby 1 40 2018-11-30 22:02:00 2018-12-01 07:04:05 YES /oradata/log_archive_dest_1/1_41_992771642.dbf 1 41 2018-12-01 07:04:05 2018-12-01 10:04:25 NO orclstdby 1 41 2018-12-01 07:04:05 2018-12-01 10:04:25 YES /oradata/log_archive_dest_1/1_42_992771642.dbf 1 42 2018-12-01 10:04:25 2018-12-01 17:01:01 NO NAME THREAD# SEQUENCE# First Next APPLIED ----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- --------- orclstdby 1 42 2018-12-01 10:04:25 2018-12-01 17:01:01 YES /oradata/log_archive_dest_1/1_43_992771642.dbf 1 43 2018-12-01 17:01:01 2018-12-02 00:00:03 NO orclstdby 1 43 2018-12-01 17:01:01 2018-12-02 00:00:03 YES /oradata/log_archive_dest_1/1_44_992771642.dbf 1 44 2018-12-02 00:00:03 2018-12-02 08:10:24 NO orclstdby 1 44 2018-12-02 00:00:03 2018-12-02 08:10:24 YES /oradata/log_archive_dest_1/1_45_992771642.dbf 1 45 2018-12-02 08:10:24 2018-12-02 12:07:49 NO /oradata/log_archive_dest_1/1_46_992771642.dbf 1 46 2018-12-02 12:07:49 2018-12-02 18:08:45 NO /oradata/log_archive_dest_1/1_47_992771642.dbf 1 47 2018-12-02 18:08:45 2018-12-03 01:43:45 NO /oradata/log_archive_dest_1/1_48_992771642.dbf 1 48 2018-12-03 01:43:45 2018-12-03 22:01:17 NO /oradata/log_archive_dest_1/1_49_992771642.dbf 1 49 2018-12-03 22:01:17 2018-12-04 08:12:01 NO /oradata/log_archive_dest_1/1_50_992771642.dbf 1 50 2018-12-04 08:12:01 2018-12-04 23:22:23 NO NAME THREAD# SEQUENCE# First Next APPLIED ----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- --------- /oradata/log_archive_dest_1/1_51_992771642.dbf 1 51 2018-12-04 23:22:23 2018-12-05 16:54:27 NO /oradata/log_archive_dest_1/1_52_992771642.dbf 1 52 2018-12-05 16:54:27 2018-12-06 04:00:15 NO /oradata/log_archive_dest_1/1_53_992771642.dbf 1 53 2018-12-06 04:00:15 2018-12-06 22:01:19 NO /oradata/log_archive_dest_1/1_54_992771642.dbf 1 54 2018-12-06 22:01:19 2018-12-07 09:00:34 NO /oradata/log_archive_dest_1/1_55_992771642.dbf 1 55 2018-12-07 09:00:34 2018-12-08 00:01:02 NO /oradata/log_archive_dest_1/1_56_992771642.dbf 1 56 2018-12-08 00:01:02 2018-12-08 08:24:10 NO /oradata/log_archive_dest_1/1_57_992771642.dbf 1 57 2018-12-08 08:24:10 2018-12-08 13:13:10 NO /oradata/log_archive_dest_1/1_58_992771642.dbf 1 58 2018-12-08 13:13:10 2018-12-08 20:00:40 NO /oradata/log_archive_dest_1/1_59_992771642.dbf 1 59 2018-12-08 20:00:40 2018-12-09 05:47:19 NO /oradata/log_archive_dest_1/1_60_992771642.dbf 1 60 2018-12-09 05:47:19 2018-12-09 08:34:31 NO /oradata/log_archive_dest_1/1_61_992771642.dbf 1 61 2018-12-09 08:34:31 2018-12-09 15:06:33 NO NAME THREAD# SEQUENCE# First Next APPLIED ----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- --------- /oradata/log_archive_dest_1/1_62_992771642.dbf 1 62 2018-12-09 15:06:33 2018-12-09 22:07:29 NO /oradata/log_archive_dest_1/1_63_992771642.dbf 1 63 2018-12-09 22:07:29 2018-12-10 11:00:35 NO /oradata/log_archive_dest_1/1_64_992771642.dbf 1 64 2018-12-10 11:00:35 2018-12-10 22:38:20 NO /oradata/log_archive_dest_1/1_65_992771642.dbf 1 65 2018-12-10 22:38:20 2018-12-11 13:21:00 NO /oradata/log_archive_dest_1/1_66_992771642.dbf 1 66 2018-12-11 13:21:00 2018-12-12 01:20:41 NO /oradata/log_archive_dest_1/1_67_992771642.dbf 1 67 2018-12-12 01:20:41 2018-12-12 22:01:35 NO /oradata/log_archive_dest_1/1_68_992771642.dbf 1 68 2018-12-12 22:01:35 2018-12-13 11:00:43 NO /oradata/log_archive_dest_1/1_69_992771642.dbf 1 69 2018-12-13 11:00:43 2018-12-13 17:22:00 NO orclstdby 1 69 2018-12-13 11:00:43 2018-12-13 17:22:00 NO /oradata/log_archive_dest_1/1_70_992771642.dbf 1 70 2018-12-13 17:22:00 2018-12-13 17:32:57 NO orclstdby 1 70 2018-12-13 17:22:00 2018-12-13 17:32:57 NO NAME THREAD# SEQUENCE# First Next APPLIED ----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- --------- /oradata/log_archive_dest_1/1_71_992771642.dbf 1 71 2018-12-13 17:32:57 2018-12-13 17:33:04 NO /oradata/log_archive_dest_1/1_72_992771642.dbf 1 72 2018-12-13 17:33:04 2018-12-13 17:33:06 NO /oradata/log_archive_dest_1/1_73_992771642.dbf 1 73 2018-12-13 17:33:06 2018-12-13 17:33:08 NO /oradata/log_archive_dest_1/1_74_992771642.dbf 1 74 2018-12-13 17:33:08 2018-12-13 17:33:36 NO /oradata/log_archive_dest_1/1_75_992771642.dbf 1 75 2018-12-13 17:33:36 2018-12-13 17:33:38 NO /oradata/log_archive_dest_1/1_76_992771642.dbf 1 76 2018-12-13 17:33:38 2018-12-13 17:33:39 NO /oradata/log_archive_dest_1/1_77_992771642.dbf 1 77 2018-12-13 17:33:39 2018-12-13 17:33:40 NO /oradata/log_archive_dest_1/1_78_992771642.dbf 1 78 2018-12-13 17:33:40 2018-12-13 17:33:41 NO /oradata/log_archive_dest_1/1_79_992771642.dbf 1 79 2018-12-13 17:33:41 2018-12-13 17:33:41 NO /oradata/log_archive_dest_1/1_80_992771642.dbf 1 80 2018-12-13 17:33:41 2018-12-13 17:33:42 NO /oradata/log_archive_dest_1/1_81_992771642.dbf 1 81 2018-12-13 17:33:42 2018-12-13 23:02:59 NO NAME THREAD# SEQUENCE# First Next APPLIED ----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- --------- /oradata/log_archive_dest_1/1_82_992771642.dbf 1 82 2018-12-13 23:02:59 2018-12-14 13:00:12 NO /oradata/log_archive_dest_1/1_83_992771642.dbf 1 83 2018-12-14 13:00:12 2018-12-14 23:05:45 NO /oradata/log_archive_dest_1/1_84_992771642.dbf 1 84 2018-12-14 23:05:45 2018-12-15 08:00:31 NO /oradata/log_archive_dest_1/1_85_992771642.dbf 1 85 2018-12-15 08:00:31 2018-12-15 13:57:25 NO /oradata/log_archive_dest_1/1_86_992771642.dbf 1 86 2018-12-15 13:57:25 2018-12-15 19:58:05 NO /oradata/log_archive_dest_1/1_87_992771642.dbf 1 87 2018-12-15 19:58:05 2018-12-15 22:28:50 NO /oradata/log_archive_dest_1/1_88_992771642.dbf 1 88 2018-12-15 22:28:50 2018-12-16 07:49:36 NO /oradata/log_archive_dest_1/1_89_992771642.dbf 1 89 2018-12-16 07:49:36 2018-12-16 14:10:36 NO /oradata/log_archive_dest_1/1_90_992771642.dbf 1 90 2018-12-16 14:10:36 2018-12-16 20:01:19 NO /oradata/log_archive_dest_1/1_91_992771642.dbf 1 91 2018-12-16 20:01:19 2018-12-16 23:01:44 NO /oradata/log_archive_dest_1/1_92_992771642.dbf 1 92 2018-12-16 23:01:44 2018-12-17 20:46:05 NO NAME THREAD# SEQUENCE# First Next APPLIED ----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- --------- /oradata/log_archive_dest_1/1_93_992771642.dbf 1 93 2018-12-17 20:46:05 2018-12-17 23:34:35 NO /oradata/log_archive_dest_1/1_94_992771642.dbf 1 94 2018-12-17 23:34:35 2018-12-18 17:10:47 NO /oradata/log_archive_dest_1/1_95_992771642.dbf 1 95 2018-12-18 17:10:47 2018-12-18 17:11:10 NO /oradata/log_archive_dest_1/1_96_992771642.dbf 1 96 2018-12-18 17:11:10 2018-12-18 17:11:30 NO /oradata/log_archive_dest_1/1_97_992771642.dbf 1 97 2018-12-18 17:11:30 2018-12-18 17:38:20 NO 137 rows selected. SQL> |
可以看到,主库端的SEQUENCE已经97了。
在看看备库端:
[crayon-608152a70ebff0[……]
在Oracle12c的DG环境中遇到了如题所示的错误。[……]
在利用RMAN增量还原DG备库的差异数据的时候,我遇到了如题所示的问题,具体如下:
1 2 3 4 5 6 7 8 9 10 11 |
RMAN> recover database noredo; Starting recover at 14-SEP-18 using channel ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 09/14/2018 11:05:41 RMAN-06094: datafile 463 must be restored RMAN> |
打开数据库,查看一下数据文件的状态:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
SQL> set linesize 400 SQL> col name for a50 SQL> SQL> select file#,name,bytes/1024/1024/1024 from v$datafile where file#>426; (过多的输出,... ) FILE# NAME BYTES/1024/1024/1024 ---------- -------------------------------------------------- -------------------- 460 /oracle/MY_INSTANCE/mydata14/zen_424/zen.424.data 30 461 /oracle/MY_INSTANCE/mydata14/zen_425/zen.425.data 30 462 /oracle/MY_INSTANCE/mydata14/zen_426/zen.426.data 30 463 /oracle/MY_INSTANCE/mydata10/zen_427/zen.427.data 0 464 /oracle/MY_INSTANCE/mydata10/zen_428/zen.428.data 0 465 /oracle/MY_INSTANCE/mydata11/zen_429/zen.429.data 0 39 rows selected. SQL> |
可以看到,463开始的文件的大小为[……]
前提:
1. 主库:Oracle RAC 10g
2. 备库:Oracle DB 10g 10205
主库:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
[root@rac2 ~]# su - grid [grid@rac2 ~]$ [grid@rac2 ~]$ crs_stat -t -v Name Type R/RA F/FT Target State Host ---------------------------------------------------------------------- ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1 ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1 ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1 ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1 ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1 ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2 ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2 ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2 ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2 ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2 ora.zona.db application 0/1 0/1 ONLINE ONLINE rac2 ora....a1.inst application 0/5 0/0 ONLINE ONLINE rac1 ora....a2.inst application 0/5 0/0 ONLINE ONLINE rac2 [grid@rac2 ~]$ [grid@rac2 ~]$ exit logout [root@rac2 ~]# su - oracle [oracle@rac2 ~]$ [oracle@rac2 ~]$ ps -ef | grep pmon oracle 3484 1 0 08:12 ? 00:00:00 asm_pmon_+ASM2 oracle 20559 20478 0 10:07 pts/4 00:00:00 grep pmon oracle 26556 1 0 09:05 ? 00:00:00 ora_pmon_zona2 [oracle@rac2 ~]$ [oracle@rac2 ~]$ env | grep SID ORACLE_SID=zona2 [oracle@rac2 ~]$ [oracle@rac2 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jul 3 10:07:52 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ zona2 OPEN SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options [oracle@rac2 ~]$ |
备库:
1 2 3 4 5 |
[oracle@standby-rac ~]$ sqlplus -V SQL*Plus: Release 10.2.0.5.0 - Production [oracle@standby-rac ~]$ |
一、基础配置检查:[……]