處理Oracle數(shù)據(jù)庫閃回區(qū)空間滿的問題

處理Oracle數(shù)據(jù)庫閃回區(qū)空間滿的問題

作者：趙全文  網(wǎng)名：guestart

今天早上一到單位，發(fā)現(xiàn)EMCC上有一臺(tái)數(shù)據(jù)庫服務(wù)器的概覽頁面出現(xiàn)×××報(bào)警，

查詢alert_orcl13.log發(fā)現(xiàn)如下報(bào)錯(cuò)，

Errors in file /u01/app/oracle/diag/rdbms/orcl13/orcl13/trace/orcl13_arc3_34080.trc:

ORA-19815: WARNING: db_recovery_file_dest_size of 68719476736 bytes is 100.00% used, and has 0 remaining bytes available.

  system command was used to delete files, then use RMAN CROSSCHECK and

************************************************************************

DELETE EXPIRED commands.

You have following choices to free up spacefrom recovery area:

************************************************************************

1. Consider changing RMAN RETENTION POLICY.If you are using Data Guard,

ARC0: Error 19809 Creating archive log fileto '+DATA'

  then consider changing RMAN ARCHIVELOG DELETION POLICY.

2. Back up files to tertiary device such astape using RMAN

  BACKUP RECOVERY AREA command.

3. Add disk space and increasedb_recovery_file_dest_size parameter to

  reflect the new space.

4. Delete unnecessary files using RMANDELETE command. If an operating

  system command was used to delete files, then use RMAN CROSSCHECK and

  DELETE EXPIRED commands.

************************************************************************

發(fā)現(xiàn)閃回區(qū)的容量已經(jīng)達(dá)到100%，于是查找閃回區(qū)的容量當(dāng)前為多少G？

SYS@orcl13> show parameterdb_recovery_file_dest_size;

NAME                   TYPE        VALUE

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

db_recovery_file_dest_size    big integer    64G

增大閃回區(qū)的容量為100G

順便查看一下歸檔文件所在的位置，

噢，頓時(shí)明白，是歸檔文件保存在閃回區(qū)，把閃回區(qū)的容量撐爆了。

歸檔文件一直在增加，有也可能是用rman備份的時(shí)候，沒有設(shè)置歸檔日志的清除策略，也有可能是沒有進(jìn)行rman備份。

查看一下是否進(jìn)行了rman備份

原來是沒有進(jìn)行rman備份，由于是測(cè)試庫，在開啟歸檔功能以后，沒有用rman備份導(dǎo)致的

現(xiàn)在把rman備份開啟

再次查看alert_orcl13.log的日志文件，已經(jīng)切換歸檔操作，一切正常了。

如您覺得此篇文章對(duì)您有幫助，歡迎關(guān)注微信公眾號(hào)：guestart的DBA學(xué)習(xí)筆記，您的支持是對(duì)我最大的鼓勵(lì)！