ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-19809: limit exceeded for recovery files

ORA-19809: limit exceeded for recovery files

原创 Linux操作系统 作者:startforever 时间:2013-05-15 15:55:27 0 删除 编辑
SQL> startup
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1375792 bytes
Variable Size             654311888 bytes
Database Buffers          411041792 bytes
Redo Buffers                4603904 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 10780
Session ID: 191 Serial number: 3

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1375792 bytes
Variable Size             654311888 bytes
Database Buffers          411041792 bytes
Redo Buffers                4603904 bytes
Database mounted.
 
找到alter 目录,去检查alter日志。
SQL> show parameter dump;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      d:\oralce11\diag\rdbms\orcl\or
                                                 cl\trace
core_dump_dest                       string      d:\oralce11\diag\rdbms\orcl\or
                                                 cl\cdump
max_dump_file_size                   string      unlimited
shadow_core_dump                     string      none
user_dump_dest                       string      d:\oralce11\diag\rdbms\orcl\or
                                                 cl\trace
 
alter 日志报错:
Errors in file d:\oralce11\diag\rdbms\orcl\orcl\trace\orcl_ora_10780.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 5218762752 bytes is 100.00% used, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************
Errors in file d:\oralce11\diag\rdbms\orcl\orcl\trace\orcl_ora_10780.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 35803136 bytes disk space from 5218762752 limit
ARCH: Error 19809 Creating archive log file to 'D:\ORALCE11\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2013_05_15\O1_MF_1_283_%U_.ARC'
Errors in file d:\oralce11\diag\rdbms\orcl\orcl\trace\orcl_ora_10780.trc:
ORA-16038: log 1 sequence# 283 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'D:\ORALCE11\ORADATA\ORCL\REDO01.LOG'
USER (ospid: 10780): terminating the instance due to error 16038
ARC1: Archival started
Errors in file d:\oralce11\diag\rdbms\orcl\orcl\trace\orcl_arc0_13000.trc:
ORA-01092: ORACLE 实例终止。强制断开连接
ARC0: Detected ARCH process failure
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Archival disabled due to shutdown: 1092
Shutting down archive processes
Archiving is disabled
Instance terminated by USER, pid = 10780
Wed May 15 15:48:15 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is enabled
 
修改db_recovery_file_dest_size
SQL> alter system set db_recovery_file_dest_size=10G scope=both;

System altered.

SQL> alter database open;

Database altered.
 
另外的方法是可以删除过期的归档日志:
特别提醒--只是删除物理文件不做其他操作是不行的。空间是不会清空的。可以通过
select * from v$recovery_file_dest;
这条语句确认是否归档日志用了多少空间
 
--清理归档日志
1.rman
2.connect target /
3.crosscheck archivelog all;
4.delete expired archivelog all;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28743704/viewspace-761179/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-03-22

  • 博文量
    106
  • 访问量
    65542