表空间 下面的 数据文件 自动脱机 本帖最后由 guojh021 于 2009-12-21 14:23:41 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 怎么会没有呢,可能是你没理解好SID的意思举个例子:D:\oracle\admin\ora8\bdump SID相当于实例的名称吧.数据库名称为aaa就是D:\oracle\admin\aaa\bdump是这样吧? E:\oracle\product\10.1.0\admin\orcl\bdump\alert_sid的名字.log 错误信息搞出来了,高手看看有啥解决办法不?谢谢.Event Type: ErrorEvent Source: Oracle.tangEvent Category: NoneEvent ID: 20Date: 12/13/2009Time: 8:01:42 PMUser: N/AComputer: INTCN60110002Description:Archive process error: ORACLE Instance tang - Archival Error.-------------------------------------Event Type: ErrorEvent Source: Oracle.tangEvent Category: NoneEvent ID: 20Date: 12/13/2009Time: 8:01:42 PMUser: N/AComputer: INTCN60110002Description:Archive process error: ORA-16014: log 2 sequence# 14627 not archived, no available destinationsORA-00312: online log 2 thread 1: 'H:\ALODB\REDOLOG\REDO2.LOG'ORA-00312: online log 2 thread 1: 'F:\ALODB\REDOLOG\REDO2.LOG'--------------------------------------------------------Event Type: ErrorEvent Source: Oracle.tangEvent Category: NoneEvent ID: 20Date: 12/14/2009Time: 10:03:03 AMUser: N/AComputer: INTCN60110002Description:Archive process error: ORACLE Instance tang - Can not allocate log, archival required 你上面的错误是联机日志无法归档的错误,因为归档路径无效。这个错误会让数据库hang,但不会让数据文件脱机的,你再看看别的错误。 plsql中关于包的问题!求解释 在原有表上新增一列(很有挑战性) 急求oracle导出报错信息解决 谢谢~在线等 请教诸位高手一个很基础的trigger问题 sql分页 SQL难句求教!多表查询与统计 请教:关于Oracle Web Cache 如何将Cursor返回到前端语言(C#, VB, Java之类)中去. 菜鸟问题:没有监听器 各位大侠请看一下---存储过程的返回记录问题 Win7上安装oracle9i 问个有关时间问题的sql语句
举个例子:D:\oracle\admin\ora8\bdump
SID相当于实例的名称吧.
数据库名称为aaa
就是D:\oracle\admin\aaa\bdump是这样吧?
Event Source: Oracle.tang
Event Category: None
Event ID: 20
Date: 12/13/2009
Time: 8:01:42 PM
User: N/A
Computer: INTCN60110002
Description:
Archive process error: ORACLE Instance tang - Archival Error.
-------------------------------------
Event Type: Error
Event Source: Oracle.tang
Event Category: None
Event ID: 20
Date: 12/13/2009
Time: 8:01:42 PM
User: N/A
Computer: INTCN60110002
Description:
Archive process error: ORA-16014: log 2 sequence# 14627 not archived, no available destinations
ORA-00312: online log 2 thread 1: 'H:\ALODB\REDOLOG\REDO2.LOG'
ORA-00312: online log 2 thread 1: 'F:\ALODB\REDOLOG\REDO2.LOG'
--------------------------------------------------------
Event Type: Error
Event Source: Oracle.tang
Event Category: None
Event ID: 20
Date: 12/14/2009
Time: 10:03:03 AM
User: N/A
Computer: INTCN60110002
Description:
Archive process error: ORACLE Instance tang - Can not allocate log, archival required