Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › windows 下 Oracle 10.2重启后控制文件丢失，重建控制问 ...
发新帖
ALLSTARS_ORACLE

999

积分

1

好友

942

主题

[物理/逻辑坏块] windows 下 Oracle 10.2重启后控制文件丢失，重建控制问题ORA-60...

1#
发表于 2017-4-15 22:21:07 | 查看: 2532| 回复: 2
window下oracle10.2丢失控制文件，启动后重建控制文件报错：
SQL> startup nomount;
ORACLE 例程已经启动。
Total System Global Area 1073741824 bytes
Fixed Size                  1253072 bytes
Variable Size             524288304 bytes
Database Buffers          541065216 bytes
Redo Buffers                7135232 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "ORA10G" NORESETLOGS  NOARCHIVELOG
  2      MAXLOGFILES 16
  3      MAXLOGMEMBERS 3
  4      MAXDATAFILES 100
  5      MAXINSTANCES 8
  6      MAXLOGHISTORY 292
  7  LOGFILE
  8    GROUP 1 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\REDO01.LOG'  SIZE 50M,
  9    GROUP 2 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\REDO02.LOG'  SIZE 50M,
10    GROUP 3 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\REDO03.LOG'  SIZE 50M
11  -- STANDBY LOGFILE
12  DATAFILE
13    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\SYSTEM01.DBF',
14    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\UNDOTBS01.DBF',
15    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\SYSAUX01.DBF',
16    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\USERS01.DBF',
17    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\EXAMPLE01.DBF',
18    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\ORA10G\DATAFILE\O1_MF_WAP_USER_7
Q7Z4842_.DBF',
19    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_00.DBF',
20    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\ORA10G\DATAFILE\O1_MF_TS_DB_DA_7
Q7P8407_.DBF',
21    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_01.DBF',
22    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_02.DBF',
23    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_03.DBF',
24    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_04.DBF',
25    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_05.DBF',
26    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_06.DBF',
27    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_07.DBF',
28    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_08.DBF',
29    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_09.DBF',
30    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_10.DBF',
31    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_11.DBF',
32    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_12.DBF',
33    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_13.DBF',
34    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_14.DBF',
35    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_15.DBF',
36    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_16.DBF',
37    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_17.DBF',
38    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_18.DBF',
39    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_19.DBF',
40    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_20.DBF',
41    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_21.DBF',
42    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_22.DBF',
43    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_23.DBF',
44    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\UNDOTBS02.DBF',
45    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TEST01.DBF',
46    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TEST02.DBF'
47  CHARACTER SET ZHS16GBK
48  ;
CREATE CONTROLFILE REUSE DATABASE "ORA10G" NORESETLOGS  NOARCHIVELOG
*
第 1 行出现错误:
ORA-01503: CREATE CONTROLFILE ??
ORA-00600: ??????, ??: [3753], [3], [2], [], [], [], [], []



alert日志信息如下：
Starting ORACLE instance (normal)
Wed Aug 01 11:01:23 2012
Specified value of sga_max_size is too small, bumping to 1073741824
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
  sga_max_size             = 1073741824
  __shared_pool_size       = 507510784
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 8388608
  spfile                   = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORA10G.ORA
  sga_target               = 1073741824
  control_files            = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 541065216
  compatible               = 10.2.0.1.0
  standby_archive_dest     = D:\oracle\product\10.2.0\oradata
  db_file_multiblock_read_count= 16
  db_create_file_dest      = D:\oracle\product\10.2.0\oradata\ora10g
  db_recovery_file_dest    = D:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  fast_start_mttr_target   = 30
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  service_names            = ora10g,oracle10g
  dispatchers              = (PROTOCOL=TCP) (SERVICE=ora10gXDB)
  local_listener           =
  job_queue_processes      = 10
  audit_file_dest          = D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORA10G\ADUMP
  background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORA10G\BDUMP
  user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORA10G\UDUMP
  core_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORA10G\CDUMP
  db_name                  = ora10g
  open_cursors             = 300
  pga_aggregate_target     = 524288000
