在打开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博客

ORACLE10g下 ORA-19809 错误

最新文章