归档日志可以用于备份数据库、创建物理或逻辑的备库或实时查询。 然而,在使用RMAN(Recovery Manager)进行备份和恢复操作时,有时会遇到警告信息RMAN-08137,提示归档日志无法删除,因为其在备库或上游数据库中还需要使用。本文将详细介绍RMAN-08137警告信息及其解决方案。 警告信息分析 RMAN-08137警告信息表示某个归档日志无...
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3';报错内容：RMAN-08137 "WARNING: archived log not deleted, needed for standby or upstream capture process"archived log file name=+ARCDG/巧凯xxx/archivelog/2020_07_12/thread_2_seq_2740.5670.1045582327 thread=2 sequence=2740 报错分析：...
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:metalink ID 1079953.1 通常是在搭建dg的时候,主库和备库已经互相确认了主备关系,但是备库的归...
在主库删除归档时报如下错误RMAN > delete archivelog until time "sysdate-7";RMAN-08137:警告:归档日志未删除,因为备用或上游捕获进程需要它原因是log_archive_dest_state_x设置为DEFER,但是Oracle认为只要设置了log_archive_dest_n就会认为备库存在,只是暂时不可用而已,因此不会删除归档。可以通过设置隐含参数(动态...
RMAN> delete archivelog until time 'sysdate-3'; using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=199 device type=DISK RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process ...
rman删除归档时报错RMAN-08137: WARNING: Archived Log Not Deleted, Needed For Standby Or Upstream Capture Proces,归档删除不了。 产生原因 由于有失效的integrated extract进程存在,导致rman无法删除归档。 解决方法 使用如下语句查询REQ_SCN = 0的抽取进程 ...
RMAN>delete noprompt archivelog until time 'sysdate-10'; 错误如下: RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process 方法一 检查发现数据库开启了附加日志: select force_logging,supplemental_log_data_min from v$database; ...
RMAN-08137：警告：因为仍需要归档⽇志,所以未删除问题解决 环境：windowsXP oracle11g 开发数据库 情景：⽤户登录失败,提⽰只有内部账号才能登陆,查看alert⽂件及trace⽂件得到下⾯⼀些信息 ORA-16014: log 1 sequence# 401 not archived, no available destinations ORA-19815: WARNING: db_recovery_...
RMAN-08137 "WARNING: archived log not deleted, needed for standby or upstream capture process" archived log file name=+ARCDG/xxx/archivelog/2020_07_12/thread_2_seq_2740.5670.1045582327 thread=2 sequence=2740 报错分析: 8137, 3, "WARNING: archived log not deleted, needed for standby or upstre...
RMAN-08137 "WARNING: archived log not deleted, needed for standby or upstream capture process"archived log file name=+ARCDG/xxx/archivelog/2020_07_12/thread_2_seq_2740.5670.1045582327 thread=2 sequence=2740 报错分析：8137, 3, "WARNING: archived log not deleted, needed for...