ALLSTARS_ORACLE 发表于 2017-4-17 12:13:15

非归档模式,磁盘损坏,恢复后启动oracle 报01092错误,帮...


linux下,oracle9i的库,用的RAID5,非归档模式,磁盘损坏,恢复磁盘后启动oracle 报01092错误。
下面是我,startup mount;
alter database open;
后的日志文件,麻烦看下,我该怎么解决把库启起来,谢谢!
Thu Sep  7 16:03:17 2006
Starting ORACLE instance (normal)
Thu Sep  7 16:03:17 2006
WARNING: EINVAL creating segment of size 0x0000000044400000
fix shm parameters in /etc/system or equivalent
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  shared_pool_size         = 520093696
  large_pool_size          = 67108864
  java_pool_size           = 50331648
  control_files            = /oracle/oradata/game/control01.ctl, /oracle/oradata/game/control02.ctl, /oracle/oradata/game/control03.ctl
  db_block_size            = 8192
  db_cache_size            = 469762048
  compatible               = 9.2.0.0.0
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  instance_name            = game
  dispatchers              = (PROTOCOL=TCP) (SERVICE=gameXDB)
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = /oracle/admin/game/bdump
  user_dump_dest           = /oracle/admin/game/udump
  core_dump_dest           = /oracle/admin/game/cdump
  sort_area_size           = 2524288
  db_name                  = game
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 96000000
  aq_tm_processes          = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Thu Sep  7 16:03:18 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Sep  7 16:03:18 2006
ALTER DATABASE   MOUNT
Thu Sep  7 16:03:22 2006
Successful mount of redo thread 1, with mount id 4218342150.
Thu Sep  7 16:03:22 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Thu Sep  7 16:03:37 2006
alter database open
Thu Sep  7 16:03:37 2006
Beginning crash recovery of 1 threads
Thu Sep  7 16:03:37 2006
Started first pass scan
Thu Sep  7 16:03:37 2006
Completed first pass scan
1 redo blocks read, 0 data blocks need recovery
Thu Sep  7 16:03:37 2006
Started recovery at
Thread 1: logseq 27, block 2, scn 0.23773488
Recovery of Online Redo Log: Thread 1 Group 2 Seq 27 Reading mem 0
  Mem# 0 errs 0: /oracle/oradata/game/redo02.log
Thu Sep  7 16:03:37 2006
Completed redo application
Thu Sep  7 16:03:37 2006
Ended recovery at
Thread 1: logseq 27, block 3, scn 0.23793489
0 data blocks read, 0 data blocks written, 1 redo blocks read
Crash recovery completed successfully
Thu Sep  7 16:03:37 2006
Thread 1 advanced to log sequence 28
Thread 1 opened at log sequence 28
  Current log# 3 seq# 28 mem# 0: /oracle/oradata/game/redo03.log
Successful open of redo thread 1.
Thu Sep  7 16:03:37 2006
SMON: enabling cache recovery
Thu Sep  7 16:03:37 2006
Errors in file /oracle/admin/game/udump/game_ora_2135.trc:
ORA-01578: ORACLE data block corrupted (file # 2, block # 9)
ORA-01110: data file 2: '/oracle/oradata/game/undotbs01.dbf'
Thu Sep  7 16:03:37 2006
Error 1578 happened during db open, shutting down database
USER: terminating instance due to error 1578
Instance terminated by USER, pid = 2135
ORA-1092 signalled during: alter database open...


谢谢回复,库是正常shutdown的,是在启动startup的时候(还没有启动完毕),一块硬盘出问题,IBM的工程师也在,当时还有一块硬盘在做raid5的同步恢复,这个时候启动就报I/O的错误。等raid5的硬盘同步恢复好了,再启动就报01092的错误了,所以只要能启动,估计不会有数据丢失!



应该是undo 的block损坏了,不知道怎么忽略它,启动数据库
页: [1]
查看完整版本: 非归档模式,磁盘损坏,恢复后启动oracle 报01092错误,帮...