PMON started with pid=2, OS id=2716
PSP0 started with pid=3, OS id=5340
MMAN started with pid=4, OS id=1456
DBW0 started with pid=5, OS id=3532
LGWR started with pid=6, OS id=4608
CKPT started with pid=7, OS id=5464
SMON started with pid=8, OS id=4328
RECO started with pid=9, OS id=2688
CJQ0 started with pid=10, OS id=5928
MMON started with pid=11, OS id=176
Wed Aug 01 11:01:23 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Aug 01 11:01:23 2012
starting up 1 shared server(s) ...
MMNL started with pid=12, OS id=736
Wed Aug 01 11:02:08 2012
CREATE CONTROLFILE REUSE DATABASE "ORA10G" NORESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\REDO01.LOG'  SIZE 50M,
  GROUP 2 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\REDO02.LOG'  SIZE 50M,
  GROUP 3 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\REDO03.LOG'  SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\SYSTEM01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\UNDOTBS01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\SYSAUX01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\USERS01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\EXAMPLE01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\ORA10G\DATAFILE\O1_MF_WAP_USER_7Q7Z4842_.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_00.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\ORA10G\DATAFILE\O1_MF_TS_DB_DA_7Q7P8407_.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_02.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_03.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_04.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_05.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_06.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_07.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_08.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_09.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_10.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_11.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_12.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_13.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_14.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_15.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_16.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_17.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_18.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_19.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_20.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_21.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_22.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_23.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\UNDOTBS02.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TEST01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TEST02.DBF'
CHARACTER SET ZHS16GBK
Wed Aug 01 11:02:08 2012
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638  QQ: 47079569     邮箱：service@parnassusdata.com
2#
发表于 2017-4-15 22:21:30

WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Wed Aug 01 11:02:09 2012
Errors in file d:\oracle\product\10.2.0\db_1\admin\ora10g\udump\ora10g_ora_4788.trc:
ORA-00600: ??????, ??: [3753], [3], [2], [], [], [], [], []
Wed Aug 01 11:02:10 2012
Errors in file d:\oracle\product\10.2.0\db_1\admin\ora10g\udump\ora10g_ora_4788.trc:
ORA-00600: ??????, ??: [3753], [3], [2], [], [], [], [], []
ORA-1503 signalled during: CREATE CONTROLFILE REUSE DATABASE "ORA10G" NORESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\REDO01.LOG'  SIZE 50M,
  GROUP 2 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\REDO02.LOG'  SIZE 50M,
  GROUP 3 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\REDO03.LOG'  SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\SYSTEM01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\UNDOTBS01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\SYSAUX01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\USERS01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\EXAMPLE01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\ORA10G\DATAFILE\O1_MF_WAP_USER_7Q7Z4842_.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_00.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\ORA10G\DATAFILE\O1_MF_TS_DB_DA_7Q7P8407_.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_02.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_03.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_04.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_05.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_06.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_07.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_08.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_09.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_10.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_11.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_12.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_13.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_14.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_15.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_16.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_17.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_18.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_19.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_20.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_21.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_22.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_23.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\UNDOTBS02.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TEST01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TEST02.DBF'
CHARACTER SET ZHS16GBK
...

trace日志如下：
Dump file d:\oracle\product\10.2.0\db_1\admin\ora10g\udump\ora10g_ora_4788.trc
Wed Aug 01 11:02:09 2012
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows NT Version V6.1 Service Pack 1
CPU                 : 2 - type 586, 2 Physical Cores
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:425M/1901M, Ph+PgF:758M/3802M, VA:836M/2047M
Instance name: ora10g
Redo thread mounted by this instance: 0 <none>
Oracle process number: 15
Windows thread id: 4788, image: ORACLE.EXE (SHAD)

*** SERVICE NAME) 2012-08-01 11:02:09.267
*** SESSION ID159.1) 2012-08-01 11:02:09.267
*** 2012-08-01 11:02:09.267
ksedmp: internal or fatal error
ORA-00600: ??????, ??: [3753], [3], [2], [], [], [], [], []
Current SQL statement for this session:
CREATE CONTROLFILE REUSE DATABASE "ORA10G" NORESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\REDO01.LOG'  SIZE 50M,
  GROUP 2 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\REDO02.LOG'  SIZE 50M,
  GROUP 3 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\REDO03.LOG'  SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\SYSTEM01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\UNDOTBS01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\SYSAUX01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\USERS01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\EXAMPLE01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\ORA10G\DATAFILE\O1_MF_WAP_USER_7Q7Z4842_.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_00.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\ORA10G\DATAFILE\O1_MF_TS_DB_DA_7Q7P8407_.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_02.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_03.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_04.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_05.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_06.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_07.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_08.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_09.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_10.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_11.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_12.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_13.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_14.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_15.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_16.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_17.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_18.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_19.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_20.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_21.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_22.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TS20120417_23.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\UNDOTBS02.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TEST01.DBF',
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\TEST02.DBF'
CHARACTER SET ZHS16GBK

