Re: checking for block corruption

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Tue, 22 May 2012 13:34:51 +0530
Message-ID: <CAJsOtB5aPjzo7-yBfEz4fpj3Fy7g5qu5iAjqEUuUpO_aATvw1g_at_mail.gmail.com>



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_at_gmail.com> 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).
>
>
> --
> http://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.
=============================================


--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 22 2012 - 03:04:51 CDT

Original text of this message