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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-15 16:54:36 | 查看: 1217| 回复: 0
Mon Dec 31 14:38:02 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Dec 31 14:38:02 2012
SMON: enabling cache recovery
Mon Dec 31 14:38:02 2012
Hex dump of (file 1, block 14) in trace file /opt/oracle/admin/rose/udump/orcl1_ora_11723.trc
Corrupt block relative dba: 0x0040000e (file 1, block 14)
Fractured block found during buffer read
Data in bad block:
type: 2 format: 2 rdba: 0x0040000e
last change scn: 0x0000.0000138f seq: 0x2 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x31d20201
check value in block header: 0x4ebf
computed block checksum: 0x9b96
Reread of rdba: 0x0040000e (file 1, block 14) found same corrupted data
Mon Dec 31 14:38:02 2012
Errors in file /opt/oracle/admin/rose/udump/orcl1_ora_11723.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 14)
ORA-01110: data file 1: '+DATA/rose/datafile/system.259.802032673'
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 11723
ORA-1092 signalled during: ALTER DATABASE OPEN..

----------------------------------------------
不能这样DBV啊,求解.那我怎么检测ASM下的数据文件是否坏块.
RMAN> dbv +DATA/rose/datafile/system.259.802032673
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01008: the bad identifier was: dbv
RMAN-01007: at line 1 column 1 file: standard input
.
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

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

GMT+8, 2024-6-15 13:25 , Processed in 0.046692 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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