Oracle RMAN无法删除归档一例

最新推荐文章于 2023-03-29 21:42:41 发布
最新推荐文章于 2023-03-29 21:42:41 发布
阅读量1.1k 收藏 2
点赞数
分类专栏： Oracle循序渐进 # Oracle案例 文章标签： oracle 无法删除归档 RMAN-08137 bug
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u010520724/article/details/112602196
版权

备注:
Oralce 11.2.0.4

文章目录

一.问题描述

因为空间不足导致无法归档，数据库hang住

Thu Jan 14 03:24:49 2021
ARC3: Error 19502 Closing archive log file '/oracle/ora11g/db/dbs/arch/1_74591_982339590.dbf'
Thu Jan 14 03:24:52 2021
ARC0: Error 19502 Closing archive log file '/oracle/ora11g/db/dbs/arch/1_74591_982339590.dbf'
ARC1: Error 19502 Closing archive log file '/oracle/ora11g/db/dbs/arch/1_74591_982339590.dbf'
ARC3: Error 19502 Closing archive log file '/oracle/ora11g/db/dbs/arch/1_74591_982339590.dbf'

二.解决方案

首先想到的是清理空间，不过由于早上上班在9:00左右才介入处理，而空间不足导致的归档报错从凌晨3点左右就开始的，清理的5G空间很快被归档日志给占用了。

好在此时数据盘用的是lvm，vg还剩余9G，此时增加了9G的空间

df -h
vgs
lvs
lvresize -l +9 /dev/mapper/vg_orcldb-lv_orcldb1
df -h
lvdisplay
resize2fs /dev/mapper/vg_orcldb-lv_orcldb1
df -h

2.1 清理归档日志

rman target /
delete noprompt archivelog all completed before 'sysdate-5';

结果报错:
RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process

