How to check the block corruptions in database ?
RMAN Level:
RMAN> backup validate check logical datafile <<<file_number>>>;
RMAN> backup validate check logical database;
SQLPLUS Level:
sqlplus / as sysdba
select * from v$database_block_corruption;
OS Level:
The following example shows a sample use of the command-line interface to this mode of DBVERIFY.
% dbv FILE=t_db1.dbf feedback=100 >replace the file
dbv FILE=/u05/oradb/TEST/db/apps_st/data/eqddasm.dbf FEEDBACK=100
No comments:
Post a Comment