轉載於:清除歸檔日誌

1、清除歸檔日誌的方式

a、手動刪除

使用rm 或者find方式來刪除，透過該方式刪除之後，在RMAN下可以透過 crosscheck archivelog all 校驗歸檔是否失效，如下面的操作:

1

2

3

rm -rf arch_816906485_1_10.arc

find /u02/database/GOBO1/archive/ -ctime +0 -delete

RMAN> crosscheck archivelog all

b、使用RMAN方式清除

RMAN清除方式會自動清除磁碟上的歸檔日誌檔案，同時會釋放控制檔案中對應的歸檔日誌的歸檔資訊。

可以基於不同的條件來清除歸檔日誌，如基於SCN，基於SEQUENCE，基於TIME等方式。

對於上述的三種方式又可以配合from, until, between .. and .. 等等子句來限定範圍，方式靈活多變。

下面的命令用於校驗歸檔日誌的有效性，列出無效的歸檔日誌，以及以何種方式清除歸檔日誌，列出幾種常用的:

1

2

3

4

5

6

7

8

crosscheck archivelog all; ---&gt校驗日誌的可用性

list expired archivelog all; ---&gt列出所有失效的歸檔日誌

delete archivelog until sequence 16; ---&gt刪除log sequence為16及16之前的所有歸檔日誌

delete archivelog all completed before 'sysdate-7'; ---&gt刪除系統時間7天以前的歸檔日誌，不會刪除閃回區有效的歸檔日誌

delete archivelog all completed before 'sysdate - 1'; ---&gt同上，1天以前的

delete archivelog from time 'sysdate-1'; ---&gt注意這個命令，刪除系統時間1天以內到現在的歸檔日誌

delete noprompt archivelog all completed before 'sysdate'; ---&gt該命令清除所有的歸檔日誌

delete noprompt archivelog all; ---&gt同上一命令

2、演練使用RMAN清除歸檔日誌

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

[python]

robin@SZDB:~> export ORACLE_SID=GOBO1

robin@SZDB:~> rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Thu Jul 11 17:07:00 2013

connected to target database: GOBO1 (DBID=733951103)

RMAN> host;

robin@SZDB:~> cd /u02/database/GOBO1/archive/

robin@SZDB:/u02/database/GOBO1/archive> ls

arch_816906485_1_10.arc arch_816906485_1_12.arc

arch_816906485_1_11.arc arch_816906485_1_13.arc

............

robin@SZDB:/u02/database/GOBO1/archive> rm -rf arch_816906485_1_10.arc arch_816906485_1_11.arc arch_816906485_1_12.arc

robin@SZDB:/u02/database/GOBO1/archive> exit;

exit

host command complete

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=1075 devtype=DISK

archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_9.arc recid=2085 stamp=817211151

validation failed for archived log

archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_10.arc recid=2086 stamp=817250793

..............

validation succeeded for archived log

archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_90.arc recid=2166 stamp=820458049

Crosschecked 83 objects

RMAN> list expired archivelog all;

List of Archived Log Copies

Key Thrd Seq S Low Time Name

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

2086 1 10 X 20130604 11:05:51 /u02/database/GOBO1/archive/arch_816906485_1_10.arc

2087 1 11 X 20130604 22:06:17 /u02/database/GOBO1/archive/arch_816906485_1_11.arc

2088 1 12 X 20130605 19:30:53 /u02/database/GOBO1/archive/arch_816906485_1_12.arc

RMAN> delete archivelog until sequence 16;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=1075 devtype=DISK

List of Archived Log Copies

Key Thrd Seq S Low Time Name

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

2084 1 8 A 20130604 09:53:17 /u02/database/GOBO1/archive/arch_816906485_1_8.arc

.................

2092 1 16 A 20130607 22:03:23 /u02/database/GOBO1/archive/arch_816906485_1_16.arc

Do you really want to delete the above objects (enter YES or NO)? yes

...............

deleted archive log

archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_16.arc recid=2092 stamp=817516861

Deleted 9 objects

RMAN> delete archivelog all completed before 'sysdate-7';

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=1075 devtype=DISK

List of Archived Log Copies

Key Thrd Seq S Low Time Name

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

2093 1 17 A 20130608 00:01:00 /u02/database/GOBO1/archive/arch_816906485_1_17.arc

