异常关机,RAC启不来了,提示坏块,请问ASM的数据文件怎么使...
Mon Dec 31 14:38:02 2012MTTR 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
.
页:
[1]