ORA-16038: log 1 sequence# 59 cannot be archived
来源:互联网 发布:2017淘宝新手开店教程 编辑:程序博客网 时间:2024/06/01 14:43
请教:这个问题怎么处理?ORA-16038: log 1 sequence# 59 cannot be archived
alter database open
*
ERROR at line 1:
ORA-16038: log 1 sequence# 59 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: '/dev/vgdata/rora9_redo111'
ORA-00312: online log 1 thread 1: '/dev/vgdata/rora9_redo121'
使用alter system archive log stop以后还是无法打开数据库。
请大侠们支招。谢谢◎!
SQL> select group#, sequence# from v$log;
GROUP# SEQUENCE#
---------- ----------
1 59
2 60
3 62
4 61
SQL> alter database clear unarchived logfile group 1;
Database altered.
SQL> alter database open;
Database altered.
当时没能创建归档日志的原因是对归档文件夹的操作权限不够。赋予足够权限以后
SQL> alter system archive log start;
System altered.
就恢复正常了。
- ORA-16038: log 1 sequence# 59 cannot be archived
- ORA-16038: log 1 sequence# *cannot be archived
- ORA-16038: log 3 sequence# 4 cannot be archived
- ORA-16038: log 3 sequence# 6 cannot be archived错误
- ORA-16038: log 2 sequence# 1191 cannot be archived
- ORA-16038: log 2 sequence# 41 cannot be archived
- ORA-16038: log 3 sequence# 4 cannot be archived
- ORA-16014: log 4 sequence# 1 not archived , 今天解决了
- ORA-16014: log 2 sequence# not archived, no available destinations"
- ORA-16014: log 1 sequence# 23308 not archived, no available destinations,ORA-00312: online log 1 thread 1:
- 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 3 sequence# 540 not archived, no available destinations
- ORA-16014: log string sequence# string not archived, no available destinations F
- ORA-16014: log 4 sequence# 16 not archived, no available destinations
- RMAN-06059: expected archived log not found,ORA-19625
- rac archived log设置
- Thread 1 cannot allocate new log, sequence 210510
- ASP.NET服务器控件的生命周期
- 表B 数据 插入表A
- CVS安装及CVS整合MyEclipse
- Image在内存中占用的空间计算
- bash_profile的用法
- ORA-16038: log 1 sequence# 59 cannot be archived
- 更新nc_cbry 联系地址
- fork两次如何避免僵尸进程收藏
- 根据 身份证号 生成出生日期
- 修改窗口背景色
- 最近不少网友问我关于笔记本显卡的性能排名怎么样
- Oracle数据库字符集问题解析
- 看3G 带来新的机遇
- 在wince4.2下加载16C550串口驱动——转载(作者:gerryzhou)