oracle 归档日志满了,sqlplus中无法执行sql语句.

[koujm]

oracle 归档日志满了,sqlplus中无法执行sql语句.
请问各位大侠如何解决?

[leborety]

删除你不要的归档日志

[jim668]

创建新的 归档日志 文件

[xcwwebmaster]

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.
看了文档：
我现在能打开数据库了
步骤如下：
1、create pfile='d:\initperson.ora' from spfile='D:\oracle\database\spfileperson.ora';
2、shutdown immediate;
3、增大init.ora中DB_RECOVERY_FILE_DEST_SIZE的值
4、startup pfile='d:\init.ora'
可以正常访问了。

当然，也可以删除掉部分归档日志

[koujm]

Thanks

[lilygt]

学习

[gwdhlx]

将归档模式修改为非归档模式.

[gwdhlx]

alter database noarchivelog; -----将当前的归档模式转换为非归档模式数据库已更改。