ORA-19809: limit exceeded for recovery files-优快云博客

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 /