RE: checking for block corruption

And to answer your question about the backups themselves....the command will 
not actually backup anything.

http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup005.htm


-joe

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Sweetser, Joe
Sent: Monday, May 21, 2012 1:22 PM
To: oracledbaquestions@xxxxxxxxx; ORACLE-L
Subject: RE: checking for block corruption

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.

Hth,
-joe

-----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
To: ORACLE-L
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
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).


--
http://www.freelists.org/webpage/oracle-l



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.

--
http://www.freelists.org/webpage/oracle-l



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.

--
http://www.freelists.org/webpage/oracle-l


Other related posts: