# 44390
无车无墅
|
|
To: eygle
请问,如果删除一个数据文件,什么情况下是在mount状态下将错误信息写入alter.log,根据我的理解以及测试,是在open的时候,但您的深入解析oracle一书第20页说是mount下
From: 无车无墅 2009.05.28 05:45
|
|
|
|
|
|
|
|
|
|
To: 无车无墅
这个mount状态下的检验是非严格性的,当主动查询触发时,进程会去检查,如:
SQL> select name from v$datafile;
NAME
------------------------------------------------------------------------------------------------------------------------
/opt/oracle/oradata/eygle/system01.dbf
/opt/oracle/oradata/eygle/undotbs01.dbf
/opt/oracle/eygle01.dbf
/opt/oracle/oradata/eygle/astmp.dbf
/opt/oracle/oradata/eygle/gjrdata.dbf
SQL> select * from v$recover_file;
FILE# ONLINEONLINE_ ERRORCHANGE# TIME
---------- ------- ------- ----------------------------------------------------------------- ---------- ---------
3 ONLINEONLINEFILE NOT FOUND 0
SQL> !
[oracle@jumper bdump]$ tail -20 alert_eygle.log
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Jun5 17:22:07 2009
ARC1: Archival started
ARC1: Thread not mounted
Fri Jun5 17:22:07 2009
ARC0: Thread not mounted
Fri Jun5 17:22:07 2009
ALTER DATABASE MOUNT
Fri Jun5 17:22:11 2009
Successful mount of redo thread 1, with mount id 1507818879.
Fri Jun5 17:22:11 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Jun5 17:22:36 2009
Errors in file /opt/oracle/admin/eygle/bdump/eygle_dbw0_2182.trc:
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '/opt/oracle/eygle01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
From: eygle 2009.06.05 02:22
|
|
|
|
|
|
|