Re: DBverify like utility for archive log files

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

>

> -- 

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

>

>

>


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