RMAN> delete noprompt archivelog all completed before 'sysdate-5';

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6602 device type=DISK
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96128_982856478.dbf thread=1 sequence=96128
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96129_982856478.dbf thread=1 sequence=96129
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96130_982856478.dbf thread=1 sequence=96130
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96131_982856478.dbf thread=1 sequence=96131
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96132_982856478.dbf thread=1 sequence=96132
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96133_982856478.dbf thread=1 sequence=96133
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96134_982856478.dbf thread=1 sequence=96134
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96135_982856478.dbf thread=1 sequence=96135
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96136_982856478.dbf thread=1 sequence=96136
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96137_982856478.dbf thread=1 sequence=96137
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96138_982856478.dbf thread=1 sequence=96138
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96139_982856478.dbf thread=1 sequence=96139
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96140_982856478.dbf thread=1 sequence=96140
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96141_982856478.dbf thread=1 sequence=96141
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96142_982856478.dbf thread=1 sequence=96142
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96143_982856478.dbf thread=1 sequence=96143
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96144_982856478.dbf thread=1 sequence=96144
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96145_982856478.dbf thread=1 sequence=96145
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96146_982856478.dbf thread=1 sequence=96146
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96147_982856478.dbf thread=1 sequence=96147
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96148_982856478.dbf thread=1 sequence=96148
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96149_982856478.dbf thread=1 sequence=96149
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96150_982856478.dbf thread=1 sequence=96150
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96151_982856478.dbf thread=1 sequence=96151
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96152_982856478.dbf thread=1 sequence=96152
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96153_982856478.dbf thread=1 sequence=96153
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96154_982856478.dbf thread=1 sequence=96154
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96155_982856478.dbf thread=1 sequence=96155
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96156_982856478.dbf thread=1 sequence=96156
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96157_982856478.dbf thread=1 sequence=96157
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96158_982856478.dbf thread=1 sequence=96158
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96159_982856478.dbf thread=1 sequence=96159
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96160_982856478.dbf thread=1 sequence=96160
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96161_982856478.dbf thread=1 sequence=96161
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96162_982856478.dbf thread=1 sequence=96162
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96163_982856478.dbf thread=1 sequence=96163
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96164_982856478.dbf thread=1 sequence=96164
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96165_982856478.dbf thread=1 sequence=96165
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96166_982856478.dbf thread=1 sequence=96166
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96167_982856478.dbf thread=1 sequence=96167
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96168_982856478.dbf thread=1 sequence=96168
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96169_982856478.dbf thread=1 sequence=96169
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96170_982856478.dbf thread=1 sequence=96170
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96171_982856478.dbf thread=1 sequence=96171
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96172_982856478.dbf thread=1 sequence=96172
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96173_982856478.dbf thread=1 sequence=96173
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96174_982856478.dbf thread=1 sequence=96174
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96175_982856478.dbf thread=1 sequence=96175
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96176_982856478.dbf thread=1 sequence=96176
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96177_982856478.dbf thread=1 sequence=96177
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96178_982856478.dbf thread=1 sequence=96178
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96179_982856478.dbf thread=1 sequence=96179
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96180_982856478.dbf thread=1 sequence=96180
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96181_982856478.dbf thread=1 sequence=96181
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96182_982856478.dbf thread=1 sequence=96182
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96183_982856478.dbf thread=1 sequence=96183
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96184_982856478.dbf thread=1 sequence=96184
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96185_982856478.dbf thread=1 sequence=96185
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96186_982856478.dbf thread=1 sequence=96186
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96187_982856478.dbf thread=1 sequence=96187
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96188_982856478.dbf thread=1 sequence=96188
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96189_982856478.dbf thread=1 sequence=96189
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96190_982856478.dbf thread=1 sequence=96190
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96191_982856478.dbf thread=1 sequence=96191
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96192_982856478.dbf thread=1 sequence=96192
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96193_982856478.dbf thread=1 sequence=96193
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96194_982856478.dbf thread=1 sequence=96194
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96195_982856478.dbf thread=1 sequence=96195
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96196_982856478.dbf thread=1 sequence=96196
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96197_982856478.dbf thread=1 sequence=96197
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96198_982856478.dbf thread=1 sequence=96198
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96199_982856478.dbf thread=1 sequence=96199
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96200_982856478.dbf thread=1 sequence=96200
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96201_982856478.dbf thread=1 sequence=96201
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96202_982856478.dbf thread=1 sequence=96202
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96203_982856478.dbf thread=1 sequence=96203
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96204_982856478.dbf thread=1 sequence=96204
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96205_982856478.dbf thread=1 sequence=96205
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96206_982856478.dbf thread=1 sequence=96206
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96207_982856478.dbf thread=1 sequence=96207
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96208_982856478.dbf thread=1 sequence=96208
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96209_982856478.dbf thread=1 sequence=96209
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96210_982856478.dbf thread=1 sequence=96210
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96211_982856478.dbf thread=1 sequence=96211
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96212_982856478.dbf thread=1 sequence=96212
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96213_982856478.dbf thread=1 sequence=96213
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96214_982856478.dbf thread=1 sequence=96214
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96215_982856478.dbf thread=1 sequence=96215
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96216_982856478.dbf thread=1 sequence=96216
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96217_982856478.dbf thread=1 sequence=96217
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96218_982856478.dbf thread=1 sequence=96218
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96219_982856478.dbf thread=1 sequence=96219
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96220_982856478.dbf thread=1 sequence=96220
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96221_982856478.dbf thread=1 sequence=96221
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96222_982856478.dbf thread=1 sequence=96222
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96223_982856478.dbf thread=1 sequence=96223
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96224_982856478.dbf thread=1 sequence=96224
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96225_982856478.dbf thread=1 sequence=96225
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96226_982856478.dbf thread=1 sequence=96226
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96227_982856478.dbf thread=1 sequence=96227
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96228_982856478.dbf thread=1 sequence=96228
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96229_982856478.dbf thread=1 sequence=96229
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96230_982856478.dbf thread=1 sequence=96230
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96231_982856478.dbf thread=1 sequence=96231
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96232_982856478.dbf thread=1 sequence=96232
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96233_982856478.dbf thread=1 sequence=96233
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96234_982856478.dbf thread=1 sequence=96234
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96235_982856478.dbf thread=1 sequence=96235
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96236_982856478.dbf thread=1 sequence=96236
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96237_982856478.dbf thread=1 sequence=96237
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96238_982856478.dbf thread=1 sequence=96238
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96239_982856478.dbf thread=1 sequence=96239
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96240_982856478.dbf thread=1 sequence=96240
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96241_982856478.dbf thread=1 sequence=96241
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96242_982856478.dbf thread=1 sequence=96242
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96243_982856478.dbf thread=1 sequence=96243
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96244_982856478.dbf thread=1 sequence=96244
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96245_982856478.dbf thread=1 sequence=96245
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96246_982856478.dbf thread=1 sequence=96246
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96247_982856478.dbf thread=1 sequence=96247
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96248_982856478.dbf thread=1 sequence=96248
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96249_982856478.dbf thread=1 sequence=96249
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96250_982856478.dbf thread=1 sequence=96250
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96251_982856478.dbf thread=1 sequence=96251
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96252_982856478.dbf thread=1 sequence=96252
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96253_982856478.dbf thread=1 sequence=96253
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96254_982856478.dbf thread=1 sequence=96254
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96255_982856478.dbf thread=1 sequence=96255
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oracle/ora11g/db/dbs/arch/1_96256_982856478.dbf thread=1 sequence=96256

