Re: DBverify like utility for archive log files

  • From: "Daniel W. Fink" <daniel.fink@xxxxxxxxxxxxxx>
  • To: att755@xxxxxxxxxxx
  • Date: Mon, 18 Jun 2007 05:00:26 -0600

Try

ALTER SYSTEM DUMP LOGFILE <filename>;


This will read the entries in the logfile using the same mechanism that is used for recovery purposes.



--
Daniel Fink

Oracle Performance, Diagnosis and Training

OptimalDBA    http://www.optimaldba.com
Oracle Blog   http://optimaldba.blogspot.com



Tim Onions wrote:
Dear All

It's Monday morning after a hard weekend's 9i->10g/Windows->Linux migration and my brain is in a "London fog" so please excuse me if this is a RTFM question (which I have done and googled to no result).

I wish to verify my archive log files that are shipped via non-managed DG to a server 1000km away before attempting to apply them. I recall Oracle suggesting this was possible in the past but cannot find anything to indicate how it is done. The DBV manual only talks about database files and segments, google comes up with a lot of hits on verifying archive logs backed up into RMAN.

The "issue" I have is I do not want to try and apply an archive log file if it got corrupted during transfer or transfer took place whilst Oracle was still creating the file on the source server (ie the file is only partially written). I was given the architecture so have no influence on using managed DG instead.

Environment is:

Oracle 10.3, RAC, Linus RHEL64, EMC DMX-3 storage and SRDF-A

Many thanks

Tim Onions

_________________________________________________________________
The next generation of Hotmail is here! http://www.newhotmail.co.uk

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




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


Other related posts: