windows 下 Oracle 10.2重啟後控制檔案丟失，重建控制問題ORA-600、ORA-01503

rongshiyuan發表於2012-08-01

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
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

Oracle process number: 15

Windows thread id: 4788, image: ORACLE.EXE (SHAD)

*** SERVICE NAME:() 2012-08-01 11:02:09.267
*** SESSION ID:(159.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
----- 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

麻煩各位大師分析下，為何不能重建控制檔案？？？

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-739444/，如需轉載，請註明出處，否則將追究法律責任。

Oracle 11g重建控制檔案——控制檔案全部丟失，從零開始
2017-01-26
Oracle
控制檔案丟失恢復例項(3) - 使用重建控制檔案方式(noresetlogs)
2011-04-19
Oracle重建控制檔案
2017-10-10
Oracle
oracle 重建控制檔案
2012-03-21
Oracle
開啟控制檔案自動備份下，引數檔案、控制檔案全部丟失恢復
2017-04-24
Oracle 控制檔案的重建
2016-12-01
Oracle
控制檔案丟失恢復
2014-02-08
【控制檔案丟失恢復】
2010-07-22
ORACLE控制檔案的重建 (轉)
2008-04-27
Oracle
控制檔案丟失恢復(二)
2014-01-18
恢復丟失的控制檔案
2013-10-22
控制檔案丟失處理方法
2016-06-12
控制檔案全部丟失恢復
2013-02-03
全部控制檔案丟失後的完全恢復(轉)
2013-02-01
重建控制檔案
2015-04-14
重建控制檔案--
2012-02-28
ORA-25153: Temporary Tablespace is Empty 重建控制檔案導致丟失tempfile
2014-09-27
oracle 案例-控制檔案丟失故障處理過程
2009-06-20
Oracle
重建Oracle資料庫控制檔案
2015-09-21
Oracle資料庫
控制檔案全部丟失的恢復
2014-08-18
控制檔案部分丟失的恢復
2014-08-18
控制檔案丟失的RMAN恢復
2007-08-27
DataGuard重建控制檔案
2009-03-30
探索ORACLE之RMAN_07 控制檔案丟失恢復
2012-06-22
Oracle
控制檔案損壞重建實驗（下）
2013-02-21
控制檔案丟失恢復例項(2) - 控制檔案備份後物理結構未變化
2011-04-18
恢復之丟失全部控制檔案以及備份中的控制檔案
2009-02-11
非歸檔無備份下控制檔案丟失的恢復
2014-07-10
當前控制檔案全部丟失恢復
2015-04-28
控制檔案丟失恢復例項(1) - 控制檔案備份後物理結構發生變化
2011-04-18
oracle控制檔案及引數檔案問題
2009-07-11
Oracle
利用trace重建控制檔案
2013-02-28
重建控制檔案後某些檔案被命名為MISSINGnnnnn
2011-08-31
GNN
資料檔案丟失無備份無重啟通過控制程式碼恢復
2013-02-03
資料檔案丟失，無備份，無重啟，通過控制程式碼恢復
2013-01-24
Oracle 11g重建控制檔案——如何獲取建立控制檔案指令碼
2015-05-30
Oracle指令碼
oracle10g_備份控制檔案_得到重建控制檔案的指令碼
2009-09-15
Oracle指令碼
[20141106]建立控制檔案與丟失資料檔案問題
2014-11-06

windows 下 Oracle 10.2重啟後控制檔案丟失，重建控制問題ORA-600、ORA-01503

相關文章