rman 08591 oracle 10g,关于OracleRMAN归档删除策略

最新推荐文章于 2025-05-18 10:33:05 发布

汪纪霞

最新推荐文章于 2025-05-18 10:33:05 发布

阅读量572

点赞数

文章标签： rman 08591 oracle 10g

本文介绍了在Oracle 10g和11g中，RMAN的归档日志删除策略默认未配置，当尝试删除未应用的归档日志时，系统会因备用或流捕获进程的需要而抛出警告。通过配置`CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY`，可以确保归档日志在被数据保护机制应用后再删除。实际操作中，配置该策略后，RMAN在删除归档日志前会检查其是否已被使用，从而避免误删重要日志。案例展示了配置后的删除操作及确认提示，确保了归档日志管理的安全性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

RMANgt; show all; CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; 在Oracle10g 11g 中归档删除策略缺省是没有配置的；那么

RMAN> show all;

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

在Oracle10g 11g 中归档删除策略缺省是没有配置的；

那么这时去删除未应用过的的归档日志会是怎么一种情况：

RMAN> delete archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=60 device type=DISK

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

archived log file name=/u01/app/ora11/flash_recovery_area/1_2019_822927217.dbf thread=1 sequence=2019

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

archived log file name=/u01/app/ora11/flash_recovery_area/1_2023_822927217.dbf thread=1 sequence=2023

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

Oracle 抛出报警；warning 归档日志没有删除，归档日志需要用作standby 或者 stream 捕获进程使用

关于rman中这个配置策略：

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY

不是自动删除归档。而是删除的时候确认归档已经被DATA GUARD、流环境所应用。这个功能的目的是避免删除其他功能所需要的归档日志。

如果配置归档删除策略：

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_home/dbs/snapcf_oradb1.f'; # default

尝试删除归档日志：

RMAN> delete archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=27 instance=oradb1 device type=DISK

List of Archived Log Copies for database with db_unique_name ORADB

=====================================================================

Key Thrd Seq S Low Time

------- ---- ------- - --------------------

2526 2 350 A 22-NOV-2014 02:01:04

Name: +FLASH/oradb/archivelog/2014_11_24/thread_2_seq_350.600.864470143

2527 2 351 A 23-NOV-2014 13:01:27

Name: +FLASH/oradb/archivelog/2014_11_24/thread_2_seq_351.620.864470173

2531 2 352 A 24-NOV-2014 10:29:04

Name: +FLASH/oradb/archivelog/2014_11_26/thread_2_seq_352.554.864634011

Do you really want to delete the above objects (enter YES or NO)? yes

deleted archived log

archived log file name=+FLASH/oradb/archivelog/2014_11_24/thread_2_seq_350.600.864470143 RECID=2526 STAMP=864470171

deleted archived log

archived log file name=+FLASH/oradb/archivelog/2014_11_24/thread_2_seq_351.620.864470173 RECID=2527 STAMP=864470193

deleted archived log

archived log file name=+FLASH/oradb/archivelog/2014_11_26/thread_2_seq_352.554.864634011 RECID=2531 STAMP=864634090

Deleted 3 objects

RMAN-08591: WARNING: invalid archived log deletion policy

[oracle@vmrac1 ~]$ oerr rman 8591

8591, 3, "WARNING: invalid archived log deletion policy"

// *Cause: An invalid ARCHIVELOG DELETION POLICY was supplied. The archived

// log deletion policy was APPLIED but there was no mandatory

// archived log destinations.

// *Action: One of the following:

// 1) Change archived log deletion policy using CONFIGURE command

// 2) Make one or more of standby destination as MANDATORY.

--------------------------------------推荐阅读 --------------------------------------

RMAN 配置归档日志删除策略

Oracle基础教程之通过RMAN复制数据库

RMAN备份策略制定参考内容

RMAN备份学习笔记

Oracle数据库备份加密 RMAN加密

--------------------------------------分割线 --------------------------------------

本文永久更新链接地址：

，

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网