How to delete expired archive log files using rman?

最新推荐文章于 2025-02-05 13:48:44 发布

转载最新推荐文章于 2025-02-05 13:48:44 发布 · 71 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/princessd8251/p/3808090.html

文章标签：

#数据库

本文介绍如何使用Oracle Recovery Manager (RMAN) 清理数据库中过期的归档日志文件，包括列出、检查及删除这些文件的具体命令。此外还提供了当归档目的地磁盘空间不足导致数据库挂起时的解决办法。

he following commands will helpful to delete the expired archive log files using Oracle Recovery Manager(RMAN).Connect to the Rman prompt and try the bellow commands.

RMAN>list expired archivelog all;

RMAN>crosscheck archivelog all;

RMAN>delete noprompt expired archivelog all;

RMAN>list expired archivelog all;

Sample Ouptut:

RMAN> list expired archivelog all;
specification does not match any archived log in the repository
RMAN>

In my develop environment , sometime the archive destination folder is full, caused the database hang. So I will use below command to disable it.

Disable Archive log mode

startup mount

alter database noarchivelog;

alter database open;

方法一：
rman target/
或rman target/@orcl
在命令窗口里面执行
delete noprompt archivelog until time 'sysdate-7'; //删除七天前的归档，果使用了闪回功能，也会删除闪回的数据。
DELETE ARCHIVELOG FROM TIME 'SYSDATE-7'; //删除七天到现在的归档

方法二：（rman登不进去）

执行find /archive/ -name "*.dbf"|wc –l查看有多少归档日志
删除7天之前的所有归档文件
find /archive/ -name "*.dbf" -mtime +7 -exec rm -f {} ;

将归档日志信息进行更新

asm 就得用asmcmd交互界面rm了
RMAN> crosscheck archivelog all;
RMAN> delete noprompt expired archivelog all;
RMAN> exit

转载于:https://www.cnblogs.com/princessd8251/p/3808090.html