RMAN-08138: WARNING: archived log not deleted - must create more backups

于 2023-04-12 21:02:02 发布
阅读量551 收藏
点赞数
文章标签： oracle 数据库 java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kevinyu998/article/details/130116422
版权
在尝试使用RMAN删除Oracle数据库的归档日志时，遇到错误提示需创建更多备份。执行备份后，再次尝试删除仍失败。最终发现是由于一体机备份异常导致的问题，经过操作成功删除了归档日志。
摘要由CSDN通过智能技术生成

今天临下班，客户发来一个信息说，第3方备份无法删除归档，报错如下

RMAN> delete noprompt archivelog until time 'sysdate-13' backed up 1 times to sbt;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=630 instance=orcl1 device type=DISK
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_29/o1_mf_1_68251_l28fp7y6_.arc thread=1 sequence=68251
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_29/o1_mf_1_68252_l28odzyy_.arc thread=1 sequence=68252
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68253_l2913207_.arc thread=1 sequence=68253
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68254_l29cnl0k_.arc thread=1 sequence=68254
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68255_l29qgo0v_.arc thread=1 sequence=68255
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68256_l29wl819_.arc thread=1 sequence=68256
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68257_l2b2fr1t_.arc thread=1 sequence=68257
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68258_l2bb3r2g_.arc thread=1 sequence=68258
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68259_l2bgnw2l_.arc thread=1 sequence=68259
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68260_l2bnpl3g_.arc thread=1 sequence=68260
。。。。。。。。。。。。。。。。。。

第一次遇到该报错类型，是国产备份一体机做的rman备份啊，测试下吧

RMAN> backup archivelog until time 'sysdate-13' format '/backup/orcl/ARCHBAK_%d_%T_%s_%p' not backed up;

Starting backup at 12-APR-23
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=2 sequence=35216 RECID=103466 STAMP=1132777069
input archived log thread=1 sequence=68251 RECID=103467 STAMP=1132779721
input archived log thread=2 sequence=35217 RECID=103468 STAMP=1132782625
input archived log thread=1 sequence=68252 RECID=103469 STAMP=1132787617
input archived log thread=2 sequence=35218 RECID=103470 STAMP=1132789144
input archived log thread=1 sequence=68253 RECID=103473 STAMP=1132799587
input archived log thread=2 sequence=35219 RECID=103471 STAMP=1132793464
channel ORA_DISK_1: starting piece 1 at 12-APR-23
channel ORA_DISK_1: finished piece 1 at 12-APR-23
piece handle=/backup/orcl/ARCHBAK_ORCL_20230412_18206_1 tag=TAG20230412T202907 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
Finished backup at 12-APR-23

Starting Control File and SPFILE Autobackup at 12-APR-23
piece handle=/nasbackup/orcl/ctlbackup/c-2465516870-20230412-03 comment=NONE
Finished Control File and SPFILE Autobackup at 12-APR-23

备份成功

再次使用RMAN> delete noprompt archivelog until time 'sysdate-13' backed up 1 times to sbt;做删除还是同样的报错，

使用RMAN> delete noprompt archivelog until time 'sysdate-13' backed up 1 times to disk;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=630 instance=orcl1 device type=DISK
List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
103467  1    68251   A 29-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_29/o1_mf_1_68251_l28fp7y6_.arc

103469  1    68252   A 29-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_29/o1_mf_1_68252_l28odzyy_.arc

103473  1    68253   A 29-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68253_l2913207_.arc

103477  1    68254   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68254_l29cnl0k_.arc

103480  1    68255   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68255_l29qgo0v_.arc

103482  1    68256   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68256_l29wl819_.arc

103484  1    68257   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68257_l2b2fr1t_.arc

103486  1    68258   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68258_l2bb3r2g_.arc

103487  1    68259   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68259_l2bgnw2l_.arc

103490  1    68260   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68260_l2bnpl3g_.arc

103493  1    68261   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68261_l2bx844o_.arc

103496  1    68262   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68262_l2c74k5b_.arc

103466  2    35216   A 29-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_29/o1_mf_2_35216_l28c3d1t_.arc

103468  2    35217   A 29-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_29/o1_mf_2_35217_l28jk02h_.arc

103470  2    35218   A 29-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_29/o1_mf_2_35218_l28pwq2q_.arc

103471  2    35219   A 29-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35219_l28v3q30_.arc

103472  2    35220   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35220_l2912z36_.arc

103474  2    35221   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35221_l293y93d_.arc

103475  2    35222   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35222_l2961z3m_.arc

103476  2    35223   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35223_l29cnh44_.arc

103478  2    35224   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35224_l29j6n53_.arc

103479  2    35225   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35225_l29nfq5j_.arc

103481  2    35226   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35226_l29vtt5m_.arc

103483  2    35227   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35227_l2b2655s_.arc

103485  2    35228   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35228_l2b7hd6f_.arc

103488  2    35229   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35229_l2bhtr7p_.arc

