RE: checking for block corruption
- From: "CRISLER, JON A" <JC1706@xxxxxxx>
- To: "wblanchard@xxxxxxxxxxxxxxx" <wblanchard@xxxxxxxxxxxxxxx>
- Date: Tue, 22 May 2012 17:54:50 +0000
Opps, my mistake. Another reason to upgrade :)
From: wblanchard@xxxxxxxxxxxxxxx [mailto:wblanchard@xxxxxxxxxxxxxxx]
Sent: Tuesday, May 22, 2012 10:40 AM
To: CRISLER, JON A
Cc: deshpande.subodh@xxxxxxxxx; ORACLE-L; oracle-l-bounce@xxxxxxxxxxxxx;
oracledbaquestions@xxxxxxxxx
Subject: RE: checking for block corruption
This only works in 11g. The original poster stated that the database is a 10g
database.
WGB
From: "CRISLER, JON A" <JC1706@xxxxxxx>
To: "deshpande.subodh@xxxxxxxxx" <deshpande.subodh@xxxxxxxxx>,
"oracledbaquestions@xxxxxxxxx" <oracledbaquestions@xxxxxxxxx>
Cc: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: 05/22/2012 09:34 AM
Subject: RE: checking for block corruption
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
________________________________
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?3516
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
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
