Using RMAN to Check For Logical & Physical Database Corruption

Posted: March 28, 2012 in RMAN

Running an RMAN backup or backup validate will check for logical and physical corruption on the data blocks, with 11g we get more output back from the run listing if there are any blocks marked corrupt.

Output from checking a test database for corruptions, in the test run we have no issues

RMAN> backup check logical validate database;

Starting backup at 28-03-2012 13:44:18
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/wload/test1/app/oracle/u01/oradata/testdb1/system.dbf
input datafile file number=00002 name=/wload/test1/app/oracle/u01/oradata/testdb1/sysaux.dbf
input datafile file number=00003 name=/wload/test1/app/oracle/u01/oradata/testdb1/undo01.dbf
input datafile file number=00004 name=/wload/test1/app/oracle/u01/oradata/testdb1/users.dbf
input datafile file number=00005 name=/wload/test1/app/oracle/u01/oradata/testdb1/tools.dbf
input datafile file number=00006 name=/wload/test1/app/oracle/u04/oradata/testdb1/COLLECT_DATA.dbf
input datafile file number=00007 name=/wload/test1/app/oracle/u04/oradata/testdb1/COLLECT_INDX.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:06
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
—- —— ————– ———— ————— ———-
1 OK 0 85266 131072 654296
File Name: /wload/test1/app/oracle/u01/oradata/testdb1/system.dbf
Block Type Blocks Failing Blocks Processed
———- ————– —————-
Data 0 35469
Index 0 7169
Other 0 3168

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
—- —— ————– ———— ————— ———-
2 OK 0 120677 131072 654298
File Name: /wload/test1/app/oracle/u01/oradata/testdb1/sysaux.dbf
Block Type Blocks Failing Blocks Processed
———- ————– —————-
Data 0 3174
Index 0 2624
Other 0 4597

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
—- —— ————– ———— ————— ———-
3 OK 0 81999 131072 654298
File Name: /wload/test1/app/oracle/u01/oradata/testdb1/undo01.dbf
Block Type Blocks Failing Blocks Processed
———- ————– —————-
Data 0 0
Index 0 0
Other 0 49073

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
—- —— ————– ———— ————— ———-
4 OK 0 4521 54176 647709
File Name: /wload/test1/app/oracle/u01/oradata/testdb1/users.dbf
Block Type Blocks Failing Blocks Processed
———- ————– —————-
Data 0 49079
Index 0 0
Other 0 576

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
—- —— ————– ———— ————— ———-
5 OK 0 25473 25600 18997
File Name: /wload/test1/app/oracle/u01/oradata/testdb1/tools.dbf
Block Type Blocks Failing Blocks Processed
———- ————– —————-
Data 0 0
Index 0 0
Other 0 127

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
—- —— ————– ———— ————— ———-
6 OK 0 6273 6400 350188
File Name: /wload/test1/app/oracle/u04/oradata/testdb1/COLLECT_DATA.dbf
Block Type Blocks Failing Blocks Processed
———- ————– —————-
Data 0 0
Index 0 0
Other 0 127

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
—- —— ————– ———— ————— ———-
7 OK 0 6273 6400 350467
File Name: /wload/test1/app/oracle/u04/oradata/testdb1/COLLECT_INDX.dbf
Block Type Blocks Failing Blocks Processed
———- ————– —————-
Data 0 0
Index 0 0
Other 0 127

channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
———— —— ————– —————
SPFILE OK 0 2
Control File OK 0 752
Finished backup at 28-03-2012 13:46:28

RMAN>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s