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 =========================