oracle闪回占满,Oracle 闪回区满解决的方法

闪回区满:

OS: rm -rf [archivelog  autobackup  backupset  controlfile  flashback  onlinelog]

eg :

archivelog  autobackup  backupset  controlfile  flashback  onlinelog

[[email protected] PROD]$ cd autobackup/

[[email protected] autobackup]$ ls

2014_10_13  2014_10_15  2014_10_16

[[email protected] autobackup]$ rm -rf 2014_10_13

[[email protected] autobackup]$ rm -rf 2014_10_15

RMAN:

RMAN> crosscheck backup;

RMAN> delete expired backup;

RMAN> crosscheck archivelog all;

RMAN> delete expired archivelog all;

sqlplus：

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

[email protected]>desc v$recovery_area_usage;

Name                                      Null?    Type

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

FILE_TYPE                                          VARCHAR2(20)

PERCENT_SPACE_USED                                 NUMBER

PERCENT_SPACE_RECLAIMABLE                          NUMBER

NUMBER_OF_FILES                                    NUMBER

[email protected]>select sum(PERCENT_SPACE_USED) from v$recovery_area_usage;

SUM(PERCENT_SPACE_USED)

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

33.45