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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26506993/viewspace-1869875/，如需轉載，請註明出處，否則將追究法律責任。