103489  2    35230   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35230_l2bnp67t_.arc

103491  2    35231   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35231_l2bqmy8d_.arc

103492  2    35232   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35232_l2bwws8q_.arc

103494  2    35233   A 30-MAR-23
        Name: /u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35233_l2c1d48q_.arc

deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_29/o1_mf_1_68251_l28fp7y6_.arc RECID=103467 STAMP=1132779721
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_29/o1_mf_1_68252_l28odzyy_.arc RECID=103469 STAMP=1132787617
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68253_l2913207_.arc RECID=103473 STAMP=1132799587
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68254_l29cnl0k_.arc RECID=103477 STAMP=1132810387
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68255_l29qgo0v_.arc RECID=103480 STAMP=1132822486
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68256_l29wl819_.arc RECID=103482 STAMP=1132827721
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68257_l2b2fr1t_.arc RECID=103484 STAMP=1132833721
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68258_l2bb3r2g_.arc RECID=103486 STAMP=1132841593
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68259_l2bgnw2l_.arc RECID=103487 STAMP=1132846237
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68260_l2bnpl3g_.arc RECID=103490 STAMP=1132852435
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68261_l2bx844o_.arc RECID=103493 STAMP=1132861189
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_1_68262_l2c74k5b_.arc RECID=103496 STAMP=1132871314
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_29/o1_mf_2_35216_l28c3d1t_.arc RECID=103466 STAMP=1132777069
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_29/o1_mf_2_35217_l28jk02h_.arc RECID=103468 STAMP=1132782625
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_29/o1_mf_2_35218_l28pwq2q_.arc RECID=103470 STAMP=1132789144
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35219_l28v3q30_.arc RECID=103471 STAMP=1132793464
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35220_l2912z36_.arc RECID=103472 STAMP=1132799584
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35221_l293y93d_.arc RECID=103474 STAMP=1132802506
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35222_l2961z3m_.arc RECID=103475 STAMP=1132804672
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35223_l29cnh44_.arc RECID=103476 STAMP=1132810384
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35224_l29j6n53_.arc RECID=103478 STAMP=1132815061
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35225_l29nfq5j_.arc RECID=103479 STAMP=1132819384
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35226_l29vtt5m_.arc RECID=103481 STAMP=1132826971
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35227_l2b2655s_.arc RECID=103483 STAMP=1132833478
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35228_l2b7hd6f_.arc RECID=103485 STAMP=1132838893
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35229_l2bhtr7p_.arc RECID=103488 STAMP=1132847449
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35230_l2bnp67t_.arc RECID=103489 STAMP=1132852423
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35231_l2bqmy8d_.arc RECID=103491 STAMP=1132855423
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35232_l2bwws8q_.arc RECID=103492 STAMP=1132860826
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/datastore/orcl/ORCL/archivelog/2023_03_30/o1_mf_2_35233_l2c1d48q_.arc RECID=103494 STAMP=1132865413
Deleted 30 objects


RMAN删除成功，说明一体机备份异常了，哎，别人挣钱我们出力

