ORACLE10g下 ORA-19809 错误

在打开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;

数据库已更改

 

至此数据库正常打开.

 

查看 http://dbadiary.spaces.live.com/blog/cns!A3ECB1FE1E761C58!921.entry

 

查了一下错误信息，原来说得很明白。

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15592508/viewspace-717335/