How to rate archive log transfer between database and standby
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to rate archive log transfer between database and standby

Hybrid View

  1. #1
    Join Date
    Nov 2012
    Posts
    2

    How to rate archive log transfer between database and standby

    Hello,

    I want to know what is the rate transfer of the archivelog between my database server and it standby database server because it seems that it is very long. Do you know some requests or some things which can help me ?

    Regards

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    Try using scp to copy 50MB files and see how long that takes. It should tell you what the throughput is on the network alone. Then you can decide if you are having a network issue or a database issue. You can also add additional redo log groups which will make it less likely that the logs go through all of the redo groups before the current redo log is archived.
    this space intentionally left blank

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