RMAN>

2.2 问题分析

之前这个库是有备库的，不过公司业务缩减，要求服务器降配，前两周的刚刚把备库下线了
主库log_archive_dest_state_2已经设置为defer，主库alert日志查看也没有往备库传日志了。
但是归档居然删不掉

alter system set log_archive_dest_state_2=defer scope=both;
SQL> 
SQL> show parameter  log_archive_dest_state_2;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_2             string      DEFER
log_archive_dest_state_20            string      enable
log_archive_dest_state_21            string      enable
log_archive_dest_state_22            string      enable
log_archive_dest_state_23            string      enable
log_archive_dest_state_24            string      enable
log_archive_dest_state_25            string      enable
log_archive_dest_state_26            string      enable
log_archive_dest_state_27            string      enable
log_archive_dest_state_28            string      enable
log_archive_dest_state_29            string      enable
SQL>

itpub上正确取消dataguard的步骤
复盘了下，此次总共涉及下线3个备库
有1个备库我是按照下面步骤来的，然后shutdown了备库，后面系统组的同事下线的。
另外2个备库只修改了主库的 log_archive_dest_state_2 参数，并未调整备库，所以Oracle默认备库还存在。
导致删除这2个备库的报错，最终未删除，归档日志将磁盘撑爆，数据库hang住

On Standby DB:
i) SQL>alter database recover managed standby database cancel;
ii) SQL> alter system set log_archive_dest_state_2=DEFER;

On Primary DB:

i) SQL> alter system set log_archive_dest_state_2=DEFER;

2.3 最终解决方案

RMAN> delete noprompt force archivelog all completed before ‘sysdate-5’;
此为11g的bug，需要在delete后加上force关键字，metalink上有记载

RMAN-08137 When deleting archivelogs even when Streams CAPTURE does not require them [ID 1079953.1]

In this Document
  Symptoms
  Changes
  Cause
  Solution
  References

Symptoms
Applies To: 11gR1-11gR2

RMAN is unable to delete archive logs from database even though they are not needed by CAPTURE process anymore.

Changes
 

Cause
In 11g, RMAN looks at MIN_REQUIRED_CAPTURE_CHANGE# in v$database and not at DBA_CAPTURE. By default this value is updated every 6 hours. So by default the value in v$database will be six hours behind the current value.

Solution
Since changing frequency of update to MIN_REQUIRED_CAPTURE_CHANGE# in v$database can not be controlled, following workaround can be used:

Archive log which are not needed by capture process can be deleted using:

delete noprompt force archivelog all completed before 'sysdate-10/1440';

参考：

1.https://blog.51cto.com/yangjunfeng/2132820

