RE: checking for block corruption

  • From: wblanchard@xxxxxxxxxxxxxxx
  • To: JSweetser@xxxxxxxx
  • Date: Mon, 21 May 2012 14:42:58 -0500

11g allows this command to be run.  You are using a 10g database.


From:   "Sweetser, Joe" <JSweetser@xxxxxxxx>
To:     "oracledbaquestions@xxxxxxxxx" <oracledbaquestions@xxxxxxxxx>, 
ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date:   05/21/2012 02:27 PM
Subject:        RE: checking for block corruption
Sent by:        oracle-l-bounce@xxxxxxxxxxxxx

I can't answer your question as to "why" but metalink note 466875.1 
implies the only way to accomplish what you want is to run the command 
while the database is mounted, but not open.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 
On Behalf Of Dba DBA
Sent: Monday, May 21, 2012 12:43 PM
Subject: checking for block corruption

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
DB Version:
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
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).


Confidentiality Note: This message contains information that may be 
confidential and/or privileged. If you are not the intended recipient, you 
should not use, copy, disclose, distribute or take any action based on 
this message. If you have received this message in error, please advise 
the sender immediately by reply email and delete this message. Although 
ICAT Managers, LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail 
and attachments for viruses, it does not guarantee that either are 
virus-free and accepts no liability for any damage sustained as a result 
of viruses. Thank you.


Although this e-mail and any attachments are believed to be free of any virus 
or other defect which might affect any computer system, it is the 
responsibility of the recipient to check that it is virus-free and the sender 
accepts no responsibility or liability for any loss, injury, damage, cost or 
expense arising in any way from receipt or use thereof by the recipient.

The information contained in this electronic mail message is confidential 
information and intended only for the use of the individual or entity named 
above, and may be privileged.  If the reader of this message is not the 
intended recipient, you are hereby notified that any dissemination, 
distribution or copying of this communication is strictly prohibited.  If you 
have received this transmission in error, please  contact the sender 
immediately, delete this material from your computer and destroy all related 
paper media.  Please note that the documents transmitted are not intended to be 
binding until a hard copy has been manually signed by all parties.
Thank you.


Other related posts: