rman删除所有归档
一个系统准备上线,厂商想把所有以产生的归档删除,命令如下:
1 2 3 4 5 6 7 8 9 |
[oracle@prod ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Wed Mar 26 03:33:36 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: PROD (DBID=252572275) RMAN> delete archivelog all completed before 'sysdate'; |
当然如果想删除n天前的,那么可以写成delete archivelog all completed before ‘sysdate-n’;