Adamhuan's Data Center - 【逻辑驱动数据】
数据玩物、代码屋、1/0游戏：（零和博弈）/ 禅宗意志 / 规则战争 / 解放数据力量 / 技术的飞速发展并没有改变这个世界，因为，这个世界从没有变，它只是越来越趋近于它本来的模样。
在DG日常维护的时候，很可能会发生的情况是：
1. 主库端扩容了某个表空间，增加了数据文件
2. 备库端同步增加了该数据文件，结果导致了挂载点的空间紧张
对于这种情况，比较好的做法是：
正确配置convert参数。
注意：对convert参数的修改需要特别注意，否则后面会讲到一个关于数[……]
Adamhuan
今天在DG的备库端的数据库里看到了大量如题所示的错误，具体如下：[……]
Adamhuan
我的测试环境中有个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-62b852c6014dd9[……]
Adamhuan
在我的一个12c的DG的备库上，检查Alert日志的时候发现了如题所示的告警。
具体如下：
|
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 |
2018-12-18T17:40:21.746945+08:00 Media Recovery Waiting for thread 1 sequence 45 Fetching gap sequence in thread 1, gap sequence 45-68 2018-12-18T17:40:22.458591+08:00 Completed: alter database recover managed standby database disconnect from session 2018-12-18T17:42:18.403378+08:00 FAL[client]: Failed to request gap sequence GAP - thread 1 sequence 45-68 DBID 1520552370 branch 992771642 FAL[client]: All defined FAL servers have been attempted. ------------------------------------------------------------------------- Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter is defined to a value that's sufficiently large enough to maintain adequate log switch information to resolve archivelog gaps. ------------------------------------------------------------------------- （过多的输出，...） 2018-12-18T17:51:27.279736+08:00 Errors in file /u01/app/oracle/diag/rdbms/orclstdby/orcl/trace/orcl_m000_15625.trc: ORA-19815: WARNING: db_recovery_file_dest_size of 3145728000 bytes is 96.92% used, and has 96872960 remaining bytes available. 2018-12-18T17:51:27.280216+08:00 ************************************************************************ You have following choices to free up space from recovery area: 1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, then consider changing RMAN ARCHIVELOG DELETION POLICY. 2. Back up files to tertiary device such as tape using RMAN BACKUP RECOVERY AREA command. 3. Add disk space and increase db_recovery_file_dest_size parameter to reflect the new space. 4. Delete unnecessary files using RMAN DELETE command. If an operating system command was used to delete files, then use RMAN CROSSCHECK and DELETE EXPIRED commands. ************************************************************************ |
备库上查看下DB_RECOVERY的相关设置：
|
1 2 3 4 5 6 7 |
SQL> show parameter db_recovery NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /oradata/fast_recovery_area db_recovery_file_dest_size big integer 3000M SQL> |
文件系[……]
Adamhuan
在Oracle12c的DG环境中遇到了如题所示的错误。[……]
Adamhuan