回复 只看该作者 道具 举报

3#
发表于 2017-4-15 22:21:47

----- Call Stack Trace -----
calling              call     entry                argument values in hex     
location             type     point                (? means dubious value)   
-------------------- -------- -------------------- ----------------------------
_ksedst+38           CALLrel  _ksedst1+0           0 1
_ksedmp+898          CALLrel  _ksedst+0            0
_ksfdmp+14           CALLrel  _ksedmp+0            3
603A816A             CALLreg  00000000             86D04A8 3
603A83FF             CALLrel  603A80D8             86D04A8 46B1090 EA9 2 5BBC438
_ksesic2+59          CALLrel  _kgesiv+0            86D04A8 46B1090 EA9 2 5BBC438
                                                   EA9 2 5BBC438
__VInfreq__kctbce+1  CALLrel  _ksesic2+0           EA9 0 3 0 0 2 0
63                                                
_kcfccfl+356         CALLrel  _kctbce+0            469413C 812C8EC
_cdbdrv+1037         CALLrel  _kcfccfl+0           469413C 1 5BBD060 5BBD04C
                                                   19000 3
_opiexe+11999        CALLrel  _cdbdrv+0            1
_opiosq0+6088        CALLrel  _opiexe+0            4 0 5BBD894
_kpooprx+232         CALLrel  _opiosq0+0           3 E 5BBD9AC A4
_kpoal8+775          CALLrel  _kpooprx+0           5BBF6CC 46B6414 A2B 1 0 A4
_opiodr+1099         CALLreg  00000000             5E 17 5BBF6C8
60FEFF8D             CALLreg  00000000             5E 17 5BBF6C8 0
_opitsk+1017         CALL???  00000000            
_opiino+1087         CALLrel  _opitsk+0            0 0
_opiodr+1099         CALLreg  00000000             3C 4 5BBFC60
_opidrv+819          CALLrel  _opiodr+0            3C 4 5BBFC60 0
_sou2o+45            CALLrel  _opidrv+0            3C 4 5BBFC60
_opimai_real+112     CALLrel  _sou2o+0             5BBFC54 3C 4 5BBFC60
_opimai+92           CALLrel  _opimai_real+0       2 5BBFC8C
_OracleThreadStart@  CALLrel  _opimai+0           
4+708                                             
__pRawDllMain+12438  CALLptr  00000000            
6183                                             
__pRawDllMain+14033  CALLreg  00000000            
0393                                             
__pRawDllMain+14033  CALLrel  __pRawDllMain+14033
0345                          0356               

--------------------- Binary Stack Dump ---------------------

========== FRAME. [1] (_ksedst+38 -> _ksedst1+0) ==========
Dump of memory from 0x05BBC2E0 to 0x05BBC2F0
5BBC2E0 05BBC2F0 0040468B 00000000 00000001  [.....F@.........]
========== FRAME. [2] (_ksedmp+898 -> _ksedst+0) ==========
Dump of memory from 0x05BBC2F0 to 0x05BBC3B0
5BBC2F0 05BBC3B0 00403083 00000000 00000032  [.....0@.....2...]
5BBC300 00000000 00000000 00000000 00000000  [................]
5BBC310 4E9B1B00 34364925 05BB0075 00000001  [...N%I64u.......]
5BBC320 086D05AC 00000000 086D05A4 00000000  [..m.......m.....]
5BBC330 00000000 00000000 00000000 00000000  [................]
5BBC340 086D05AC 00000000 00000000 05BBC368  [..m.........h...]
5BBC350 00000001 00000004 00000000 00000000  [................]
5BBC360 00000002 05BBC438 33353733 00000001  [....8...3753....]
5BBC370 00000000 00000000 00000000 00000001  [................]
5BBC380 00000000 00000000 086D04A8 046B1090  [..........m...k.]
5BBC390 031DAC40 00000004 05BBC2FC 05BBC3D8  [@...............]
5BBC3A0 05BBCF2C 0261348C 031C1800 FFFFFFFF  [,....4a.........]
========== FRAME. [3] (_ksfdmp+14 -> _ksedmp+0) ==========
Dump of memory from 0x05BBC3B0 to 0x05BBC3BC



麻烦各位大师分析下，为何不能重建控制文件？？？

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 13:50 , Processed in 0.045558 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569