2094 1 18 A 20130608 18:00:17 /u02/database/GOBO1/archive/arch_816906485_1_18.arc

...........

deleted archive log

archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_72.arc recid=2148 stamp=819847035

Deleted 56 objects

RMAN> list copy of database archivelog all;

List of Archived Log Copies

Key Thrd Seq S Low Time Name

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

2149 1 73 A 20130703 23:17:13 /u02/database/GOBO1/archive/arch_816906485_1_73.arc

2150 1 74 A 20130704 22:00:19 /u02/database/GOBO1/archive/arch_816906485_1_74.arc

2151 1 75 A 20130704 22:04:40 /u02/database/GOBO1/archive/arch_816906485_1_75.arc

...............

2164 1 88 A 20130709 23:19:34 /u02/database/GOBO1/archive/arch_816906485_1_88.arc

2165 1 89 A 20130710 13:00:34 /u02/database/GOBO1/archive/arch_816906485_1_89.arc

2166 1 90 A 20130710 22:02:44 /u02/database/GOBO1/archive/arch_816906485_1_90.arc

RMAN> delete archivelog from time 'sysdate-1';

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=1075 devtype=DISK

List of Archived Log Copies

Key Thrd Seq S Low Time Name

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

2165 1 89 A 20130710 13:00:34 /u02/database/GOBO1/archive/arch_816906485_1_89.arc

2166 1 90 A 20130710 22:02:44 /u02/database/GOBO1/archive/arch_816906485_1_90.arc

Do you really want to delete the above objects (enter YES or NO)? yes

deleted archive log

archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_89.arc recid=2165 stamp=820447373

deleted archive log

archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_90.arc recid=2166 stamp=820458049

Deleted 2 objects

RMAN> delete archivelog all completed before 'sysdate - 1';

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=1075 devtype=DISK

List of Archived Log Copies

Key Thrd Seq S Low Time Name

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

2149 1 73 A 20130703 23:17:13 /u02/database/GOBO1/archive/arch_816906485_1_73.arc

.......................

2164 1 88 A 20130709 23:19:34 /u02/database/GOBO1/archive/arch_816906485_1_88.arc

Do you really want to delete the above objects (enter YES or NO)? yes

................

archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_88.arc recid=2164 stamp=820414835

Deleted 16 objects

RMAN> sql " alter system archive log current";

sql statement: alter system archive log current

RMAN> list copy of archivelog all;

List of Archived Log Copies

Key Thrd Seq S Low Time Name

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

2167 1 91 A 20130711 01:00:48 /u02/database/GOBO1/archive/arch_816906485_1_91.arc

RMAN> delete noprompt archivelog all completed before 'sysdate';

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=1075 devtype=DISK

List of Archived Log Copies

Key Thrd Seq S Low Time Name

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

2167 1 91 A 20130711 01:00:48 /u02/database/GOBO1/archive/arch_816906485_1_91.arc

deleted archive log

archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_91.arc recid=2167 stamp=820517964

Deleted 1 objects

3、清除歸檔日誌簡單的shell指令碼

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

[python]

#對於RAC環境或者ASM需要清除archive，使用shell指令碼呼叫RMAN是比較妥當的方式

#其次，如果你的archive位於閃回區，制定合理的保留策略，也可以讓Oracle自動老化無用的歸檔日誌

robin@SZDB:~/dba_scripts/custom/bin> more clean_arch.sh

# +-------------------------------------------------------+

# + Clean archived log as specified time |

# + Author : Robinson |

# + Blog : http://blog.csdn.net/robinson_0612 |

# + Usage : |

# + clean_arch.sh $ORACLE_SID |

# +-------------------------------------------------------+

#

#!/bin/bash

# --------------------

# Define variable

# --------------------

if [ -f ~/.bash_profile ]; then

. ~/.bash_profile

fi

if [ -z "${1}" ];then

echo "Usage: "

echo " `basename $0` ORACLE_SID"

exit 1

fi

ORACLE_SID=$1; export ORACLE_SID

$ORACLE_HOME/bin/rman log=/users/robin/log/rman.log <

connect target /

run{

crosscheck archivelog all;

delete noprompt expired archivelog all;

delete noprompt archivelog all completed before 'sysdate - 1';

}

exit;

EOF

rman清除歸檔日誌經典資料

相關文章