【Oracle】Oracle rman工具使用（真的细）
tttzzzqqq2018的博客
09-19 5653
Oracle RMAN（Recovery Manager）是Oracle数据库备份和恢复的官方工具，它提供的备份和恢复功能非常强大和可靠。RMAN可以备份整个数据库或特定表空间、数据文件、控制文件和归档日志，同时还可以进行增量备份和增量恢复。RMAN还提供了诸如备份验证、备份优化、备份复制、备份集管理、恢复操作、自动备份、自动恢复等高级功能。它使用的备份和恢复格式是Oracle通用的备份集（Backup Set），这使得备份和恢复非常灵活和高效。
oracle指定tag恢复,Oracle RMAN的备份与恢复命令详解
weixin_39813200的博客
04-02 1154
4.3 Copy 镜像拷贝与恢复Copy镜像拷贝命令可以创建数据库数据文件、归档重做日志或者控制文件的精确副本。 RMAN 副本与这些文件的区别仅在于名称和(或)位置的区别。功能相当于用户管理的备份恢复中的热备份。备份副本的好处是恢复比较快，恢复时可以不用拷贝，指定新位置即可。Copy镜像拷贝至少要在mount 状态下运行。Copy镜像拷贝可作为增量备份的 Level 0Oracle10g开始，允...
oracle清除过期备份,关于RMAN备份无法删除过期备份策略问题
weixin_39942492的博客
04-03 788
大家好，最近遇到一个比较棘手的问题，不知那位高人能给予指点oracle 10.2.0.4在solairs下及redhat下都遇到了RMAN无法根据策略自动清理过期备份问题RMAN的配置RMAN> show all;using target database control file instead of recovery catalogRMAN configuration parameter...
Oracle RMAN无法删除部分归档日志问题
lzf200906306的博客
03-09 1507
RMAN清除方式会自动清除磁盘上的归档日志文件，同时会释放控制文件中对应的归档日志的归档信息，但最近在使用中就遇到了一个问题，用RMAN删除归档日志之后发现归档目录下仍然存在部分归档日志，经过查资料验证发现问题并解决过程。 前言 当Oracle 归档日志满了后，将无法正常登入oracle，需要删除一部分归档日志才能正常登入ORACLE。 最近在工作中遇到一个问题，Oracle 11g数据库使用RMAN没办法删除旧的归档，导致磁盘使用率很高。 1 2 3 4 5
oracle 删不掉归档日志文件的解决方法
羽之大公公的博客
04-01 1706
oracle11g旧的归档日志无法清理 问题描述： 使用deleteexpiredarchivelogall; deletenopromptarchiveloguntiltime'sysdate-7';命令脚本定时执行自动删除7天以前的归档日志，发现归档日志文件夹还有大量磁盘空间未释放，查看还存在大量7天以前的归档日志 问题分析： 使用rman命令删除归档日志是根据crontrolfile中记录的归档日志，如果你的归档日志没在crontrolfile中记录就无法被rman识别进而无...
oracle 归档无法删除的问题
最新发布
kevinyu998的博客
03-29 698
日常在处理ADG时，时常在主库归档空间不够时，使用force参数强制删除备库中未应用的归档，换个场景就不知道使用force了，记录下，时不时回看下，加深印象。上周接一个活，无法删除归档，现在已是2023年3月了，但2022年12月的归档无法删除，使用如下命令无法删除。手动把归档文件拷贝到/backup目录下，虽然状态变成X后，但还无法删除记录。过一天，同事回复搞定了，我很好奇方法，原来增加了一个force就解决问题了，因不影响使用，问了下同事就暂放下该事情，还计划找机会重启的。
oracle删除无效归档日志,rman删除旧的归档日志问题
weixin_39964978的博客
04-05 713
原因如下：backup archivelog all delete input 和 backup archivelog all delete all input的区别是什么？有资料上说的是：delete input 表示备份结束后删除归档日志delete all input 表示备份结束后删除所有归档日志目录文件做了试验，没有删除目录啊........结论：当有多个归档目录时 例如：log_arc...
oracle rman部分恢复,Oracle中使用RMAN备份及一些恢复方法
weixin_35983968的博客
04-05 907
使用RMAN备份并恢复Backup 备份命令生成 Backup sets (备份集合)，以 oracle 专有的格式保存，由一个完全的所有的备份片集合构成，构成一个完全备份或增量备份。1.1.1 BACKUP 备份命令选项设置标记(TAG)RMAN> backup database tag='test backup';限制备份集大小RMAN> backup database max...
ORACLE 备份恢复之RMAN详解
DoubleJing的博客
06-13 3537
一、连接方式 (一)、连接本地数据库 [oracle@oracle ~]$ rman target / (二)、连接远程数据库 [oracle@oracle ~]$ rman target sys/oracle@orcl 二、基本指令 (一)、执行 SQL 语句 RMAN>SQL ‘ALTER SYSTEM SWITCH LOGFILE’; (二)、RMAN 默认配置 1．显示 RMAN 默认配置 RMAN>SHOW ALL; 2．RMAN 默认配置详解 using target dat
Oracle RMAN DUPLICATE教程
10-31
**RMAN (Recovery Manager)** 是 Oracle 数据库管理系统中的一个重要工具，用于管理数据库的备份、恢复以及灾难恢复策略。其中，**Duplicate** 命令是 RMAN 的核心功能之一，它允许用户创建目标数据库的一个或多个...
oracle无法删除历史归档
killvoon的专栏
07-27 1056
生产上一台数据库服务器归档日志满了，由于尚未上线，并没有做删除归档方面的定时任务，从而导致归档日志将文件系统撑满的问题。 于是用rman删除归档，直接删掉所有归档： delete archivelog all; 该命令执行的时候，确实删掉了许多归档文件，但发现文件系统上还有好多归档文件未被删除。 于是执行如下脚本： crosscheck archivelog all; delete n
通过RMAN命令清理归档日志失败报错RMAN-08137解决方案
热门推荐
一片叶子飞舞
12-20 1万+
1. 报错如下： RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=/archive_bams/1_71800_812561563.arc thread=1 sequence=71800 2. 触发bug:
oracle查询失效归档,Oracle相关：RmanCrosscheck删除失效归档
weixin_36042403的博客
04-05 139
$ rman target /Recovery Manager: Release 9.2.0.4.0 - 64bit ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.connected to target database: AVATAR2 (DBID=2480694409)RMAN> ...
oracle备份归档文件,oracle 如何不备份已经备份的归档
weixin_39964899的博客
04-05 407
在Oracle数据库备份归档日志时，通常会保存最近几天的归档日志文件不删除。如：backup archivelog all;delete noprompt archivelog all completed before 'sysdate -14';　在本地保留14天的归档日志．再备份时，归档会重复再备份一次。加上一个子句 not backed up 1 times，就可以实现不备份已经归档的日志。...
解决rman无法自动删除过期备份和归档
huyangg的专栏
06-20 4563
rman的删除语句如下： run { delete noprompt obsolete; crosscheck backup; delete noprompt expired backup; crosscheck archivelog all; delete noprompt expired archivelog all; delete noprompt archivelog all
Data Guard 故障一则：主库归档删除失败（RMAN-08137）
weixin_41429228的博客
01-09 2018
Data Guard 故障一则：主库归档删除失败（RMAN-08137） 现象描述： Oracle(2节点RAC+单实例Data Guard)，主备库因为某些原因产生GAP之后，主库rman无法删除归档日志，报错信息如下： 主库实例alert日志： Thu Dec 10 09:51:50 2020 ARCn: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270) ARC6: Destination LOG_ARCHIVE_DEST
Oracle归档日志删除
二逩
06-17 1789
Oracle归档日志删除 我们都都知道在controlfile中记录着每一个archivelog的相关信息，当然们在OS下把这些物理文件delete掉后，在我们的 controlfile中仍然记录着这些archivelog的信息，在oracle的OEM管理器中有可视化的日志展现出，当我们手工清除 archive目录下的文件后，这些记录并没有被我们从controlfile中清除掉，也就是or
单机RMAN删除归档日志出现RMAN-0813错误的原因
XIANHUAFANG的博客
03-23 353
单机RMAN删除归档日志出现RMAN-0813错误的原因
评论 3
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值