DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 13

Thread: standby database - corrupt archive redo logs

Threaded View

  1. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    What might be happening is that the standby is grabbing the archivelog while it is still being written. If you use Oracle's method whereby the files are SENT by the prod machine this will not occur (need to look in the Friendly Manual for that).


    You don't say what OS you're running. Under NT, I also have the standby PULL the files from prod:

    On prod server:
    - periodically MOVE archlogs to another directory - this fails due to OS locking if the archlog is not completely written (apparently this does not provide protection under UNIX). Any missed files are moved in the next cycle.
    - zip the archlogs (this saves a factor of 5 in size - less network load)

    On Standby:
    - periodically "grab" the zipped files, unzip and apply. The unzipping will fail if there has been corruption in network transfer (never happened yet).


    gopi, how did you get on doing this under UNIX?
    Last edited by DaPi; 05-21-2003 at 07:10 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width