dbv查询mysql数据错误_Oracle--DBV命令行工具用法详解及坏块修复

[oracle@oracle01 ~]$ rman target /Recovery Manager: Release11.2.0.4.0 - Production on Mon May 13 16:04:06 2019Copyright (c)1982, 2011, Oracle and/or its affiliates. Allrights reserved.

connectedto target database: ORACLE01 (DBID=2594375557)

RMAN> backup check logical validate database;

Startingbackup at 13-MAY-19using targetdatabase control file instead ofrecovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=27 device type=DISKallocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=149 device type=DISKallocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=18 device type=DISKallocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=153 device type=DISKallocated channel: ORA_DISK_5

channel ORA_DISK_5: SID=30 device type=DISKallocated channel: ORA_DISK_6

channel ORA_DISK_6: SID=152 device type=DISKallocated channel: ORA_DISK_7

channel ORA_DISK_7: SID=20 device type=DISKallocated channel: ORA_DISK_8

channel ORA_DISK_8: SID=125 device type=DISKallocated channel: ORA_DISK_9

channel ORA_DISK_9: SID=29 device type=DISKallocated channel: ORA_DISK_10

channel ORA_DISK_10: SID=146 device type=DISKallocated channel: ORA_DISK_11

channel ORA_DISK_11: SID=26 device type=DISKallocated channel: ORA_DISK_12

channel ORA_DISK_12: SID=154 device type=DISKchannel ORA_DISK_1: starting compressedfull datafile backup setchannel ORA_DISK_1: specifying datafile(s)in backup setinput datafilefile number=00002 name=/u01/app/oracle/oradata/oracle01/sysaux01.dbf

channel ORA_DISK_2: starting compressedfull datafile backup setchannel ORA_DISK_2: specifying datafile(s)in backup setinput datafilefile number=00001 name=/u01/app/oracle/oradata/oracle01/system01.dbf

channel ORA_DISK_3: starting compressedfull datafile backup setchannel ORA_DISK_3: specifying datafile(s)in backup setinput datafilefile number=00005 name=/u01/app/oracle/oradata/oracle01/example01.dbf

channel ORA_DISK_4: starting compressedfull datafile backup setchannel ORA_DISK_4: specifying datafile(s)in backup setinput datafilefile number=00003 name=/u01/app/oracle/oradata/oracle01/undotbs01.dbf

channel ORA_DISK_5: starting compressedfull datafile backup setchannel ORA_DISK_5: specifying datafile(s)in backup setincludingcurrent control file in backup setchannel ORA_DISK_6: starting compressedfull datafile backup setchannel ORA_DISK_6: specifying datafile(s)in backup setinput datafilefile number=00006 name=/u01/app/oracle/oradata/oracle01/test01.dbf

channel ORA_DISK_7: starting compressedfull datafile backup setchannel ORA_DISK_7: specifying datafile(s)in backup setinput datafilefile number=00007 name=/u01/app/oracle/oradata/oracle01/test101.dbf

channel ORA_DISK_8: starting compressedfull datafile backup setchannel ORA_DISK_8: specifying datafile(s)in backup setinput datafilefile number=00004 name=/u01/app/oracle/oradata/oracle01/users01.dbf

channel ORA_DISK_9: starting compressedfull datafile backup setchannel ORA_DISK_9: specifying datafile(s)in backup setincludingcurrent SPFILE in backup setchannel ORA_DISK_9:backup set complete, elapsed time: 00:00:00Listof Control File andSPFILE===============================

FileType Status Blocks Failing Blocks Examined------------ ------ -------------- ---------------

SPFILE OK 0 2channel ORA_DISK_5:backup set complete, elapsed time: 00:00:01Listof Control File andSPFILE===============================

FileType Status Blocks Failing Blocks Examined------------ ------ -------------- ---------------

Control File OK 0 2166channel ORA_DISK_7:backup set complete, elapsed time: 00:00:03ListofDatafiles=================

FileStatus Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------

7 OK 0 1142 1280 10234981

