首页 > 代码库 > Oracle 闪回区满解决的方法
Oracle 闪回区满解决的方法
闪回区满:
OS: rm -rf [archivelog autobackup backupset controlfile flashback onlinelog]
eg :
archivelog autobackup backupset controlfile flashback onlinelog
[oracle@jibo PROD]$ cd autobackup/
[oracle@jibo autobackup]$ ls
2014_10_13 2014_10_15 2014_10_16
[oracle@jibo autobackup]$ rm -rf 2014_10_13
[oracle@jibo autobackup]$ rm -rf 2014_10_15
RMAN:
RMAN> crosscheck backup;
RMAN> delete expired backup;
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
sqlplus:
SYS@PROD>show parameter db_re
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/fast_recovery_
area
db_recovery_file_dest_size big integer 4G
db_recycle_cache_size big integer 0
SYS@PROD>desc v$recovery_area_usage;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_TYPE VARCHAR2(20)
PERCENT_SPACE_USED NUMBER
PERCENT_SPACE_RECLAIMABLE NUMBER
NUMBER_OF_FILES NUMBER
SYS@PROD>select sum(PERCENT_SPACE_USED) from v$recovery_area_usage;
SUM(PERCENT_SPACE_USED)
-----------------------
33.45
Oracle 闪回区满解决的方法