Oracle 闪回区满解决办法

古城微笑少年丶 2022-08-13 08:00 185阅读 0赞

闪回区满:  
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][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][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][SYS_PROD_select] sum(PERCENT\_SPACE\_USED) from v$recovery\_area\_usage;

SUM(PERCENT\_SPACE\_USED)  
\-----------------------  
                  33.45

[SYS_PROD_show]: mailto:SYS@PROD>show
[SYS_PROD_desc]: mailto:SYS@PROD>desc
[SYS_PROD_select]: mailto:SYS@PROD>select