Oracle 11g 删除归档日志
来源:互联网 发布:复利的威力 知乎 编辑:程序博客网 时间:2024/05/19 22:47
原文链接: Oracle 11g 删除归档日志
操作步骤
$ bin/sqlplus / as sysdbaRMAN> delete archivelog all completed before 'sysdate-1';
具体操作及输出
$ bin/rman target /Recovery Manager: Release 11.2.0.1.0 - Production on Fri Apr 28 10:53:28 2017Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.connected to target database: ORCL (DBID=1451205847, not open)RMAN> list expired archivelog all;specification does not match any archived log in the repositoryRMAN> delete expired archivelog all;using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=5 device type=DISKspecification does not match any archived log in the repositoryRMAN> delete archivelog all completed before 'sysdate-1';released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=5 device type=DISKList of Archived Log Copies for database with db_unique_name ORCL=====================================================================Key Thrd Seq S Low Time ------- ---- ------- - ---------1 1 45 A 09-MAR-17 Name: /home/kylin/app/kylin/flash_recovery_area/ORCL/archivelog/2017_03_09/o1_mf_1_45_dd2qz3wo_.arc...100 1 144 A 26-APR-17 Name: /home/kylin/app/kylin/flash_recovery_area/ORCL/archivelog/2017_04_27/o1_mf_1_144_dj2py4mv_.arcDo you really want to delete the above objects (enter YES or NO)? YESdeleted archived logarchived log file name=/home/kylin/app/kylin/flash_recovery_area/ORCL/archivelog/2017_03_09/o1_mf_1_45_dd2qz3wo_.arc RECID=1 STAMP=938210404...deleted archived logarchived log file name=/home/kylin/app/kylin/flash_recovery_area/ORCL/archivelog/2017_04_27/o1_mf_1_144_dj2py4mv_.arc RECID=100 STAMP=942403653Deleted 100 objects
0 0
- Oracle 11g 删除归档日志
- Oracle 11g 归档日志
- oracle 11g 归档日志分析
- oracle 11g归档日志研究_1
- oracle 11g归档日志研究_2
- oracle 11g归档日志研究_3
- oracle 11g归档日志研究_4
- ORACLE 11g archive log 归档日志
- Oracle归档日志删除
- Oracle归档日志删除
- Oracle归档日志删除
- Oracle归档日志删除
- 删除oracle归档日志
- Oracle归档日志删除
- Oracle归档日志删除
- Oracle归档日志删除
- Oracle归档日志删除
- Oracle归档日志删除
- Routing Tables
- WebService-CXF-Spring+自定义拦截器
- Unity 实现2D游戏中物体延自定义路径反复移动
- 2017年前端面试题最新汇总
- ASP.NET的HttpContext基础知识
- Oracle 11g 删除归档日志
- AngularJS自定义服务
- ImageView的src和background的区别、padding的使用技巧、ImageView根据屏幕对缩放
- JavaScript巧学巧用
- android(体验一个项目天气预报开发)-2
- Android Multimedia实战(五)MediaCodec编码解码实例解析
- 《啊哈c语言》pdf
- ViewPager调用SetCurrentItem()方法,跨页面跳转时闪屏的问题
- strcpy和memcpy的区别