突然发现数据库不能连接说只能内部连接,重启机器后手动打开数据库,出现如下错误:
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,数据库不能打开,
请问怎么解决啊,归档模式的应用是一次做测试是设置的,忘了再改回来。
解决方案 »
- 求助一个关于全表扫描的问题
- ORACLE 10G基本界面,谢谢
- Oracle9i数据库系统优化与调整,决对是一本好书
- Oracle Grant select问题
- 怎么把sql server数据库转成oracle10G数据库
- 关于自身连接的问题?这样为什么结果不一样?
- 在oracle 9i安装中遇到的问题,关于JDK home directory ?请帮忙解答,100分酬谢!!!
- linux8+oracle9.2.0安装好了后,dbca和netmgr都不能运行;请大虾帮忙
- 数据库中的数据怎么变味儿了?
- 我建立的序列,但自增长有问题。
- Oracle备份的内容???
- formbuilder中HOST命令的问题
show parameter DB_RECOVERY_FILE_DEST_SIZE
increase the DB_RECOVERY_FILE_DEST_SIZE value and restart the database.
看到了这样的语句,但是并没有找到这个参数,手工添加也不成,关注!
alert里有什么别的error信息么?