各位大大:
一个10.2.0.1的生产数据库,非归档,无备份,昨天上午在双机切换了两次后报错system02.dbf出错,数据库就无法open了,只能在mount方式下。
后来按网上的方法将system02.dbf cp 到新的目录下rename,然后recover database,又开始报system01.dbf的错.经过几次recover后目前启动时报错如下:
SQL> startup
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 1220460 bytes
Variable Size 486539412 bytes
Database Buffers 1644167168 bytes
Redo Buffers 15556608 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
查看alter日志如下:
Fri Jul 29 14:25:02 2011
Starting ORACLE instance (normal)
Cannot determine all dependent dynamic libraries for /proc/self/exe
Unable to find dynamic library libocr10.so in search paths
RPATH = /ade/aime1_build2101/oracle/has/lib/:/ade/aime1_build2101/oracle/lib/:/ade/aime1_build2101/oracle/has/lib/:
LD_LIBRARY_PATH is not set!
The default library directories are /lib and /usr/lib
Unable to find dynamic library libocrb10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
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 = 2147483648
__shared_pool_size = 452984832
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 0
sga_target = 2147483648
control_files = /oradata/plxxxydb/control01.ctl, /oradata/plxxxydb/control02.ctl, /oradata/plxxxydb/control03.ctl
db_block_size = 8192
__db_cache_size = 1644167168
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /oracle/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=plxxxydbXDB)
job_queue_processes = 10
parallel_max_servers = 8
background_dump_dest = /oracle/admin/plxxxydb/bdump
user_dump_dest = /oracle/admin/plxxxydb/udump
core_dump_dest = /oracle/admin/plxxxydb/cdump
audit_file_dest = /oracle/admin/plxxxydb/adump
db_name = plxxxydb
open_cursors = 300
pga_aggregate_target = 838860800
PMON started with pid=2, OS id=24069
PSP0 started with pid=3, OS id=24071
MMAN started with pid=4, OS id=24073
DBW0 started with pid=5, OS id=24075
LGWR started with pid=6, OS id=24077
CKPT started with pid=7, OS id=24079
SMON started with pid=8, OS id=24081
RECO started with pid=9, OS id=24083
CJQ0 started with pid=10, OS id=24085
MMON started with pid=11, OS id=24087
Fri Jul 29 14:25:02 2011
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=24089
Fri Jul 29 14:25:02 2011
starting up 1 shared server(s) ...
Fri Jul 29 14:25:02 2011
ALTER DATABASE MOUNT
Fri Jul 29 14:25:06 2011
Setting recovery target incarnation to 4
Fri Jul 29 14:25:06 2011
Successful mount of redo thread 1, with mount id 3412198462
Fri Jul 29 14:25:06 2011
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Jul 29 14:25:06 2011
ALTER DATABASE OPEN
Fri Jul 29 14:25:06 2011
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Fri Jul 29 14:25:06 2011
Started redo scan
Fri Jul 29 14:25:06 2011
Completed redo scan
2 redo blocks read, 0 data blocks need recovery
Fri Jul 29 14:25:06 2011
Started redo application at
Thread 1: logseq 4, block 3
Fri Jul 29 14:25:06 2011
Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0
Mem# 0 errs 0: /oradata/plxxxydb/redo03.log
Fri Jul 29 14:25:06 2011
Completed redo application
Fri Jul 29 14:25:06 2011
Completed crash recovery at
Thread 1: logseq 4, block 5, scn 21643418
0 data blocks read, 0 data blocks written, 2 redo blocks read
Fri Jul 29 14:25:07 2011
Thread 1 advanced to log sequence 5
Thread 1 opened at log sequence 5
Current log# 1 seq# 5 mem# 0: /oradata/plxxxydb/redo01.log
Successful open of redo thread 1
Fri Jul 29 14:25:07 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jul 29 14:25:07 2011
SMON: enabling cache recovery
Fri Jul 29 14:25:07 2011
Errors in file /oracle/admin/plxxxydb/udump/plxxxydb_ora_24115.trc:
ORA-00600: internal error code, arguments: [4194], [31], [9], [], [], [], [], []
Fri Jul 29 14:25:07 2011
Doing block recovery for file 1 block 394
Block recovery from logseq 5, block 3 to scn 21643426
Fri Jul 29 14:25:07 2011
Recovery of Online Redo Log: Thread 1 Group 1 Seq 5 Reading mem 0
Mem# 0 errs 0: /oradata/plxxxydb/redo01.log
Block recovery stopped at EOT rba 5.5.16
Block recovery completed at rba 5.5.16, scn 0.21643424
Doing block recovery for file 1 block 9
Block recovery from logseq 5, block 3 to scn 21643423
Fri Jul 29 14:25:07 2011
Recovery of Online Redo Log: Thread 1 Group 1 Seq 5 Reading mem 0
Mem# 0 errs 0: /oradata/plxxxydb/redo01.log
Block recovery completed at rba 5.5.16, scn 0.21643424
Fri Jul 29 14:25:07 2011
Errors in file /oracle/admin/plxxxydb/udump/plxxxydb_ora_24115.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [31], [9], [], [], [], [], []
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 24115
ORA-1092 signalled during: ALTER DATABASE OPEN...
请问我接下来该怎么处理啊?谢谢了!