SQL> archive log list;
数据库日志模式 存档模式
自动存档 启用
存档终点 D:\oracle\ora90\RDBMS
最早的概要日志序列 108
下一个存档日志序列 110
当前日志序列 110
SQL>当数据库进行自动归档时会发生
Warning - The following error occured during ORACLE redo log archival:
ORACLE Instance mydata - Can not allocate log, archival required
Press <ENTER> to acknowledge message.
请教各位这是怎么回事?
数据库日志模式 存档模式
自动存档 启用
存档终点 D:\oracle\ora90\RDBMS
最早的概要日志序列 108
下一个存档日志序列 110
当前日志序列 110
SQL>当数据库进行自动归档时会发生
Warning - The following error occured during ORACLE redo log archival:
ORACLE Instance mydata - Can not allocate log, archival required
Press <ENTER> to acknowledge message.
请教各位这是怎么回事?
解决方案 »
- 有没有人啊?这个问题我都问两天了,有没有人能回答啊?
- 如何删除指定某一列里的所有数据 保留列名 sql语句
- oracle 全盘备份语句问题
- 判断小数位大于二位
- Oracle 为何不是条件越多查询越快?
- java applet+jdk+tomcat
- ORA-00600: 内部错误代码,参数: [qks3tInit], [], [], [], [], [], [], []
- ORACLE9I在登录SQLPlus Worksheet时输入用户,密码,服务名。我想问的是服务名每次登录都得手工输入吗?没有选项的吗?
- oracle里快照删不掉,点了删除很久都没反应?
- oracle sql 新人求助
- oracle 数据文件是什么格式??
- 遭遇ORA-00600错误,求高手相助
2.部分警告日志文件内容
....
ARC3: Unable to archive log 1 thread 1 sequence 106
Log actively being archived by another process
Sat Jun 06 11:07:53 2009
ARC4: Beginning to archive log 1 thread 1 sequence 106
ARC4: Unable to archive log 1 thread 1 sequence 106
Log actively being archived by another process
Sat Jun 06 11:07:53 2009
ARC3: Beginning to archive log 2 thread 1 sequence 108
Sat Jun 06 11:07:53 2009
ARC4: Beginning to archive log 2 thread 1 sequence 108
ARC4: Unable to archive log 2 thread 1 sequence 108
Log actively being archived by another process
Sat Jun 06 11:07:53 2009
Thread 1 cannot allocate new log, sequence 110
All online logs needed archiving
Current log# 3 seq# 109 mem# 0: D:\ORACLE\ORADATA\MYDATA\REDO03.LOG
Sat Jun 06 11:07:53 2009
ARC3: Completed archiving log 2 thread 1 sequence 108
Sat Jun 06 11:07:54 2009
ARC0: Beginning to archive log 1 thread 1 sequence 106
ARC0: Unable to archive log 1 thread 1 sequence 106
Log actively being archived by another process
Sat Jun 06 11:07:54 2009
ARC2: Beginning to archive log 1 thread 1 sequence 106
ARC2: Unable to archive log 1 thread 1 sequence 106
Log actively being archived by another process
Sat Jun 06 11:07:55 2009
ARC3: Beginning to archive log 1 thread 1 sequence 106
ARC3: Unable to archive log 1 thread 1 sequence 106
Log actively being archived by another process
Sat Jun 06 11:07:56 2009
ARC4: Beginning to archive log 1 thread 1 sequence 106
ARC4: Unable to archive log 1 thread 1 sequence 106
Log actively being archived by another process
Sat Jun 06 11:07:57 2009
ARC0: Beginning to archive log 1 thread 1 sequence 106
ARC0: Unable to archive log 1 thread 1 sequence 106
Log actively being archived by another process
Sat Jun 06 11:07:58 2009
ARC2: Beginning to archive log 1 thread 1 sequence 106
ARC2: Unable to archive log 1 thread 1 sequence 106
Log actively being archived by another process
Sat Jun 06 11:07:59 2009
ARC3: Beginning to archive log 1 thread 1 sequence 106
ARC3: Unable to archive log 1 thread 1 sequence 106
Log actively being archived by another process
Sat Jun 06 11:08:00 2009
ARC4: Beginning to archive log 1 thread 1 sequence 106
ARC4: Unable to archive log 1 thread 1 sequence 106
Log actively being archived by another process
Sat Jun 06 11:08:01 2009
ARC0: Beginning to archive log 1 thread 1 sequence 106
ARC0: Unable to archive log 1 thread 1 sequence 106
Log actively being archived by another process
Sat Jun 06 11:08:02 2009
ARC2: Beginning to archive log 1 thread 1 sequence 106
ARC2: Unable to archive log 1 thread 1 sequence 106
Log actively being archived by another process
Sat Jun 06 11:08:02 2009
ARC1: Completed archiving log 1 thread 1 sequence 106
Sat Jun 06 11:08:03 2009
Thread 1 advanced to log sequence 110
Current log# 1 seq# 110 mem# 0: D:\ORACLE\ORADATA\MYDATA\REDO01.LOG
Sat Jun 06 11:08:03 2009
ARC4: Beginning to archive log 3 thread 1 sequence 109
ARC4: Completed archiving log 3 thread 1 sequence 109
Sat Jun 06 11:45:21 2009
Restarting dead background process EMN0
EMN0 started with pid=19
Sat Jun 06 11:45:21 2009
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water = 3
Sat Jun 06 11:45:29 2009
ALTER DATABASE CLOSE NORMAL
Sat Jun 06 11:45:30 2009
SMON: disabling tx recovery
SMON: disabling cache recovery mydataALRT1.txt (258.48 KB)
3.SQL> select group#,sequence#,archived,status,bytes from v$log; GROUP# SEQUENCE# ARC STATUS BYTES
---------- ---------- --- ---------------- ----------
1 110 NO CURRENT 104857600
2 108 YES INACTIVE 1048576
3 109 YES INACTIVE 1048576日志文件大小采用默认值,100M
你用手工归档在sqlplus里试试,看有什么样的信息出来SQL>alter system log current;
==================================================================
Inthirties关注Oracle数据库 维护 优化,安全,备份,恢复,迁移,故障处理如果你需要帮助或想和我一起学习的请联系
联系方式QQ:370140387
电子邮件:[email protected]
网站: http://www.inthirties.com
这里你的log 1的大小和log 2,3不是一样的通过日志,你的log 1的archive时间稍长,但是最后还是成功了哟,seq 110是新的log 1拿到的seq,上一个log 1的seq是106已经archived了,你还是先试试上面给你的语句吧,看手工归档有没有什么错误信息出来