Re: DBverify like utility for archive log files

Tim

You could also consider setting the VERIFY option in your log_archive_dest_n parameter on the primary. But test it carefully, there might be quite a performance impact.

Stefan

On 6/18/07, Tim Onions <att755_at_hotmail.com> 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
>
>
>

-- 
=========================

Stefan P Knecht
Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

=========================

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