File Name: /u01/app/oracle/oradata/oracle01/test101.dbf

Block Type Blocks Failing Blocks Processed---------- -------------- ----------------

Data 0 5

Index 0 0Other0 133channel ORA_DISK_8:backup set complete, elapsed time: 00:00:03ListofDatafiles=================

FileStatus Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------

4 OK 0 18 673 4459656

File Name: /u01/app/oracle/oradata/oracle01/users01.dbf

Block Type Blocks Failing Blocks Processed---------- -------------- ----------------

Data 0 91

Index 0 44Other0 487channel ORA_DISK_6:backup set complete, elapsed time: 00:00:07ListofDatafiles=================

FileStatus Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------

6 FAILED 0 1131 1280 11652516

File Name: /u01/app/oracle/oradata/oracle01/test01.dbf

Block Type Blocks Failing Blocks Processed---------- -------------- ----------------

Data 1 10

Index 0 0Other0 139validate found oneormore corrupt blocks

See tracefile /u01/app/oracle/diag/rdbms/oracle01_oracle01/oracle01/trace/oracle01_ora_32029.trc fordetails

channel ORA_DISK_3:backup set complete, elapsed time: 00:00:27ListofDatafiles=================

FileStatus Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------

5 OK 0 33725 44321 10634562

File Name: /u01/app/oracle/oradata/oracle01/example01.dbf

Block Type Blocks Failing Blocks Processed---------- -------------- ----------------

Data 0 6602

Index 0 1149Other0 2844channel ORA_DISK_4:backup set complete, elapsed time: 00:00:37ListofDatafiles=================

FileStatus Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------

3 OK 0 1 37120 11655690

File Name: /u01/app/oracle/oradata/oracle01/undotbs01.dbf

Block Type Blocks Failing Blocks Processed---------- -------------- ----------------

Data 0 0

Index 0 0Other0 37119channel ORA_DISK_1:backup set complete, elapsed time: 00:00:57ListofDatafiles=================

FileStatus Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------

2 OK 0 23694 144688 11655688

File Name: /u01/app/oracle/oradata/oracle01/sysaux01.dbf

Block Type Blocks Failing Blocks Processed---------- -------------- ----------------

Data 0 49306

Index 0 41475Other0 30165channel ORA_DISK_2:backup set complete, elapsed time: 00:00:57ListofDatafiles=================

FileStatus Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------

1 OK 0 15655 103751 11655690

File Name: /u01/app/oracle/oradata/oracle01/system01.dbf

Block Type Blocks Failing Blocks Processed---------- -------------- ----------------

Data 0 65027

Index 0 13867Other0 9131Finishedbackup at 13-MAY-19RMAN> backup check logical validate datafile 6;

Startingbackup at 13-MAY-19using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

using channel ORA_DISK_5

using channel ORA_DISK_6

using channel ORA_DISK_7

using channel ORA_DISK_8

using channel ORA_DISK_9

using channel ORA_DISK_10

using channel ORA_DISK_11

using channel ORA_DISK_12

channel ORA_DISK_1: starting compressedfull datafile backup setchannel ORA_DISK_1: specifying datafile(s)in backup setinput datafilefile number=00006 name=/u01/app/oracle/oradata/oracle01/test01.dbf

channel ORA_DISK_1:backup set complete, elapsed time: 00:00:01ListofDatafiles=================

FileStatus Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------

6 FAILED 0 1131 1280 11652516

File Name: /u01/app/oracle/oradata/oracle01/test01.dbf

Block Type Blocks Failing Blocks Processed---------- -------------- ----------------

Data 1 10

Index 0 0Other0 139validate found oneormore corrupt blocks

See tracefile /u01/app/oracle/diag/rdbms/oracle01_oracle01/oracle01/trace/oracle01_ora_32010.trc fordetails

Finishedbackup at 13-MAY-19RMAN>

------RMAN的检查结果放在v$database_block_corruption

SQL> select file#,block#,blocks fromv$database_block_corruption;6 157 1