通过上面的信息,发现只到11%多,还好。如果满了,咱办呢?
[oracle@db1 ~]$ rman target /
Recovery Manager: Release 10.1.0.5.0 - Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
connected to target database: URPDB (DBID=2772226681)
RMAN>
RMAN>delete archivelog all;
RMAN>exit
[oracle@db1 ~]$ sqlplus /nolog
SQL*Plus: Release 10.1.0.5.0 - Production on Thu Nov 29 13:39:50 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> SELECT space_limit/1024/1024/1024 AS "Quota_G",space_used/1024/1024 AS "Used_M",space_used/space_limit*100 "Used_%",space_reclaimable AS reclaimable,number_of_files AS files FROM v$recovery_file_dest ;
Quota_G Used_M Used_% RECLAIMABLE FILES
---------- ---------- ---------- ----------- ----------
20 0 0 0 0
SQL>
嘿嘿,都清除了。
注意:上面操作有风险,除非知道自己在做什么,不然不要乱来,出了事情,自己负责哦!!!
