ORA-16038,ORA-19809,ORA-00312
来源:互联网 发布:网络暑假工招聘 编辑:程序博客网 时间:2024/04/30 19:58
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-16038: 日志 1 序列号 74 无法归档
ORA-19809: 超出了恢复文件数的限制
ORA-00312: 联机日志 1 线程 1:
'C:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO01.LOG'
解决办法;
$rman
RMAN>connect target /
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
RMAN>exit
There are a couple of possible options.
1) Increase the parameter db_recovery_file_dest_size
2) Stop using the db_recovery_file_dest by unsetting the parameter. (This assumes you never really wanted to use this option)
3) Remove the Entries from the rman repository/Controlfile
The removal is desribed in the RMAN documentation but this is a quick and dirty way if you don't have an rman repository - but could endanger your ability to recover - so be careful.
a) delete unwanted archive log files from disk (rm, del commands)
b) connect to rman ( RMAN> connect target / )
c) RMAN> crosscheck archivelog all; - marks the controlfile that the archives have been deleted d) RMAN> delete expired archivelog all; - deletes the log entries identified above
- ORA-16038,ORA-19809,ORA-00312
- ORA-16038,ORA-19809,ORA-00312
- ORA-16038,ORA-19809,ORA-00312问题解决
- ORA-16038:ORA-19809:ORA-00312:
- ORA-16038、ORA-19809、ORA-00312问题的学习总结
- ora-16038 ora-19809 ora-00312 解决过程
- ORA-16038 ORA-19809 ORA-00312 错误解决
- 特殊恢复ORA-00312 ORA-19809 ORA-16038
- ORA
- ora
- ORA-19809&&ORA-03113
- ORA-16038&ORA-00257
- ORA-16014:ORA-00312:
- ORA-16014:ORA-00312
- ORA-00314;ORA-00312
- ORA-00312 ,ORA-00313
- ORA-16038 ORA-19502 ORA-00312错误案例
- Oracle故障处理 ORA-16038 ORA-19502 ORA-00312
- C# 线程同步问题(存档)
- j2me 开发的双色球机选小程序
- JDBC编程步骤实例
- linux——vi编辑器基本使用方法
- SQL Alias
- ORA-16038,ORA-19809,ORA-00312
- eclipse颜色设置以及常用快捷键
- C# 异步调用(存档)
- Servlet笔记
- 唐骏资料
- COM编程入门
- 《程序员》火热七月:中国ISV生存现状调查报告
- String和StringBuffer的区别
- 关于 FROM tableA,tableB 和 tableA LEFT JOIN tableB on 的区别