bestsun999
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
oracle 归档日期,请教rman关于备份指定时间段归档日志报错问题
weixin_34656543的博客
04-04 529
谢谢刘大，是我语法和里头函数位置写错了，现在可以了，谢谢！但现在又有个问题了,就是有些会重复备份，是什么原因？如下：我备昨天12-18点，和备18-0点的，在备18-0点时发现二个节点813 510都会又重复备一次，这是什么原因？这个time是指v$archived_log中COMPLETION_TIME?还是RESETLOGS_TIME？ FIRST_TIME？RMAN> backup...
Oracle-Automatic-Installation:Oracle DBA Rman
05-08
Oracle数据库自动化安装与DBA RMAN实践 Oracle数据库是企业级广泛应用的关系型数据库管理系统，而RMAN（Recovery Manager）是Oracle提供的一款强大的备份和恢复工具。本资料将重点介绍如何在Linux环境下实现Oracle...
DG环境RMAN删除归档报错RMAN-08137: archived log not deleted
weixin_34104341的博客
06-26 405
Oracle 12C DG环境，备库归档目录告警，查看crontab脚本，发现有删除操作，保持两天的，后手动执行，查看具体报错原因； RMAN> delete noprompt expired archivelog all; released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=540...
RMAN的设置引起删除归档日志无法删除的错误
好记忆也需烂博客
07-06 4739
几天没去看备份日志，今天数据库RECOVERY空间不足了。 看到日志发现如下： RMAN-08138: WARNING: archived log not deleted - must create more backups 再看到如下设置： CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STA
【oracle案例】RMAN-08138
05-21 2179
使用RMAN删除归档日志报错，RMAN-08138: WARNING: archived log notdeleted - must create more backups，删除操作跟RMAN中设置的归档日志删除策略相互冲突。
RMAN-08137: WARNING: archived log not deleted
mengxiangfeiyang的专栏
02-19 7835
RMAN> delete archivelog until time 'sysdate-9'; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=289 device type=DISK RMAN-08137: WARNING: archived log not delete
三思笔记Rman
08-08
三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思...
oracle-rman-for-absolute-begs:Darl Kuhn的“面向绝对初学者的Oracle RMAN”的源代码-ab source code
03-24
Apress源代码 该存储库与Darl Kuhn（Apress，2014年）提供的使用。 使用绿色按钮将文件下载为zip格式，或使用Git将存储库克隆到您的计算机上。 发行版 版本v1.0对应于已出版书籍中的代码，没有更正或更新。...
rman_backups:Oracle 11g12c的RMAN备份脚本
04-29
`rman_backups`可能是一个用于自动化这些任务的Shell脚本，它可以帮助数据库管理员按照预定的策略执行RMAN备份。 RMAN备份的基本概念包括全备份、增量备份和差异备份。全备份会复制数据库的所有数据文件，而增量...
rman-xttconvert_2.0.rar
05-23
在"rman-xttconvert_2.0.rar"这个压缩包中，包含了XTTConvert工具的最新版本2.0。这个版本可能引入了更多的性能优化和新特性，例如更快的转换速度、更好的错误处理机制、支持更大规模的XML数据处理等。对于那些拥有...
RMAN-08137: 警告: 因为仍需要归档日志, 所以未删除 问题解决
weixin_30781433的博客
09-17 450
环境：windowsXP oracle11g 开发数据库情景：用户登录失败,提示只有内部账号才能登陆, 查看alert文件及trace文件得到下面一些信息ORA-16014: log 1 sequence# 401 not archived, no available destinationsORA-19815: WARNING: db_recovery_file_dest_s...
RMAN-08120:WARNING: archived log not deleted, not yet applied by standby
u012232730的博客
07-16 1632
在12C版本数据库部署自动清理归档脚本，查看删除日志报错，在11g中未出现过此警告，感觉是12C的新特性导致。 RMAN-08120:WARNING: archived log not deleted, not yet applied by standby 这个问题，是因为在12.1.0.2中，删除归档日志的默认行为发生了变化。原来在11g中不考虑defer的路径，在12.1.0.2时如果有defer的路径，则会报错日志没有applied，即使这些日志实际上已经被applied了。 This beha
oracle dg 删除归档,DG环境RMAN删除归档报错RMAN-08137: archived log not deleted
weixin_39559469的博客
04-13 448
RMAN> delete noprompt expired archivelog all;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=5408 device type=DISKspecification does not match any archived log in t...
RMAN-08137:警告：归档日志未删除，因为备用或上游捕获进程需要它
千里足迹
08-01 5842
版本：OracleDatabase 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production   问题描述：DG环境有问题，主库因空间不够改为noarchivelog模式，主库删除归档日志删除不了 DELETE ARCHIVELOG ALL COMPLETED BEFORE'SYSDATE-7'; RMAN-08137:警告：
RMAN: The Meaning of RMAN "Backup Archivelog Until Time 'XXXX'" [ID 122699.1]
conghouxun4466的博客
02-24 101
Purpose:========The purpose of this article is to clarify the RMAN statement: "backup archivelog until time 'XXXX...
RMAN-08137
a743044559的专栏
09-07 2421
最近rac+dg环境rman备份日志一致出现错误：RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=+ARCH/jhdb/archivelog/jhdb2/2_8194_884618889.dbf thread=2 s
Oracle运维
weixin_43832230的博客
06-19 294
RMAN日志清理 1.sqlplus user/password 登录oracle 2.rman 3.connect target user/password ；rman连接到数据库 4.crosscheck archivelog all; 校验日志可用性 5.delete noprompt force archivelog all completed before ‘sysdate-7’; 删掉七天之前的归档日志 注：noprompt force 意指强制删除。不加此参数可能会导致清理失败。 Orac
rman命令总结
袁子建
06-25 831
RMAN命令详解和常用汇总 转摘汇集，日后使用 本文链接：https://blog.csdn.net/EVISWANG/article/details/50448370 http://blog.itpub.net/25904686/viewspace-742701/ https://blog.csdn.net/zq9017197/article/details/6869579 https://www.cnblogs.com/polestar/archive/2013/02/06/2902598.html .
How to clear the archive log
Enhancing Your Oracle Capability
09-18 1275
Some time, the archive is full, we have to clear the archive log and then make the database normal. The following way, maybe is useful to you. 1. For NO-DATAGUARD: --- 1. Check the archiv
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream
最新发布
06-13
这个错误提示表示该归档日志文件还在被 standby 数据库或者上游主数据库使用，不能被删除。如果你想要删除这个归档日志文件，你需要先确认这个日志是否被 standby 数据库或者上游主数据库所需要，如果需要的话，你需要等待它们使用完后再进行删除。同时，你也可以考虑增加 standby 数据库的容量，以便更好地管理这些归档日志文件。
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值