ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORACLE10g下 ORA-19809 错误

ORACLE10g下 ORA-19809 错误

原创 Linux操作系统 作者:dukewyh 时间:2012-02-29 09:18:49 0 删除 编辑
在打开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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: ORACLE备份策略
请登录后发表评论 登录
全部评论

注册时间:2011-04-12

  • 博文量
    28
  • 访问量
    82269