非归档数据库打不开
各位好，测试库坏了，需要请教各位：
1、Windows上安装的oracle 10.2 ，非归档模式
2、听别人说的重做过一次控制文件
3、startup；
报错ORA-01113 文件1需要介质恢复，ORA-01110 数据文件1'system01.dbf'
然后我做了RECOVER DATABASE
4、然后我alter database open
报错ORA-01092 实例终止，强制断开连接。
5、以下是警告文件内容：
Wed Jun 26 16:30:35 2013
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Wed Jun 26 16:30:35 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
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 = 268435456
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILECUSTOMER.ORA
sga_target = 5100273664
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\CUSTOMER\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\CUSTOMER\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\CUSTOMER\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 4781506560
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
_allow_resetlogs_corruption= TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS2
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=customerXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CUSTOMER\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CUSTOMER\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CUSTOMER\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CUSTOMER\CDUMP
db_name = customer
open_cursors = 300
pga_aggregate_target = 1696595968
PMON started with pid=2, OS id=4164
PSP0 started with pid=3, OS id=4108
MMAN started with pid=4, OS id=5352
DBW0 started with pid=5, OS id=5020
LGWR started with pid=6, OS id=5180
CKPT started with pid=7, OS id=4700
SMON started with pid=8, OS id=4684
RECO started with pid=9, OS id=5576
CJQ0 started with pid=10, OS id=5100
MMON started with pid=11, OS id=5588
MMNL started with pid=12, OS id=6072
Wed Jun 26 16:30:36 2013
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Jun 26 16:30:36 2013
ALTER DATABASE MOUNT
Wed Jun 26 16:30:40 2013
Setting recovery target incarnation to 11
Wed Jun 26 16:30:40 2013
Successful mount of redo thread 1, with mount id 222883372
Wed Jun 26 16:30:40 2013
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Wed Jun 26 16:30:40 2013
ALTER DATABASE OPEN
ORA-1113 signalled during: ALTER DATABASE OPEN...
Wed Jun 26 16:32:29 2013
ALTER DATABASE RECOVER database
Wed Jun 26 16:32:29 2013
Media Recovery Start
parallel recovery started with 7 processes
Wed Jun 26 16:32:30 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CUSTOMER\REDO03.LOG
Completed: ALTER DATABASE RECOVER database
Wed Jun 26 16:33:09 2013
alter database open
Wed Jun 26 16:33:09 2013
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Wed Jun 26 16:33:10 2013
Started redo scan
Wed Jun 26 16:33:10 2013
Completed redo scan
3 redo blocks read, 0 data blocks need recovery
Wed Jun 26 16:33:10 2013
Started redo application at
Thread 1: logseq 3, block 2, scn 232409476795
Wed Jun 26 16:33:10 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CUSTOMER\REDO03.LOG
Wed Jun 26 16:33:10 2013
Completed redo application
Wed Jun 26 16:33:10 2013
Completed crash recovery at
Thread 1: logseq 3, block 5, scn 232409496800
0 data blocks read, 0 data blocks written, 3 redo blocks read
Wed Jun 26 16:33:11 2013
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=23, OS id=5668
Wed Jun 26 16:33:11 2013
ARC0: Archival started
ARC1 started with pid=24, OS id=4268
Wed Jun 26 16:33:11 2013
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 advanced to log sequence 4
Thread 1 opened at log sequence 4
Wed Jun 26 16:33:11 2013
ARC0: STARTING ARCH PROCESSES
Wed Jun 26 16:33:11 2013
Current log# 2 seq# 4 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CUSTOMER\REDO02.LOG
Wed Jun 26 16:33:11 2013
ARC1: Becoming the 'no FAL' ARCH
Wed Jun 26 16:33:11 2013
Successful open of redo thread 1
Wed Jun 26 16:33:11 2013
ARC1: Becoming the 'no SRL' ARCH
Wed Jun 26 16:33:11 2013
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Jun 26 16:33:11 2013
ARC2: Archival started
ARC2 started with pid=25, OS id=5368
Wed Jun 26 16:33:11 2013
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
Wed Jun 26 16:33:11 2013
SMON: enabling cache recovery
Wed Jun 26 16:33:11 2013
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Jun 26 16:33:12 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\udump\customer_ora_4500.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08103: 对象不再存在
Wed Jun 26 16:33:12 2013
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Wed Jun 26 16:33:12 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_psp0_4108.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jun 26 16:33:12 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_lgwr_5180.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jun 26 16:33:12 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_pmon_4164.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jun 26 16:33:12 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_dbw0_5020.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jun 26 16:33:12 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_ckpt_4700.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jun 26 16:33:13 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_reco_5576.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jun 26 16:33:13 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_smon_4684.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jun 26 16:33:14 2013
Errors in file d:\oracle\product\10.2.0\admin\customer\bdump\customer_mman_5352.trc:
ORA-00604: error occurred at recursive SQL level
Instance terminated by USER, pid = 4500
ORA-1092 signalled during: alter database open...
------------------------------
有报错也不知道是什么问题，怎么解决，求各位帮助！有追问我会补充，谢谢！
贴个trc文件 d:\oracle\product\10.2.0\admin\customer\udump\customer_ora_4500.trc
Dump file d:\oracle\product\10.2.0\admin\customer\udump\customer_ora_4500.trc
Wed Jun 26 09:04:04 2013
ORACLE V10.2.0.1.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 8 - type 8664, 1 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:13714M/16280M, Ph+PgF:10525M/17725M
Instance name: customer
Redo thread mounted by this instance: 0 <none>
Oracle process number: 15
Windows thread id: 4500, image: ORACLE.EXE (SHAD)
*** SERVICE NAME) 2013-06-26 09:04:04.031
*** SESSION ID159.1) 2013-06-26 09:04:04.031
kccsga_update_ckpt: num_1 = 8, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
Dump file d:\oracle\product\10.2.0\admin\customer\udump\customer_ora_4500.trc
Wed Jun 26 16:32:29 2013
ORACLE V10.2.0.1.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 8 - type 8664, 1 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:13480M/16280M, Ph+PgF:10396M/17725M
Instance name: customer
Redo thread mounted by this instance: 1
Oracle process number: 15
Windows thread id: 4500, image: ORACLE.EXE (SHAD)
*** 2013-06-26 16:32:29.187
*** SERVICE NAME) 2013-06-26 16:32:29.187
*** SESSION ID159.3) 2013-06-26 16:32:29.187
Recovery target incarnation = 11, activation ID = 0
Influx buffer limit = 282720 (50% x 565440)
Successfully allocated 7 recovery slaves
Using 158 overflow buffers per recovery slave
Start recovery at thread 1 ckpt scn 232409476795 logseq 3 block 2
*** 2013-06-26 16:32:30.125
Media Recovery add redo thread 1
*** 2013-06-26 16:32:30.140
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 1Kb in 0.17s => 0.01 Mb/sec
Total physical reads: 4096Kb
Longest record: 0Kb, moves: 0/5 (0%)
Change moves: 1/7 (14%), moved: 0Mb
Longest LWN: 1Kb, moves: 0/2 (0%), moved: 0Mb
Last redo scn: 0x0036.1caf2ebf (232409476799)
----------------------------------------------
*** 2013-06-26 16:32:30.312
Media Recovery drop redo thread 1
File 1 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 3 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 4 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 5 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 6 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 10 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 11 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 12 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 13 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 14 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 15 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 16 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 17 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 18 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 19 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 20 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 21 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 22 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 23 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 24 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 25 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 26 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 27 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 28 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 29 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 30 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 31 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 32 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 33 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 34 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 35 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 36 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 37 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 38 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 39 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 40 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 41 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 42 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 43 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 44 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 45 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 46 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 47 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 48 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 49 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
File 50 (stop scn 232409476800) completed recovery at checkpoint scn 232409476800
*** 2013-06-26 16:33:09.796
Successfully allocated 7 recovery slaves
Using 158 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 3, block 2, scn 232409476795
start recovery at logseq 3, block 2, scn 232409476795
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 1Kb in 0.02s => 0.07 Mb/sec
Total physical reads: 4096Kb
Longest record: 0Kb, moves: 0/5 (0%)
Longest LWN: 1Kb, moves: 0/2 (0%), moved: 0Mb
Last redo scn: 0x0036.1caf2ebf (232409476799)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 65536
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
*** 2013-06-26 16:33:10.453
KCRA: start recovery claims for 0 data blocks
*** 2013-06-26 16:33:10.453
KCRA: blocks processed = 0/0, claimed = 0, eliminated = 0
*** 2013-06-26 16:33:10.468
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 65536
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08103: 对象不再存在
页:
[1]