首页 > 代码库 > 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 闪回区满解决的方法