http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/log_arch_dest_param.htm#82634 Example log_archive_dest_2="SERVICE=tns_entry_here ARCH NOAFFIRM OPTIONAL REOPEN=seconds" Which version/platform is this problem occuring? HTH GovindanK On Mon, 5 Mar 2007 10:32:13 -0700, "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx> said: > Can't recall the exact parameter off the top of my head, but there is > one that can be set to intentionally force a delay on the application of > logs to the standby. It is done to give you a chance to prevent logical > corruption/user error (e.g. accidental drop/delete) from being > propagated to the standby if you desire to do so. You might want to > look up the parameter and confirm if it's set or not. If that's not the > cause, then check the wait events for the log apply session and see > where it's spending it's time. > > Regards, > Brandon > > -- //www.freelists.org/webpage/oracle-l