ORACLE中使用RAMA删除部分日志
来源:互联网 发布:手机ai软件下载 编辑:程序博客网 时间:2024/06/11 09:04
1.登陆RAMA并查看相关日志文件
rman
connect target sys/oracle
list archivelog all
[oracle@oracledb ~]$ rmanRecovery Manager: Release 11.2.0.4.0 - Production on Fri Jan 20 07:05:17 2017Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.RMAN> connect target sys/oracleconnected to target database: ORCL (DBID=1460481228)RMAN> list archivelog all;using target database control file instead of recovery catalogList of Archived Log Copies for database with db_unique_name ORCL=====================================================================Key Thrd Seq S Low Time ------- ---- ------- - -------------------3 1 10 A 2017-01-17 07:43:53 Name: /u01/oracle/oralog/ARC0000000010_0932700493.0001_570d2ccc.log4 1 11 A 2017-01-17 07:45:00 Name: /u01/oracle/oralog/ARC0000000011_0932700493.0001_570d2ccc.log5 1 12 A 2017-01-17 08:10:51 Name: /u01/oracle/oralog/ARC0000000012_0932700493.0001_570d2ccc.log6 1 13 A 2017-01-17 08:16:51 Name: /u01/oracle/oralog/ARC0000000013_0932700493.0001_570d2ccc.log7 1 14 A 2017-01-18 01:26:22 Name: /u01/oracle/oralog/ARC0000000014_0932700493.0001_570d2ccc.log8 1 15 A 2017-01-18 07:19:54 Name: /u01/oracle/oralog/ARC0000000015_0932700493.0001_570d2ccc.log9 1 16 A 2017-01-18 21:48:33 Name: /u01/oracle/oralog/ARC0000000016_0932700493.0001_570d2ccc.log10 1 17 A 2017-01-18 21:52:13 Name: /u01/oracle/oralog/ARC0000000017_0932700493.0001_570d2ccc.log11 1 18 A 2017-01-18 21:57:10 Name: /u01/oracle/oralog/ARC0000000018_0932700493.0001_570d2ccc.log12 1 19 A 2017-01-18 22:01:34 Name: /u01/oracle/oralog/ARC0000000019_0932700493.0001_570d2ccc.log13 1 20 A 2017-01-18 22:06:37 Name: /u01/oracle/oralog/ARC0000000020_0932700493.0001_570d2ccc.log14 1 21 A 2017-01-19 06:24:46 Name: /u01/oracle/oralog/ARC0000000021_0932700493.0001_570d2ccc.log15 1 22 A 2017-01-19 06:30:16 Name: /u01/oracle/oralog/ARC0000000022_0932700493.0001_570d2ccc.log16 1 23 A 2017-01-19 06:35:43 Name: /u01/oracle/oralog/ARC0000000023_0932700493.0001_570d2ccc.log
2.发现有key从3到16的日志文件,现在我们来删除几个,手工到归档路径删除几个归档日志文件
[root@oracledb ~]# su - oracle[oracle@oracledb ~]$ rm /u01/oracle/oralog/ARC0000000010_0932700493.0001_570d2ccc.log
以上可知,recid=3的文件validation failed for archived logRMAN> crosscheck archivelog all;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=60 device type=DISKvalidation failed for archived logarchived log file name=/u01/oracle/oralog/ARC0000000010_0932700493.0001_570d2ccc.log RECID=3 STAMP=933493501validation succeeded for archived logarchived log file name=/u01/oracle/oralog/ARC0000000011_0932700493.0001_570d2ccc.log RECID=4 STAMP=933495053validation succeeded for archived logarchived log file name=/u01/oracle/oralog/ARC0000000012_0932700493.0001_570d2ccc.log RECID=5 STAMP=933495411validation succeeded for archived logarchived log file name=/u01/oracle/oralog/ARC0000000013_0932700493.0001_570d2ccc.log RECID=6 STAMP=933557190validation succeeded for archived logarchived log file name=/u01/oracle/oralog/ARC0000000014_0932700493.0001_570d2ccc.log RECID=7 STAMP=933578400validation succeeded for archived logarchived log file name=/u01/oracle/oralog/ARC0000000015_0932700493.0001_570d2ccc.log RECID=8 STAMP=933630524validation succeeded for archived logarchived log file name=/u01/oracle/oralog/ARC0000000016_0932700493.0001_570d2ccc.log RECID=9 STAMP=933630741validation succeeded for archived logarchived log file name=/u01/oracle/oralog/ARC0000000017_0932700493.0001_570d2ccc.log RECID=10 STAMP=933631032validation succeeded for archived logarchived log file name=/u01/oracle/oralog/ARC0000000018_0932700493.0001_570d2ccc.log RECID=11 STAMP=933631300validation succeeded for archived logarchived log file name=/u01/oracle/oralog/ARC0000000019_0932700493.0001_570d2ccc.log RECID=12 STAMP=933631604validation succeeded for archived logarchived log file name=/u01/oracle/oralog/ARC0000000020_0932700493.0001_570d2ccc.log RECID=13 STAMP=933661492validation succeeded for archived logarchived log file name=/u01/oracle/oralog/ARC0000000021_0932700493.0001_570d2ccc.log RECID=14 STAMP=933661823validation succeeded for archived logarchived log file name=/u01/oracle/oralog/ARC0000000022_0932700493.0001_570d2ccc.log RECID=15 STAMP=933662145validation succeeded for archived logarchived log file name=/u01/oracle/oralog/ARC0000000023_0932700493.0001_570d2ccc.log RECID=16 STAMP=933662456Crosschecked 14 objects
3.再次查看是否还有已删除日志文件的记录发现依然还存在列表中
RMAN> list archivelog all;List of Archived Log Copies for database with db_unique_name ORCL=====================================================================Key Thrd Seq S Low Time ------- ---- ------- - -------------------3 1 10 X 2017-01-17 07:43:53 Name: /u01/oracle/oralog/ARC0000000010_0932700493.0001_570d2ccc.log4 1 11 A 2017-01-17 07:45:00 Name: /u01/oracle/oralog/ARC0000000011_0932700493.0001_570d2ccc.log5 1 12 A 2017-01-17 08:10:51 Name: /u01/oracle/oralog/ARC0000000012_0932700493.0001_570d2ccc.log6 1 13 A 2017-01-17 08:16:51 Name: /u01/oracle/oralog/ARC0000000013_0932700493.0001_570d2ccc.log7 1 14 A 2017-01-18 01:26:22 Name: /u01/oracle/oralog/ARC0000000014_0932700493.0001_570d2ccc.log8 1 15 A 2017-01-18 07:19:54 Name: /u01/oracle/oralog/ARC0000000015_0932700493.0001_570d2ccc.log9 1 16 A 2017-01-18 21:48:33 Name: /u01/oracle/oralog/ARC0000000016_0932700493.0001_570d2ccc.log10 1 17 A 2017-01-18 21:52:13 Name: /u01/oracle/oralog/ARC0000000017_0932700493.0001_570d2ccc.log11 1 18 A 2017-01-18 21:57:10 Name: /u01/oracle/oralog/ARC0000000018_0932700493.0001_570d2ccc.log12 1 19 A 2017-01-18 22:01:34 Name: /u01/oracle/oralog/ARC0000000019_0932700493.0001_570d2ccc.log13 1 20 A 2017-01-18 22:06:37 Name: /u01/oracle/oralog/ARC0000000020_0932700493.0001_570d2ccc.log14 1 21 A 2017-01-19 06:24:46 Name: /u01/oracle/oralog/ARC0000000021_0932700493.0001_570d2ccc.log15 1 22 A 2017-01-19 06:30:16 Name: /u01/oracle/oralog/ARC0000000022_0932700493.0001_570d2ccc.log16 1 23 A 2017-01-19 06:35:43 Name: /u01/oracle/oralog/ARC0000000023_0932700493.0001_570d2ccc.log
4.执行以下语句删除expired状态的日子文件:
RMAN> delete expired archivelog all;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=60 device type=DISKList of Archived Log Copies for database with db_unique_name ORCL=====================================================================Key Thrd Seq S Low Time ------- ---- ------- - -------------------3 1 10 X 2017-01-17 07:43:53 Name: /u01/oracle/oralog/ARC0000000010_0932700493.0001_570d2ccc.logDo you really want to delete the above objects (enter YES or NO)? YESdeleted archived logarchived log file name=/u01/oracle/oralog/ARC0000000010_0932700493.0001_570d2ccc.log RECID=3 STAMP=933493501Deleted 1 EXPIRED objects注意执行删除时会进行询问,输入YES执行删除.
5.使用list archivelog all;再次查看时发现手工删除的日子文件已消失在此列表中了;
0 0
- ORACLE中使用RAMA删除部分日志
- oracle错误日志删除
- Oracle listener日志删除
- Oracle归档日志删除
- Oracle归档日志删除
- Oracle归档日志删除
- Oracle归档日志删除
- 删除oracle归档日志
- Oracle归档日志删除
- Oracle归档日志删除
- Oracle归档日志删除
- Oracle归档日志删除
- Oracle归档日志删除
- Oracle归档日志删除
- 删除ORACLE归档日志
- oracle归档日志删除
- Oracle归档日志删除
- Oracle归档日志删除
- (转)量化策略:Ricequant迎新年50篇干货分享
- 51 NOD 1091 线段的重叠
- OpenJudge 2989 糖果
- CodeForces 444C - DZY Loves Colors(线段树)
- 树状数组(3)
- ORACLE中使用RAMA删除部分日志
- Codeforces 451D - Count Good Substrings(组合数学)
- hdu 2089 不要62 (数位dp入门)
- 烂泥:VMWare Workation双网卡配置IP地址
- View滑动冲突
- 穷人的真相:从7点忙到23点的上班者,跳出穷人圈子唯一可能是.
- tkinter的进度条scale(尺子)
- HDU 5723 - Abandoned country(最小生成树+dfs)
- 烂泥:wiki系统confluence5.6.6安装、中文、破解及迁移