重庆思庄Oracle、Redhat认证学习论坛
标题: 清理v$archived_log视图中过期信息 [打印本页]
作者: jiawang 时间: 2020-5-29 10:45
标题: 清理v$archived_log视图中过期信息
本帖最后由 jiawang 于 2020-5-29 10:53 编辑
数据库:oracle 11.2.0.4.0
OS:Windows 2008 R2
我们在在使用RMAN命令删除归档后,查询v$archived_log视图会发现name列为空了,但其他列的信息还保留,时间长了会留下很多过期的信息,影响维护工作,需要将过期的信息删除。
首先模拟下问题的出现过程:
删除归档日志之前查看v$archived_log视图,情况正常
SQL> col name for a45
SQL> select dest_id,sequence#,name,blocks from v$archived_log
DEST_ID SEQUENCE# NAME BLOCKS
---------- ---------- --------------------------------------------- ----------
1 3787 E:\ARCHIVE\ARC0000003787_0981295486.0001 26267
1 3788 E:\ARCHIVE\ARC0000003788_0981295486.0001 77190
1 3789 E:\ARCHIVE\ARC0000003789_0981295486.0001 61304
1 3790 E:\ARCHIVE\ARC0000003790_0981295486.0001 82720
1 3791 E:\ARCHIVE\ARC0000003791_0981295486.0001 60480
1 3792 E:\ARCHIVE\ARC0000003792_0981295486.0001 47236
1 3793 E:\ARCHIVE\ARC0000003793_0981295486.0001 60955
1 3794 E:\ARCHIVE\ARC0000003794_0981295486.0001 67887
DEST_ID SEQUENCE# NAME BLOCKS
---------- ---------- --------------------------------------------- ----------
1 3795 E:\ARCHIVE\ARC0000003795_0981295486.0001 79003
1 3796 E:\ARCHIVE\ARC0000003796_0981295486.0001 61385
1 3797 E:\ARCHIVE\ARC0000003797_0981295486.0001 59788
1 3798 E:\ARCHIVE\ARC0000003798_0981295486.0001 33872
1 3799 E:\ARCHIVE\ARC0000003799_0981295486.0001 60069
1 3800 E:\ARCHIVE\ARC0000003800_0981295486.0001 62924
1 3801 E:\ARCHIVE\ARC0000003801_0981295486.0001 69551
1 3802 E:\ARCHIVE\ARC0000003802_0981295486.0001 60007
1 3803 E:\ARCHIVE\ARC0000003803_0981295486.0001 59790
1 3804 E:\ARCHIVE\ARC0000003804_0981295486.0001 39796
1 3805 E:\ARCHIVE\ARC0000003805_0981295486.0001 61584
DEST_ID SEQUENCE# NAME BLOCKS
---------- ---------- --------------------------------------------- ----------
1 3806 E:\ARCHIVE\ARC0000003806_0981295486.0001 90796
1 3807 E:\ARCHIVE\ARC0000003807_0981295486.0001 62389
1 3808 E:\ARCHIVE\ARC0000003808_0981295486.0001 14615
1 3809 E:\ARCHIVE\ARC0000003809_0981295486.0001 12579
1 3810 E:\ARCHIVE\ARC0000003810_0981295486.0001 63007
1 3811 E:\ARCHIVE\ARC0000003811_0981295486.0001 59788
1 3812 E:\ARCHIVE\ARC0000003812_0981295486.0001 82726
1 3813 E:\ARCHIVE\ARC0000003813_0981295486.0001 61184
1 3814 E:\ARCHIVE\ARC0000003814_0981295486.0001 27207
1 3815 E:\ARCHIVE\ARC0000003815_0981295486.0001 63358
1 3816 E:\ARCHIVE\ARC0000003816_0981295486.0001 59789
DEST_ID SEQUENCE# NAME BLOCKS
---------- ---------- --------------------------------------------- ----------
1 3817 E:\ARCHIVE\ARC0000003817_0981295486.0001 82720
1 3818 E:\ARCHIVE\ARC0000003818_0981295486.0001 61492
1 3819 E:\ARCHIVE\ARC0000003819_0981295486.0001 26813
1 3820 E:\ARCHIVE\ARC0000003820_0981295486.0001 82720
1 3821 E:\ARCHIVE\ARC0000003821_0981295486.0001 64333
1 3822 E:\ARCHIVE\ARC0000003822_0981295486.0001 59793
1 3823 E:\ARCHIVE\ARC0000003823_0981295486.0001 75450
1 3824 E:\ARCHIVE\ARC0000003824_0981295486.0001 60003
1 3825 E:\ARCHIVE\ARC0000003825_0981295486.0001 26103
1 3826 E:\ARCHIVE\ARC0000003826_0981295486.0001 62833
1 3827 E:\ARCHIVE\ARC0000003827_0981295486.0001 60069
DEST_ID SEQUENCE# NAME BLOCKS
---------- ---------- --------------------------------------------- ----------
1 3828 E:\ARCHIVE\ARC0000003828_0981295486.0001 65839
已选择56行。
查询归档日志
RMAN> crosscheck archivelog all;