RMAN can do a validation of the datafile- You don't need a backup in advance to do this. In RMAN - validate datafile X; where X is the datafile number. Then check v$block_corruption for additional results. You can also use Database Verify (DBV) utility. DBV is a standalone program, so the db does not need to be running to use dbv. For raw devices I have never used DBV- may or may not work :) -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Subodh Deshpande Sent: Tuesday, May 22, 2012 4:05 AM To: oracledbaquestions@xxxxxxxxx Cc: ORACLE-L Subject: Re: checking for block corruption you want to check the corruption in files..following links may help you.. http://docs.oracle.com/cd/B19306_01/server.102/b14215/dbverify.htm https://forums.oracle.com/forums/thread.jspa?threadID=973516 On 22 May 2012 00:13, Dba DBA <oracledbaquestions@xxxxxxxxx> wrote: > I need to run a block corruption test. I have a BCV copy of prod I am > running this on. We are not using RMAN for prod backups. I can't change > this. > DB Version: 10.2.0.5.6 > DB Size: 10 TBs > files are on raw partitions > rman target / > > backup validate database; > > if I run this will this actually backup the DB? When I read the docs they > seemed to say it would only do a validate check. We have the DB copy in > noarchivelog mode. > When I ran that command I get: > > RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/21/2012 > 16:05:09 > ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode > > If backup validate only checks for block corruption why does it care if I > am in archivelog mode ( i know i can bounce the db or turn it off. I want > to make sure I'm not actually taking a backup). > > > -- > //www.freelists.org/webpage/oracle-l > > > -- ============================================= Love me or Hate me both are in my Favour. Love me, I am in your Heart. Hate me, I am in your Mind. ============================================= -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l