Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-16 09:54:24 | 查看: 1923| 回复: 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], [], [], [], [], []
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
2#
发表于 2017-4-16 09:54:53


Doing block recovery for file 7 block 1214
Block recovery range from rba 17.61.0 to scn 0.53352489
Recovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0
  Mem# 0 errs 0: D:\DISK3\REDO02A.LOG
  Mem# 1 errs 0: D:\DISK6\REDO02B.LOG
  Mem# 2 errs 0: D:\DISK9\REDO02C.LOG
Block recovery stopped at EOT rba 17.63.16
Block recovery completed at rba 17.63.16, scn 0.53352489
Doing block recovery for file 7 block 41
Block recovery range from rba 17.61.0 to scn 0.53352488
Recovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0
  Mem# 0 errs 0: D:\DISK3\REDO02A.LOG
  Mem# 1 errs 0: D:\DISK6\REDO02B.LOG
  Mem# 2 errs 0: D:\DISK9\REDO02C.LOG
Block recovery completed at rba 17.63.16, scn 0.53352489
Thu May 27 13:45:32 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_18472.trc:
ORA-00600: 内部错误代码, 参数: [4193], [28532], [28536], [], [], [], [], []

Doing block recovery for file 7 block 1214
Block recovery range from rba 17.61.0 to scn 0.53352489
Recovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0
  Mem# 0 errs 0: D:\DISK3\REDO02A.LOG
  Mem# 1 errs 0: D:\DISK6\REDO02B.LOG
  Mem# 2 errs 0: D:\DISK9\REDO02C.LOG
Block recovery completed at rba 17.63.16, scn 0.53352491
Doing block recovery for file 7 block 41
Block recovery range from rba 17.61.0 to scn 0.53352491
Recovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0
  Mem# 0 errs 0: D:\DISK3\REDO02A.LOG
  Mem# 1 errs 0: D:\DISK6\REDO02B.LOG
  Mem# 2 errs 0: D:\DISK9\REDO02C.LOG
Block recovery completed at rba 17.65.16, scn 0.53352492
Thu May 27 13:45:37 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_18472.trc:
ORA-00600: 内部错误代码, 参数: [4193], [27095], [27099], [], [], [], [], []

Doing block recovery for file 7 block 658
Block recovery range from rba 17.65.0 to scn 0.53352495
Recovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0
  Mem# 0 errs 0: D:\DISK3\REDO02A.LOG
  Mem# 1 errs 0: D:\DISK6\REDO02B.LOG
  Mem# 2 errs 0: D:\DISK9\REDO02C.LOG
Block recovery stopped at EOT rba 17.67.16
Block recovery completed at rba 17.67.16, scn 0.53352495
Doing block recovery for file 7 block 25
Block recovery range from rba 17.65.0 to scn 0.53352494
Recovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0
  Mem# 0 errs 0: D:\DISK3\REDO02A.LOG
  Mem# 1 errs 0: D:\DISK6\REDO02B.LOG
  Mem# 2 errs 0: D:\DISK9\REDO02C.LOG
Block recovery completed at rba 17.67.16, scn 0.53352495
Thu May 27 13:45:40 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_18472.trc:
ORA-00607: 当更改数据块时出现内部错误
ORA-00600: 内部错误代码, 参数: [4193], [27095], [27099], [], [], [], [], []

Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Thu May 27 13:45:40 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_ckpt_17812.trc:
ORA-00607: Internal error occurred while making a change to a data block

Thu May 27 13:45:41 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_reco_20792.trc:
ORA-00607: Internal error occurred while making a change to a data block

Thu May 27 13:45:41 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_lgwr_20540.trc:
ORA-00607: Internal error occurred while making a change to a data block

Thu May 27 13:45:42 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_dbw0_1068.trc:
ORA-00607: Internal error occurred while making a change to a data block

Thu May 27 13:45:42 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_mman_21776.trc:
ORA-00607: Internal error occurred while making a change to a data block

Instance terminated by USER, pid = 18472
ORA-1092 signalled during: ALTER DATABASE OPEN...

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-23 15:29 , Processed in 0.046931 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569