- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-16 09:54:24
|
查看: 1924 |
回复: 1
Windows 10G
数据库怎么无法启动,偶尔启动起来还无法正常关闭!兄弟们帮忙看看
是不是数据文件7有坏块? 数据文件7是Undo表空间文件
附操作及alertlog:
SQL> connect / as sysdba;
已连接到空闲例程。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 536870912 bytes
Fixed Size 789756 bytes
Variable Size 510391044 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
数据库装载完毕。
ORA-00607: 当更改数据块时出现内部错误
ORA-00600: 内部错误代码, 参数: [4193], [28532], [28536], [], [], [], [], []
SQL> recover database until cancel;
ORA-00283: 恢复会话因错误而取消
ORA-01124: 无法恢复数据文件 1 - 文件在使用中或在恢复中
ORA-01110: 数据文件 1: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSTEM01.DBF'
Thu May 27 13:45:15 2010
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
sga_max_size = 536870912
__shared_pool_size = 83886080
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_files = D:\DISK3\CONTROL01.CTL, D:\DISK6\CONTROL02.CTL, D:\DISK9\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
db_cache_advice = ON
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = d:\oracle\product\10.1.0\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = JERRY_UNDO
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=myoracleXDB)
shared_servers = 3
job_queue_processes = 10
background_dump_dest = D:\ORACLE\PRODUCT\10.1.0\ADMIN\MYORACLE\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.1.0\ADMIN\MYORACLE\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.1.0\ADMIN\MYORACLE\CDUMP
sort_area_size = 65536
db_name = myoracle
open_cursors = 300
pga_aggregate_target = 25165824
PMON started with pid=2, OS id=21628
MMAN started with pid=3, OS id=21776
DBW0 started with pid=4, OS id=1068
LGWR started with pid=5, OS id=20540
CKPT started with pid=6, OS id=17812
SMON started with pid=7, OS id=19680
RECO started with pid=8, OS id=20792
CJQ0 started with pid=9, OS id=20616
Thu May 27 13:45:15 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 3 shared server(s) ...
Thu May 27 13:45:15 2010
ALTER DATABASE MOUNT
Thu May 27 13:45:15 2010
Controlfile identified with block size 16384
Thu May 27 13:45:20 2010
Setting recovery target incarnation to 6
Thu May 27 13:45:20 2010
Successful mount of redo thread 1, with mount id 1818734891
Thu May 27 13:45:20 2010
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu May 27 13:45:20 2010
ALTER DATABASE OPEN
Thu May 27 13:45:20 2010
Beginning crash recovery of 1 threads
attempting to start a parallel recovery with 2 processes
parallel recovery started with 2 processes
Thu May 27 13:45:21 2010
Started first pass scan
Thu May 27 13:45:21 2010
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Thu May 27 13:45:21 2010
Started redo application at
Thread 1: logseq 16, block 844, scn 0.53332424
Recovery of Online Redo Log: Thread 1 Group 5 Seq 16 Reading mem 0
Mem# 0 errs 0: D:\DISK3\REDO05A.LOG
Mem# 1 errs 0: D:\DISK6\REDO05B.LOG
Mem# 2 errs 0: D:\DISK9\REDO05C.LOG
Thu May 27 13:45:22 2010
Completed redo application
Thu May 27 13:45:22 2010
Completed crash recovery at
Thread 1: logseq 16, block 844, scn 0.53352425
0 data blocks read, 0 data blocks written, 0 redo blocks read
Thu May 27 13:45:22 2010
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=17, OS id=22184
ARC0: Archival started
ARC1 started with pid=18, OS id=21336
Thu May 27 13:45:22 2010
ARC1: Archival started
Thu May 27 13:45:22 2010
LGWR: STARTING ARCH PROCESSES COMPLETE
Thu May 27 13:45:22 2010
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thu May 27 13:45:22 2010
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Thu May 27 13:45:22 2010
ARC1: Becoming the heartbeat ARCH
Thu May 27 13:45:24 2010
Thread 1 advanced to log sequence 17
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 17
Current log# 2 seq# 17 mem# 0: D:\DISK3\REDO02A.LOG
Current log# 2 seq# 17 mem# 1: D:\DISK6\REDO02B.LOG
Thu May 27 13:45:24 2010
Current log# 2 seq# 17 mem# 2: D:\DISK9\REDO02C.LOG
Successful open of redo thread 1
Thu May 27 13:45:24 2010
ARC0: Evaluating archive log 5 thread 1 sequence 16
Thu May 27 13:45:24 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu May 27 13:45:24 2010
ARC1: Evaluating archive log 5 thread 1 sequence 16
Thu May 27 13:45:24 2010
SMON: enabling cache recovery
Thu May 27 13:45:24 2010
ARC1: Unable to archive log 5 thread 1 sequence 16
Log actively being archived by another process
Thu May 27 13:45:24 2010
db_recovery_file_dest_size of 10240 MB is 69.39% used. This is a
user-specified limit on the amount of space that will be used by this
Thu May 27 13:45:24 2010
ARC1: Evaluating archive log 5 thread 1 sequence 16
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Thu May 27 13:45:25 2010
Committing creation of archivelog 'D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2010_05_27\O1_MF_1_16_5ZW1QNYH_.ARC'
Thu May 27 13:45:25 2010
ARC1: Unable to archive log 5 thread 1 sequence 16
Log actively being archived by another process
Thu May 27 13:45:25 2010
Created Oracle managed file D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2010_05_27\O1_MF_1_16_5ZW1QNYH_.ARC
Thu May 27 13:45:26 2010
Successfully onlined Undo Tablespace 8.
Thu May 27 13:45:26 2010
SMON: enabling tx recovery
Thu May 27 13:45:26 2010
Database Characterset is ZHS16GBK
Thu May 27 13:45:26 2010
Published database character set on system events channel
Thu May 27 13:45:26 2010
All processes have switched to database character set
Thu May 27 13:45:28 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_18472.trc:
ORA-00600: 内部错误代码, 参数: [4193], [28532], [28536], [], [], [], [], [] |
|