突然发现数据库不能连接说只能内部连接,重启机器后手动打开数据库,出现如下错误:
ORA-16038: log 1 sequence# 2183 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/oratvt/redo01.log'
查看数据库错误消息说是因为归档日志文件已经写满,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.我查看init.ora文件,并没有发现有db_recovery_file_dest_size 参数,
用 alter system archive stop 也不能commit,数据库不能打开,
请问怎么解决啊,归档模式的应用是一次做测试是设置的,忘了再改回来。
ORA-16038: log 1 sequence# 2183 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/oratvt/redo01.log'
查看数据库错误消息说是因为归档日志文件已经写满,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.我查看init.ora文件,并没有发现有db_recovery_file_dest_size 参数,
用 alter system archive stop 也不能commit,数据库不能打开,
请问怎么解决啊,归档模式的应用是一次做测试是设置的,忘了再改回来。
解决方案 »
- 这个语句怎么写??????????急求!!!!!!!!!!!
- 请教一个 需要写循环过程的问题,万分感谢!
- ORA-01017???
- 用了oracle application server 10g,可以在IE中打开login.frm,但点登录时总是出现invalid login setting
- 自定义TABLE类型数据,如何赋值给一个游标从存过中返回
- NEt中 的一个存存储考试的应用...在线等解决就给分
- 关于数据库热备份及其对系统性能的影响
- select能否选择出我要需要的显示形式?
- 9i,使用manager console,用登录到management server,在managerment server中填写了我机器的ip或机器名,用sysman/oem_temp,提示我输入
- 关于DECODE的问题,(我只有这点分了,解决后再加,谢谢了)
- Oracle备份的内容???
- formbuilder中HOST命令的问题
show parameter DB_RECOVERY_FILE_DEST_SIZE
increase the DB_RECOVERY_FILE_DEST_SIZE value and restart the database.
看到了这样的语句,但是并没有找到这个参数,手工添加也不成,关注!
alert里有什么别的error信息么?