ORA-16038: log 3 sequence# 4 cannot be archived
来源:互联网 发布:淘宝里的表情序号 编辑:程序博客网 时间:2024/06/11 00:45
db:oracle11.2.0.1
os:redhat5.3
数据库在启动的时候报如下错误:
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 71305460 bytes
Database Buffers 92274688 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-16038: log 3 sequence# 4 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 3 thread 1:
'/opt/oracle/product/11.2.0/oradata/primary/redo03.log'
从报错信息上可以看出来是归档的日志出错。
查看日志的信息:
SQL> select group#,sequence# from v$log;
GROUP# SEQUENCE#
---------- ----------
1 5
3 4
2 6
清除出错的日志文件:
SQL> alter database clear unarchived logfile group 3;
Database altered.
启动数据库
SQL> alter database open;
Database altered.
重新启用归档:
SQL> alter system archive log start;
System altered.
- ORA-16038: log 3 sequence# 4 cannot be archived
- ORA-16038: log 3 sequence# 4 cannot be archived
- ORA-16038: log 3 sequence# 6 cannot be archived错误
- ORA-16038: log 1 sequence# 59 cannot be archived
- ORA-16038: log 2 sequence# 1191 cannot be archived
- ORA-16038: log 2 sequence# 41 cannot be archived
- ORA-16038: log 1 sequence# *cannot be archived
- ORA-16014: log 4 sequence# 1 not archived , 今天解决了
- ORA-16014: log 4 sequence# 16 not archived, no available destinations
- ORA-16014: log 3 sequence# 540 not archived, no available destinations
- ORA-16014: log 2 sequence# not archived, no available destinations"
- ORA-16014: log string sequence# string not archived, no available destinations Flash Recovery Area 空间不足
- ORA-16014: log string sequence# string not archived, no available destinations Flash Recovery Area
- ORA-16014: log string sequence# string not archived, no available destinations F
- ORA-16014: log 1 sequence# 23308 not archived, no available destinations,ORA-00312: online log 1 thread 1:
- RMAN-06059: expected archived log not found,ORA-19625
- rac archived log设置
- ogg数据同步停止OGG-00446 Could not find archived log for sequence
- 谁那有j2EE的 在局域网内IP扫描得到在线机器的相关信息源代码 麻烦分享一下 谢谢了。
- java restore database
- Adobe AIR的Android应用
- Bug 7007594 - ORA-600 [12261] at DBMS_REDEFINITION.FINISH_REDEF_TABLE of partitioned table [ID 7007594.8]
- oracle 视图 创建 操作 简单 复杂 基表 不存在 增 删 改 插入 修改 删除 查看 结构
- ORA-16038: log 3 sequence# 4 cannot be archived
- hashCode与equals Set 集合排序
- C#中HashTable的用法
- C#文件读写、操作与监控
- PowerManager File path
- ASP.NET为textbox 添加 失去焦点事件 和回车失去焦点
- How To Partition Existing Table Using DBMS_Redefinition [ID 472449.1]
- Windows Mobile中如何使PicturesBox控件上的Label控件背景透明
- CString 转化为 const char*的方法(经验证) “0x77d287f1”指令引用的“0x00000000”内存。该内存不能为“written”。