Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DBverify like utility for archive log files

Re: DBverify like utility for archive log files

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Mon, 18 Jun 2007 23:49:30 +1000
Message-ID: <46768D6A.9030209@ixora.com.au>


Alternative, if you just want to verify the integrity of the logfiles without dumping their contents, you can specify a non-existent layer and opcode as follows ...

   alter system dump logfile 'filespec' layer 99 opcode 99;

That will read the log file and check the layer and opcode of each change vector. Of course, none will match 99.99 so the trace file will only contain the dump of the file header and then the redo read statistics that would normally be right at the end of the dump.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/         - For DBAs
@   http://www.christianity.net.au/  - For all

-----Original Message-----
Date: Mon, 18 Jun 2007 08:14:06 -0400
From: rjamya <rjamya_at_gmail.com>
To: daniel.fink_at_optimaldba.com
Subject: Re: DBverify like utility for archive log files Cc: att755_at_hotmail.com, Oracle-L_at_freelists.org

> and make sure that you have enough space in your *_dump_dest location to
> hold the files ....
>
> Raj
>
> On 6/18/07, *Daniel W. Fink* < daniel.fink_at_optimaldba.com
> <mailto:daniel.fink_at_optimaldba.com>> wrote:
>
> Try
>
> ALTER SYSTEM DUMP LOGFILE <filename>;
>
>
> This will read the entries in the logfile using the same mechanism that
> is used for recovery purposes.
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 18 2007 - 08:49:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US