oracle 数据文件已存在,Oracle 11g 通过 RMAN 检查数据文件、控制文件、参数文件的状态和是否存在坏块...

1、验证整个数据库的数据文件和控制文件、参数文件

[oracle@DB1 bk]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Dec 10 16:53:08 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SITE (DBID=4224792395)

RMAN> validate database;

Starting validate at 10-DEC-15

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=2193 device type=DISK

channel ORA_DISK_1: starting validation of datafile

channel ORA_DISK_1: specifying datafile(s) for validation

input datafile file number=00005 name=/oradata/oradata/site/site/ts_site_data01.dbf

input datafile file number=00006 name=/oradata/oradata/site/site/ts_site_index01.dbf

input datafile file number=00003 name=/oradata/oradata/site/site/undotbs01.dbf

input datafile file number=00002 name=/oradata/oradata/site/site/sysaux01.dbf

input datafile file number=00001 name=/oradata/oradata/site/site/system01.dbf

input datafile file number=00004 name=/oradata/oradata/site/site/users01.dbf

channel ORA_DISK_1: validation complete, elapsed time: 00:01:25

List of Datafiles

=================

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

---- ------ -------------- ------------ --------------- ----------

1    OK     0              16928        101120          10310730

File Name: /oradata/oradata/site/site/system01.dbf

Block Type Blocks Failing Blocks Processed

---------- -------------- ----------------

Data       0              66094

Index      0              14016

Other      0              4082

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

---- ------ -------------- ------------ --------------- ----------

2    OK     0              29630        135680          10312535

File Name: /oradata/oradata/site/site/sysaux01.dbf

Block Type Blocks Failing Blocks Processed

---------- -------------- ----------------

Data       0              33036

Index      0              28516

Other      0              44498

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

---- ------ -------------- ------------ --------------- ----------

3    OK     0              327          168320          10316052

File Name: /oradata/oradata/site/site/undotbs01.dbf

Block Type Blocks Failing Blocks Processed

---------- -------------- ----------------

Data       0              0

Index      0              0

Other      0              167993

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

---- ------ -------------- ------------ --------------- ----------

4    OK     0              477          640             378531

File Name: /oradata/oradata/site/site/users01.dbf

Block Type Blocks Failing Blocks Processed

---------- -------------- ----------------

Data       0              15

Index      0              3

Other      0              145

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

---- ------ -------------- ------------ --------------- ----------

5    OK     0              4190015      4193280         10316052

File Name: /oradata/oradata/site/site/ts_site_data01.dbf

Block Type Blocks Failing Blocks Processed

---------- -------------- ----------------

Data       0              2149

Index      0              851

Other      0              265

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

---- ------ -------------- ------------ --------------- ----------

6    OK     0              4193153      4193280         758918

File Name: /oradata/oradata/site/site/ts_site_index01.dbf

Block Type Blocks Failing Blocks Processed

---------- -------------- ----------------

Data       0              0

Index      0              0

Other      0              127

channel ORA_DISK_1: starting validation of datafile

channel ORA_DISK_1: specifying datafile(s) for validation

including current control file for validation

including current SPFILE in backup set

channel ORA_DISK_1: validation complete, elapsed time: 00:00:01

List of Control File and SPFILE

===============================

File Type    Status Blocks Failing Blocks Examined

------------ ------ -------------- ---------------

SPFILE       OK     0              2

Control File OK     0              1106

Finished validate at 10-DEC-15

2、验证某个数据块

RMAN> VALIDATE DATAFILE 1 BLOCK 10;

Starting validate at 2015-12-10 17:19:08

using channel ORA_DISK_1

channel ORA_DISK_1: starting validation of datafile

channel ORA_DISK_1: specifying datafile(s) for validation

input datafile file number=00001 name=/ORADATA/oradata/fire/system01.dbf

channel ORA_DISK_1: validation complete, elapsed time: 00:00:01

List of Datafiles

=================

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

---- ------ -------------- ------------ --------------- ----------

1    OK     0              0            1               24

File Name: /ORADATA/oradata/fire/system01.dbf

Block Type Blocks Failing Blocks Processed

---------- -------------- ----------------

Data       0              0

Index      0              0

Other      0              1

Finished validate at 2015-12-10 17:19:09

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-1869875/，如需转载，请注明出处，否则将追究法律责任。