oracle rman删除过期归档,rman 删除所有过期归档

最新推荐文章于 2024-07-03 08:38:36 发布
最新推荐文章于 2024-07-03 08:38:36 发布
阅读量639 收藏
点赞数
文章标签： oracle rman删除过期归档

1、SQL> select name from v$archived_log;

NAME

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

/arch1/arch_1_5_766706446.log

/arch1/arch_1_6_766706446.log

/arch1/arch_1_7_766706446.log

/arch1/arch_1_8_766706446.log

/arch1/arch_1_9_766706446.log

/arch1/arch_1_10_766706446.log

/arch1/arch_1_11_766706446.log

/arch1/arch_1_12_766706446.log

/arch1/arch_1_13_766706446.log

/arch1/arch_1_14_766706446.log

/arch1/arch_1_15_766706446.log

NAME

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

/arch1/arch_1_16_766706446.log

/arch1/arch_1_17_766706446.log

/arch1/arch_1_19_766706446.log

/arch1/arch_1_18_766706446.log

/arch1/arch_1_20_766706446.log

/arch1/arch_1_21_766706446.log

/arch1/arch_1_22_766706446.log

/arch1/arch_1_23_766706446.log

上面日志有的是过期的(expired).

2、使用rman 查询和删除过期的归档

[oracle@yitai ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Oct 16 15:12:45 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: CUUG (DBID=1247937484)

RMAN> crosscheck archivelog all;

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=141 devtype=DISK

validation failed for archived log

archive log filename=/arch1/arch_1_5_766706446.log recid=1 stamp=796830677

validation failed for archived log

archive log filename=/arch1/arch_1_6_766706446.log recid=2 stamp=796830677

validation failed for archived log

archive log filename=/arch1/arch_1_7_766706446.log recid=3 stamp=796831908

validation failed for archived log

archive log filename=/arch1/arch_1_8_766706446.log recid=4 stamp=796832094

validation failed for archived log

archive log filename=/arch1/arch_1_9_766706446.log recid=5 stamp=796832102

validation failed for archived log

archive log filename=/arch1/arch_1_10_766706446.log recid=6 stamp=796832363

validation failed for archived log

archive log filename=/arch1/arch_1_11_766706446.log recid=7 stamp=796832371

validation failed for archived log

archive log filename=/arch1/arch_1_12_766706446.log recid=8 stamp=796832381

validation failed for archived log

archive log filename=/arch1/arch_1_13_766706446.log recid=9 stamp=796832394

validation failed for archived log

archive log filename=/arch1/arch_1_14_766706446.log recid=10 stamp=796832401

validation failed for archived log

archive log filename=/arch1/arch_1_15_766706446.log recid=11 stamp=796832410

validation failed for archived log

archive log filename=/arch1/arch_1_16_766706446.log recid=12 stamp=796832415

validation failed for archived log

archive log filename=/arch1/arch_1_17_766706446.log recid=13 stamp=796832422

validation failed for archived log

archive log filename=/arch1/arch_1_18_766706446.log recid=15 stamp=796833242

validation failed for archived log

archive log filename=/arch1/arch_1_19_766706446.log recid=14 stamp=796833242

validation failed for archived log

archive log filename=/arch1/arch_1_20_766706446.log recid=16 stamp=796833245

validation failed for archived log

archive log filename=/arch1/arch_1_21_766706446.log recid=17 stamp=796833408

validation failed for archived log

archive log filename=/arch1/arch_1_22_766706446.log recid=18 stamp=796835220

validation succeeded for archived log

archive log filename=/arch1/arch_1_23_766706446.log recid=19 stamp=796835527

Crosschecked 19 objects

RMAN> list expired archivelog all;   #列出过期的归档

List of Archived Log Copies

Key     Thrd Seq     S Low Time  Name

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

1       1    5       X 16-OCT-12 /arch1/arch_1_5_766706446.log2       1    6       X 16-OCT-12 /arch1/arch_1_6_766706446.log3       1    7       X 16-OCT-12 /arch1/arch_1_7_766706446.log4       1    8       X 16-OCT-12 /arch1/arch_1_8_766706446.log5       1    9       X 16-OCT-12 /arch1/arch_1_9_766706446.log6       1    10      X 16-OCT-12 /arch1/arch_1_10_766706446.log7       1    11      X 16-OCT-12 /arch1/arch_1_11_766706446.log8       1    12      X 16-OCT-12 /arch1/arch_1_12_766706446.log9       1    13      X 16-OCT-12 /arch1/arch_1_13_766706446.log10      1    14      X 16-OCT-12 /arch1/arch_1_14_766706446.log11      1    15      X 16-OCT-12 /arch1/arch_1_15_766706446.log12      1    16      X 16-OCT-12 /arch1/arch_1_16_766706446.log13      1    17      X 16-OCT-12 /arch1/arch_1_17_766706446.log15      1    18      X 16-OCT-12 /arch1/arch_1_18_766706446.log14      1    19      X 16-OCT-12 /arch1/arch_1_19_766706446.log16      1    20      X 16-OCT-12 /arch1/arch_1_20_766706446.log17      1    21      X 16-OCT-12 /arch1/arch_1_21_766706446.log18      1    22      X 16-OCT-12 /arch1/arch_1_22_766706446.log

RMAN> delete noprompt expired archivelog all; #删除过期的归档

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=141 devtype=DISK

List of Archived Log Copies

Key     Thrd Seq     S Low Time  Name

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

1       1    5       X 16-OCT-12 /arch1/arch_1_5_766706446.log

2       1    6       X 16-OCT-12 /arch1/arch_1_6_766706446.log

3       1    7       X 16-OCT-12 /arch1/arch_1_7_766706446.log

4       1    8       X 16-OCT-12 /arch1/arch_1_8_766706446.log

5       1    9       X 16-OCT-12 /arch1/arch_1_9_766706446.log

6       1    10      X 16-OCT-12 /arch1/arch_1_10_766706446.log

7       1    11      X 16-OCT-12 /arch1/arch_1_11_766706446.log

8       1    12      X 16-OCT-12 /arch1/arch_1_12_766706446.log

9       1    13      X 16-OCT-12 /arch1/arch_1_13_766706446.log

10      1    14      X 16-OCT-12 /arch1/arch_1_14_766706446.log

11      1    15      X 16-OCT-12 /arch1/arch_1_15_766706446.log

12      1    16      X 16-OCT-12 /arch1/arch_1_16_766706446.log

13      1    17      X 16-OCT-12 /arch1/arch_1_17_766706446.log

15      1    18      X 16-OCT-12 /arch1/arch_1_18_766706446.log

14      1    19      X 16-OCT-12 /arch1/arch_1_19_766706446.log

16      1    20      X 16-OCT-12 /arch1/arch_1_20_766706446.log

17      1    21      X 16-OCT-12 /arch1/arch_1_21_766706446.log

18      1    22      X 16-OCT-12 /arch1/arch_1_22_766706446.log

deleted archive log

archive log filename=/arch1/arch_1_5_766706446.log recid=1 stamp=796830677

deleted archive log

archive log filename=/arch1/arch_1_6_766706446.log recid=2 stamp=796830677

deleted archive log

archive log filename=/arch1/arch_1_7_766706446.log recid=3 stamp=796831908

deleted archive log

archive log filename=/arch1/arch_1_8_766706446.log recid=4 stamp=796832094

deleted archive log

archive log filename=/arch1/arch_1_9_766706446.log recid=5 stamp=796832102

deleted archive log

archive log filename=/arch1/arch_1_10_766706446.log recid=6 stamp=796832363

deleted archive log

archive log filename=/arch1/arch_1_11_766706446.log recid=7 stamp=796832371

deleted archive log

archive log filename=/arch1/arch_1_12_766706446.log recid=8 stamp=796832381

deleted archive log

archive log filename=/arch1/arch_1_13_766706446.log recid=9 stamp=796832394

deleted archive log

archive log filename=/arch1/arch_1_14_766706446.log recid=10 stamp=796832401

deleted archive log

archive log filename=/arch1/arch_1_15_766706446.log recid=11 stamp=796832410

deleted archive log

archive log filename=/arch1/arch_1_16_766706446.log recid=12 stamp=796832415

deleted archive log

archive log filename=/arch1/arch_1_17_766706446.log recid=13 stamp=796832422

deleted archive log

archive log filename=/arch1/arch_1_18_766706446.log recid=15 stamp=796833242

deleted archive log

archive log filename=/arch1/arch_1_19_766706446.log recid=14 stamp=796833242

deleted archive log

archive log filename=/arch1/arch_1_20_766706446.log recid=16 stamp=796833245

deleted archive log

archive log filename=/arch1/arch_1_21_766706446.log recid=17 stamp=796833408

deleted archive log

archive log filename=/arch1/arch_1_22_766706446.log recid=18 stamp=796835220

Deleted 18 EXPIRED objects

#删除了18个归档

------Good Luck !----------

weixin_29623163
关注
Oracle RMAN脚本删除过期归档、保留最近7天归档
weixin_41824599的博客
01-17 863
Oracle RMAN脚本删除过期归档、保留最近7天归档
oracle rman删除备份文件,删除ORACLE RMAN 的过期的备份
weixin_30976201的博客
04-03 894
晚上在做oracle实验的时候，一开始就把前几天存放RMAN备份集目录下的文件给删掉了。结果我到RMAN 下，想把之前做的一些备份给删除，结果，任我怎么执行RMAN>delete backup;然后再才执行 ，list backup，里面数据还在，经过仔细查看，原来列出的备份文件，刚刚被我删掉了，可是RMAN 里的数据却没有更新。想想应该是要让rman的数据也要更新才行的，可是要怎么去更新R...
rman 清理过期归档日志
01-16
rman 清理过期归档日志，oracleg归档日志满了，可以使用的
Oracle RMAN备份和清理过期归档的通用脚本
最新发布
一杯温酒慰风尘，一段代码为爱好
07-03 693
Oracle RMAN备份和删除过期归档文件的通用脚本
Oracle数据库手动删除过期归档
weixin_46759378的博客
08-03 502
Oracle数据库手动删除过期归档
oracle rman 删除过期的归档
cmbzwa6940的博客
01-11 604
1.检测所有归档 RMAN> crosscheck archivelog all; 2.列出所有无效的归档 RMAN> list expired archivelog all; ...
Oracle 删除过期归档日志
Ahern_的博客
05-31 2641
定期删除数据库归档日志
rman 删除所有过期归档
cizongzhic79075的博客
10-16 181
1、SQL> select name from v$archived_log;NAME--------------------------------------------------------------------...
Windows平台使用RMAN命令自动删除Oracle过期归档日志的方法
专注于Java技术、软件架构设计、数据分析
08-24 6875
自动删除Oracle过期归档日志的思路如下： 1、编写自动执行的bat脚本文件； 2、Windows设置定期执行计划 OracleArchLogClear.bat D:/Oracle/product/10.2.0/db_1/bin/rman target / cmdfile=D:/OracleArchLogClear.rman log=D:/rman.log OracleArchLogClear.rman DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7
oracle rman删除过期归档,RMAN清理过期备份和归档日志
05-27
如果你想要使用 Oracle RMAN 删除过期的归档日志，可以使用以下命令： ``` DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE - <days>'; ``` 其中，<days> 指定了你想要删除的归档日志的天数。这个命令将会删除...
解决Oracle RMAN删除归档日志不释放问题的方法
12-16
`命令，这两个命令分别会删除过期的或所有归档日志，但在执行之前需谨慎，因为这可能永久性地删除必要的日志。 4. **重建控制文件**：在极端情况下，如果以上步骤都无法解决问题，可能需要考虑重建控制文件。但这是...
RMAN 删除指定几天前的归档
09-21
利用RMAN删除指定几时间前的归档.这是我的日常操作记录，供参考！
win平台oracle rman备份和删除dg备库归档日志脚本
09-10
`delete_archive.sql`脚本用于生成删除已应用归档日志的SQL命令，而`rman_checkcross.rman`则包含RMAN命令来检查归档日志的状态并删除过期的归档日志。 总结来说，Windows平台上的Oracle RMAN备份和删除DG备库归档...
oracle查询失效归档,Rman Crosscheck删除失效归档
weixin_30744613的博客
04-05 667
Rman Crosscheck删除失效归档$ 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...
RMAN清理过期备份和归档日志
weixin_33834628的博客
08-14 447
首先要先定位磁盘问题，怀疑到是过期备份导致的。df -h | awk '$5 >= 90||$4>=90 {print}' Filesystem Size Used Avail Use% Mounted on 1.4T 1.3T 115G 92% /d01_test2 ...
Oracle 删除归档
JANE_ZDr的博客
09-18 4607
如何正确地删除Archivelog？Archivelog并不能直接得从OS层直接物理删除，因为archivelog的相关信息是记录在controlfile中的，当物理删除后不会改变controlfile的设置，并且在查询相关的动态视图(例如v$archived_log)时，该部分日志仍然标注为存在，也就是说Oracle并不认为这些日志被删除了，所以在删除archivelog的时候，需要我们在其他地方做一些设置。 一、使用RMAN清除物理删除后的记录 可以使用RMAN来删除archivelog，具体可..
oracle清除过期备份,RMAN清理过期备份和归档日志
weixin_42501904的博客
04-03 1198
首先要先定位磁盘问题，怀疑到是过期备份导致的。df -h | awk '$5 >= 90||$4>=90 {print}'Filesystem Size Used Avail Use% Mounted on1.4T 1.3T 115G 92% /d01_test215G 15G 373M 98% /u01_test112G 12G 545M ...
【RMAN】【RMAN命令】DELETE 命令(4)--删除EXPIRED副本(不提示)
cmy19760818的博客
10-06 242
删除EXPIRED副本(不提示) RMAN>delete noprompt expired copy ; ▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼RMAN> lis...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值