删除过多的归档日志释放空间

最新推荐文章于 2024-06-18 10:56:33 发布

blockheading

最新推荐文章于 2024-06-18 10:56:33 发布

阅读量1.6k

点赞数

分类专栏： Oracle Backup/Recovery

本文链接：https://blog.csdn.net/u013169075/article/details/54710542

版权

本文介绍如何删除过多的归档日志，从而有效地释放存储空间。

摘要由CSDN通过智能技术生成

--删除过多的归档日志释放空间

1.备份现有归档日志到备份磁盘

2.释放空间

--实验过程

--通过RMAN查看现有归档

RMAN> list copy;  --通过RMAN查看现有归档

specification does not match any control file copy in the repository
List of Datafile Copies
=======================

Key     File S Completion Time Ckp SCN    Ckp Time       
------- ---- - --------------- ---------- ---------------
1       19   A 10-JAN-17       4300404862 10-JAN-17      
        Name: /u01/app/oracle/oradata/PROD2/tt.dbf
        Tag: TAG20170110T160603

List of Archived Log Copies for database with db_unique_name PROD1
=====================================================================

Key     Thrd Seq     S Low Time 
------- ---- ------- - ---------
1       1    5       A 10-DEC-16
        Name: /u01/app/oracle/logbak/1_5_929997369.dbf

2       1    5       A 10-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_5_929997369.dbf

3       1    6       A 11-DEC-16
        Name: /u01/app/oracle/logbak/1_6_929997369.dbf

4       1    6       A 11-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_6_929997369.dbf

5       1    7       A 11-DEC-16
        Name: /u01/app/oracle/logbak/1_7_929997369.dbf

6       1    7       A 11-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_7_929997369.dbf

7       1    8       A 11-DEC-16
        Name: /u01/app/oracle/logbak/1_8_929997369.dbf

8       1    8       A 11-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_8_929997369.dbf

9       1    9       A 11-DEC-16
        Name: /u01/app/oracle/logbak/1_9_929997369.dbf

10      1    9       A 11-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_9_929997369.dbf

11      1    10      A 11-DEC-16
        Name: /u01/app/oracle/logbak/1_10_929997369.dbf

12      1    10      A 11-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_10_929997369.dbf

13      1    11      A 25-DEC-16
        Name: /u01/app/oracle/logbak/1_11_929997369.dbf

14      1    11      A 25-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_11_929997369.dbf

16      1    12      A 25-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_12_929997369.dbf

15      1    12      A 25-DEC-16
        Name: /u01/app/oracle/logbak/1_12_929997369.dbf

25      1    13      A 25-DEC-16
        Name: /u01/app/oracle/logbak/1_13_929997369.dbf

26      1    13      A 25-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_13_929997369.dbf

17      1    13      A 25-DEC-16
        Name: /u01/app/oracle/logbak/1_13_929997369.dbf

18      1    13      A 25-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_13_929997369.dbf

23      1    14      A 26-DEC-16
        Name: /u01/app/oracle/logbak/1_14_929997369.dbf

24      1    14      A 26-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_14_929997369.dbf

20      1    14      A 26-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_14_929997369.dbf

19      1    14      A 26-DEC-16
        Name: /u01/app/oracle/logbak/1_14_929997369.dbf

22      1    15      A 29-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_15_929997369.dbf

21      1    15      A 29-DEC-16
        Name: /u01/app/oracle/logbak/1_15_929997369.dbf

27      1    1       A 29-DEC-16
        Name: /u01/app/oracle/logbak/1_1_931902281.dbf

28      1    1       A 29-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_1_931902281.dbf

29      1    2       A 30-DEC-16
        Name: /u01/app/oracle/logbak/1_2_931902281.dbf

30      1    2       A 30-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_2_931902281.dbf

31      1    3       A 30-DEC-16
        Name: /u01/app/oracle/logbak/1_3_931902281.dbf

32      1    3       A 30-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_3_931902281.dbf

33      1    4       A 30-DEC-16
        Name: /u01/app/oracle/logbak/1_4_931902281.dbf

34      1    4       A 30-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_4_931902281.dbf

35      1    5       A 30-DEC-16
        Name: /u01/app/oracle/logbak/1_5_931902281.dbf

36      1    5       A 30-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_5_931902281.dbf

37      1    6       A 30-DEC-16
        Name: /u01/app/oracle/logbak/1_6_931902281.dbf

38      1    6       A 30-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/1_6_931902281.dbf

39      1    7       A 30-DEC-16
        Name: /u01/app/oracle/logbak/1_7_931902281.dbf

40      1    7       A 30-DEC-16
        Name: /u01/app/oracle/fast_recovery_area/PROD1/a