Re: DBverify like utility for archive log files

  • From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • To: att755@xxxxxxxxxxx
  • Date: Mon, 18 Jun 2007 17:56:05 +0200

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@xxxxxxxxxxx> 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





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

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@xxxxxxxxxxxx
http://www.trivadis.com

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

Other related posts: