oracle删除小时前归档,rman 删除指定时间点的归档日志

在论坛上看到有人提问要删除指定时间点之前的归档日志，根据大家的回答，我也简单的进行了以下测试，以下是测试过程：

RMAN> list archivelog all;

List of Archived Log Copies

Key     Thrd Seq     S Low Time            Name

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

74      1    47      A 2012-11-23 02:45:35 /ora10g/arch/1_47_797703448.dbf

75      1    48      A 2012-11-26 19:19:02 /ora10g/arch/1_48_797703448.dbf

76      1    49      A 2012-11-26 19:41:53 /ora10g/arch/1_49_797703448.dbf

77      1    50      A 2012-11-27 01:53:45 /ora10g/arch/1_50_797703448.dbf

78      1    51      A 2012-11-28 01:00:44 /ora10g/arch/1_51_797703448.dbf

79      1    52      A 2012-11-28 22:27:35 /ora10g/arch/1_52_797703448.dbf

80      1    53      A 2012-11-29 05:50:56 /ora10g/arch/1_53_797703448.dbf

81      1    54      A 2012-11-29 22:00:33 /ora10g/arch/1_54_797703448.dbf

RMAN>

RMAN> delete archivelog all completed before 'trunc(sysdate-1)+2/24';

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=257 devtype=DISK

List of Archived Log Copies

Key     Thrd Seq     S Low Time            Name

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

74      1    47      A 2012-11-23 02:45:35 /ora10g/arch/1_47_797703448.dbf

75      1    48      A 2012-11-26 19:19:02 /ora10g/arch/1_48_797703448.dbf

76      1    49      A 2012-11-26 19:41:53 /ora10g/arch/1_49_797703448.dbf

77      1    50      A 2012-11-27 01:53:45 /ora10g/arch/1_50_797703448.dbf

78      1    51      A 2012-11-28 01:00:44 /ora10g/arch/1_51_797703448.dbf

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

deleted archive log

archive log filename=/ora10g/arch/1_47_797703448.dbf recid=74 stamp=800392743

deleted archive log

archive log filename=/ora10g/arch/1_48_797703448.dbf recid=75 stamp=800394114

deleted archive log

archive log filename=/ora10g/arch/1_49_797703448.dbf recid=76 stamp=800416426

deleted archive log

archive log filename=/ora10g/arch/1_50_797703448.dbf recid=77 stamp=800499645

deleted archive log

archive log filename=/ora10g/arch/1_51_797703448.dbf recid=78 stamp=800576855

Deleted 5 objects

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11590946/viewspace-750335/，如需转载，请注明出处，否则将追究法律责任。