oracle 10g数据库服务器断电以后,再启动就启动不起来了.
使用ALTER DATABASE OPEN命令后,报错:
ORA-01092: ORACLE instance terminated. Disconnection forced以下是alert_oradsc.log,希望高手看看,谢谢:
Sat Apr 25 18:53:36 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 2 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_files = E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = e:\oracle\product\10.1.0\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=oradscXDB)
job_queue_processes = 10
background_dump_dest = E:\ORACLE\PRODUCT\10.1.0\ADMIN\ORADSC\BDUMP
user_dump_dest = E:\ORACLE\PRODUCT\10.1.0\ADMIN\ORADSC\UDUMP
core_dump_dest = E:\ORACLE\PRODUCT\10.1.0\ADMIN\ORADSC\CDUMP
sort_area_size = 65536
db_name = oradsc
open_cursors = 300
pga_aggregate_target = 25165824
PMON started with pid=2, OS id=2468
MMAN started with pid=3, OS id=3812
DBW0 started with pid=4, OS id=920
LGWR started with pid=5, OS id=2140
CKPT started with pid=6, OS id=2724
SMON started with pid=7, OS id=2816
RECO started with pid=8, OS id=3752
CJQ0 started with pid=9, OS id=2904
Sat Apr 25 18:53:37 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sat Apr 25 18:53:37 2009
ALTER DATABASE MOUNT
Sat Apr 25 18:53:37 2009
Controlfile identified with block size 16384
Sat Apr 25 18:53:41 2009
Setting recovery target incarnation to 2
Sat Apr 25 18:53:41 2009
Successful mount of redo thread 1, with mount id 1183741937
Sat Apr 25 18:53:41 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sat Apr 25 18:53:46 2009
ALTER DATABASE RECOVER database
Sat Apr 25 18:53:46 2009
Media Recovery Start
attempting to start a parallel recovery with 2 processes
parallel recovery started with 2 processes
Starting datafile 1 with incarnation depth 0 in thread 1 sequence 4
Datafile 1: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\SYSTEM01.DBF'
Starting datafile 2 with incarnation depth 0 in thread 1 sequence 4
Datafile 2: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\UNDOTBS01.DBF'
Starting datafile 3 with incarnation depth 0 in thread 1 sequence 4
Datafile 3: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\SYSAUX01.DBF'
Starting datafile 4 with incarnation depth 0 in thread 1 sequence 4
Datafile 4: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\USERS01.DBF'
Starting datafile 5 with incarnation depth 0 in thread 1 sequence 4
Datafile 5: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\EXAMPLE01.DBF'
Media Recovery Log
Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\REDO03.LOG
Completed: ALTER DATABASE RECOVER database
Sat Apr 25 18:54:11 2009
ALTER DATABASE OPEN
Sat Apr 25 18:54:11 2009
Beginning crash recovery of 1 threads
attempting to start a parallel recovery with 2 processes
parallel recovery started with 2 processes
Sat Apr 25 18:54:12 2009
Started first pass scan
Sat Apr 25 18:54:12 2009
Completed first pass scan
1 redo blocks read, 0 data blocks need recovery
Sat Apr 25 18:54:12 2009
Started redo application at
Thread 1: logseq 4, block 2, scn 0.71206087
Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\REDO03.LOG
Sat Apr 25 18:54:12 2009
Completed redo application
Sat Apr 25 18:54:12 2009
Completed crash recovery at
Thread 1: logseq 4, block 3, scn 0.71226089
0 data blocks read, 0 data blocks written, 1 redo blocks read
Sat Apr 25 18:54:13 2009
Thread 1 advanced to log sequence 5
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 7 at log switch
Thread 1 opened at log sequence 5
Current log# 1 seq# 5 mem# 0: E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\REDO01.LOG
Successful open of redo thread 1
Sat Apr 25 18:54:13 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Apr 25 18:54:13 2009
SMON: enabling cache recovery
Sat Apr 25 18:54:14 2009
Hex dump of (file 2, block 9) in trace file e:\oracle\product\10.1.0\admin\oradsc\udump\oradsc_ora_3688.trc
Corrupt block relative dba: 0x00800009 (file 2, block 9)
Bad header found during buffer read
Data in bad block:
type: 255 format: 7 rdba: 0xffffffff
last change scn: 0xffff.ffffffff seq: 0xff flg: 0xff
spare1: 0xff spare2: 0xff spare3: 0xffff
consistency value in tail: 0xffffffff
check value in block header: 0xffff
computed block checksum: 0x0
Reread of rdba: 0x00800009 (file 2, block 9) found same corrupted data
Sat Apr 25 18:54:14 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\udump\oradsc_ora_3688.trc:
ORA-01578: ORACLE data block corrupted (file # 2, block # 9)
ORA-01110: data file 2: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\UNDOTBS01.DBF'
ORA-26040: Data block was loaded using the NOLOGGING optionError 1578 happened during db open, shutting down database
USER: terminating instance due to error 1578
Sat Apr 25 18:54:15 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\bdump\oradsc_reco_3752.trc:
ORA-01578: ORACLE data block corrupted (file # , block # )Sat Apr 25 18:54:15 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\bdump\oradsc_smon_2816.trc:
ORA-01578: ORACLE data block corrupted (file # , block # )Sat Apr 25 18:54:15 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\bdump\oradsc_ckpt_2724.trc:
ORA-01578: ORACLE data block corrupted (file # , block # )Sat Apr 25 18:54:15 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\bdump\oradsc_lgwr_2140.trc:
ORA-01578: ORACLE data block corrupted (file # , block # )Sat Apr 25 18:54:16 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\bdump\oradsc_dbw0_920.trc:
ORA-01578: ORACLE data block corrupted (file # , block # )Sat Apr 25 18:54:16 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\bdump\oradsc_pmon_2468.trc:
ORA-01578: ORACLE data block corrupted (file # , block # )Sat Apr 25 18:54:16 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\bdump\oradsc_mman_3812.trc:
ORA-01578: ORACLE data block corrupted (file # , block # )Instance terminated by USER, pid = 3688
ORA-1092 signalled during: ALTER DATABASE OPEN...
使用ALTER DATABASE OPEN命令后,报错:
ORA-01092: ORACLE instance terminated. Disconnection forced以下是alert_oradsc.log,希望高手看看,谢谢:
Sat Apr 25 18:53:36 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 2 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_files = E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = e:\oracle\product\10.1.0\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=oradscXDB)
job_queue_processes = 10
background_dump_dest = E:\ORACLE\PRODUCT\10.1.0\ADMIN\ORADSC\BDUMP
user_dump_dest = E:\ORACLE\PRODUCT\10.1.0\ADMIN\ORADSC\UDUMP
core_dump_dest = E:\ORACLE\PRODUCT\10.1.0\ADMIN\ORADSC\CDUMP
sort_area_size = 65536
db_name = oradsc
open_cursors = 300
pga_aggregate_target = 25165824
PMON started with pid=2, OS id=2468
MMAN started with pid=3, OS id=3812
DBW0 started with pid=4, OS id=920
LGWR started with pid=5, OS id=2140
CKPT started with pid=6, OS id=2724
SMON started with pid=7, OS id=2816
RECO started with pid=8, OS id=3752
CJQ0 started with pid=9, OS id=2904
Sat Apr 25 18:53:37 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sat Apr 25 18:53:37 2009
ALTER DATABASE MOUNT
Sat Apr 25 18:53:37 2009
Controlfile identified with block size 16384
Sat Apr 25 18:53:41 2009
Setting recovery target incarnation to 2
Sat Apr 25 18:53:41 2009
Successful mount of redo thread 1, with mount id 1183741937
Sat Apr 25 18:53:41 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sat Apr 25 18:53:46 2009
ALTER DATABASE RECOVER database
Sat Apr 25 18:53:46 2009
Media Recovery Start
attempting to start a parallel recovery with 2 processes
parallel recovery started with 2 processes
Starting datafile 1 with incarnation depth 0 in thread 1 sequence 4
Datafile 1: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\SYSTEM01.DBF'
Starting datafile 2 with incarnation depth 0 in thread 1 sequence 4
Datafile 2: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\UNDOTBS01.DBF'
Starting datafile 3 with incarnation depth 0 in thread 1 sequence 4
Datafile 3: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\SYSAUX01.DBF'
Starting datafile 4 with incarnation depth 0 in thread 1 sequence 4
Datafile 4: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\USERS01.DBF'
Starting datafile 5 with incarnation depth 0 in thread 1 sequence 4
Datafile 5: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\EXAMPLE01.DBF'
Media Recovery Log
Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\REDO03.LOG
Completed: ALTER DATABASE RECOVER database
Sat Apr 25 18:54:11 2009
ALTER DATABASE OPEN
Sat Apr 25 18:54:11 2009
Beginning crash recovery of 1 threads
attempting to start a parallel recovery with 2 processes
parallel recovery started with 2 processes
Sat Apr 25 18:54:12 2009
Started first pass scan
Sat Apr 25 18:54:12 2009
Completed first pass scan
1 redo blocks read, 0 data blocks need recovery
Sat Apr 25 18:54:12 2009
Started redo application at
Thread 1: logseq 4, block 2, scn 0.71206087
Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\REDO03.LOG
Sat Apr 25 18:54:12 2009
Completed redo application
Sat Apr 25 18:54:12 2009
Completed crash recovery at
Thread 1: logseq 4, block 3, scn 0.71226089
0 data blocks read, 0 data blocks written, 1 redo blocks read
Sat Apr 25 18:54:13 2009
Thread 1 advanced to log sequence 5
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 7 at log switch
Thread 1 opened at log sequence 5
Current log# 1 seq# 5 mem# 0: E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\REDO01.LOG
Successful open of redo thread 1
Sat Apr 25 18:54:13 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Apr 25 18:54:13 2009
SMON: enabling cache recovery
Sat Apr 25 18:54:14 2009
Hex dump of (file 2, block 9) in trace file e:\oracle\product\10.1.0\admin\oradsc\udump\oradsc_ora_3688.trc
Corrupt block relative dba: 0x00800009 (file 2, block 9)
Bad header found during buffer read
Data in bad block:
type: 255 format: 7 rdba: 0xffffffff
last change scn: 0xffff.ffffffff seq: 0xff flg: 0xff
spare1: 0xff spare2: 0xff spare3: 0xffff
consistency value in tail: 0xffffffff
check value in block header: 0xffff
computed block checksum: 0x0
Reread of rdba: 0x00800009 (file 2, block 9) found same corrupted data
Sat Apr 25 18:54:14 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\udump\oradsc_ora_3688.trc:
ORA-01578: ORACLE data block corrupted (file # 2, block # 9)
ORA-01110: data file 2: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADSC\UNDOTBS01.DBF'
ORA-26040: Data block was loaded using the NOLOGGING optionError 1578 happened during db open, shutting down database
USER: terminating instance due to error 1578
Sat Apr 25 18:54:15 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\bdump\oradsc_reco_3752.trc:
ORA-01578: ORACLE data block corrupted (file # , block # )Sat Apr 25 18:54:15 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\bdump\oradsc_smon_2816.trc:
ORA-01578: ORACLE data block corrupted (file # , block # )Sat Apr 25 18:54:15 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\bdump\oradsc_ckpt_2724.trc:
ORA-01578: ORACLE data block corrupted (file # , block # )Sat Apr 25 18:54:15 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\bdump\oradsc_lgwr_2140.trc:
ORA-01578: ORACLE data block corrupted (file # , block # )Sat Apr 25 18:54:16 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\bdump\oradsc_dbw0_920.trc:
ORA-01578: ORACLE data block corrupted (file # , block # )Sat Apr 25 18:54:16 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\bdump\oradsc_pmon_2468.trc:
ORA-01578: ORACLE data block corrupted (file # , block # )Sat Apr 25 18:54:16 2009
Errors in file e:\oracle\product\10.1.0\admin\oradsc\bdump\oradsc_mman_3812.trc:
ORA-01578: ORACLE data block corrupted (file # , block # )Instance terminated by USER, pid = 3688
ORA-1092 signalled during: ALTER DATABASE OPEN...
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货