Tools can be used to copy archived log to remote host

Links: http://www.dbatools.net/experience/transfer_standby_archivelog.html

    Standby is a good way for disaster recovery, usually we create at least two standbys for each production database, one is locally with minimum time delay to the primary, and another is remotely in different city with 8 hours time delay for prevent human errors. How to transfer archived log to remote host? There are a lot of ways.

1,rsync with ssh protocol
2,rsync with rsh protocol
3,ftp server and client
4,scp utility
5,rcp utility
6,Oracle archive process in data guard mode

    Finally we choose the rsync with rsh or ssh protocol. Ftp is too old and not easy for automation with script. Scp is not effective. Rcp is good for local only. Oracle data guard does not tansfer archive log effectively. So the last choice is rsync utility, with rsh protocol first, and then ssh protocol.

    We use rsync2, a modified version of rsync with TCP timeout setting and increased TCP window size.

Post a comment

« Previous | Main | Next »

Powered by
Movable Type 3.36