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.
请教各位这是怎么回事?
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了,你还是先试试上面给你的语句吧,看手工归档有没有什么错误信息出来