ORACLE10g下 ORA-19809 錯誤

dukewyh發表於2012-02-29
Oracle
在開啟ORACLE資料庫的時候，系統報錯：
 
SQL> startup
ORACLE 例程已經啟動。
Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             218106756 bytes
Database Buffers          385875968 bytes
Redo Buffers                7135232 bytes
資料庫裝載完畢。
ORA-16038: 日誌 2 序列號 54 無法歸檔
ORA-19809: 超出了恢復檔案數的限制
ORA-00312: 聯機日誌 2 執行緒 1:
'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'
 
檢視recovery dest:
 
SQL> show parameter recovery
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      F:\oracle\product\10.2.0/flash
                                                 _recovery_area
db_recovery_file_dest_size           big integer 2G
recovery_parallelism                 integer     0
 
修改db_recovery_file_dest_size:
 
SQL> alter system set db_recovery_file_dest_size=4g scope=both;
系統已更改。
SQL> alter database open;
資料庫已更改
 
至此資料庫正常開啟.
 
 
查了一下錯誤資訊，原來說得很明白。
ORA-19809: limit exceeded for recovery files
Cause: The limit for recovery files specified by the DB_RECOVERY_FILE_DEST_SIZE was exceeded.
Action: The error is accompanied by 19804. See message 19804 for further details.
ORA-19804: cannot reclaim string bytes disk space from string limit
Cause: Oracle cannot reclaim disk space of specified bytes from the DB_RECOVERY_FILE_DEST_SIZE limit.
Action:

There are five possible solutions:

1) Take frequent backup of recovery area using RMAN.

2) Consider changing RMAN retention policy.

3) Consider changing RMAN archivelog deletion policy.

4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.

5) Delete files from recovery area using RMAN.

 
 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/15592508/viewspace-717335/，如需轉載，請註明出處，否則將追究法律責任。

相關文章