日期:2014-05-17  浏览次数:21138 次

数据块在以下时间/行号处损坏: Sat Mar 17 06:57:54 2012/19245。
错误信息:~Errors in file d:\oracle\product\10.2.0\admin\jn\bdump\jn_dbw0_3236.trc:~ORA-01157: cannot identify/lock data file 5 - see DBWR trace file~ORA-01110: data file 5: 'D:\TOOLS\ORADATA\jn\bj.DBF'~ORA-27086: unable to lock file - already in use~OSD-00002: 附加错误信息~O/S-Error: (OS 32) 另一个程序正在使用此文件,进程无法访问。~~ORA-1157 signalled during: alter database open...

DBV查看的信息。但是并没有提示有坏块。



这是发生错误时间段的日志:
Dump file d:\oracle\product\10.2.0/admin/jn/bdump\alert_jn.log
Sat Mar 17 06:57:43 2012
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:3689M/4082M, Ph+PgF:5690M/5961M, VA:1938M/2047M
Sat Mar 17 06:57:43 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes = 150
  __shared_pool_size = 113246208
  __large_pool_size = 4194304
  __java_pool_size = 4194304
  __streams_pool_size = 8388608
  spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEJN.ORA
  sga_target = 612368384
  control_files = D:\TOOLS\ORADATA\JN\CONTROL01.CTL, D:\TOOLS\ORADATA\JN\CONTROL02.CTL, D:\TOOLS\ORADATA\JN\CONTROL03.CTL
  db_block_size = 8192
  __db_cache_size = 473956352
  compatible = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest = d:\oracle\product\10.2.0/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management = AUTO
  undo_tablespace = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain = 
  dispatchers = (PROTOCOL=TCP) (SERVICE=jnXDB)
  job_queue_processes = 10
  audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\JN\ADUMP
  background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\JN\BDUMP
  user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\JN\UDUMP
  core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\JN\CDUMP
  db_name = jn
  open_cursors = 300
  pga_aggregate_target = 203423744
PSP0 started with pid=4, OS id=3140
MMAN started with pid=6, OS id=3144
PMON started with pid=2, OS id=3112
DBW0 started with pid=8, OS id=3236
DBW1 started with pid=10, OS id=3280
LGWR started with pid=12, OS id=3296
CKPT started with pid=14, OS id=3320
SMON started with pid=16, OS id=3356
RECO started with pid=18, OS id=3380
CJQ0 started with pid=20, OS id=3388
MMON started with pid=22, OS id=3404
MMNL started with pid=24, OS id=3416
Sat Mar 17 06:57:45 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sat Mar 17 06:57:47 2012
alter database mount exclusive
Sat Mar 17 06:57:53 2012
Setting recovery target incarnation to 2
Sat Mar 17 06:57:53 2012
Successful mount of redo thread 1, with mount id 2869742955
Sat Mar 17 06:57:53 2012
Database mounted in