https://community.hpe.com/t5/operating-system-hp-ux/standby-database/m-p/2878948#M937765 Hi<BR /><BR />I have a physical standby database using Oracle 9iR2 on HP-UX 11i. I am using 8 parallel recovery processes. My problem is that the standby database struggles to stay up to date with the primary db. The primary db generates about 1500 logs per day (100Mb each). Is there anything I can do to increase the rate at which logs are applied on the standby.<BR /><BR />Thanks Fri, 10 Jan 2003 12:51:29 GMT Dallas Blackett 2003-01-10T12:51:29Z https://community.hpe.com/t5/operating-system-hp-ux/standby-database/m-p/2878948#M937765 Hi<BR /><BR />I have a physical standby database using Oracle 9iR2 on HP-UX 11i. I am using 8 parallel recovery processes. My problem is that the standby database struggles to stay up to date with the primary db. The primary db generates about 1500 logs per day (100Mb each). Is there anything I can do to increase the rate at which logs are applied on the standby.<BR /><BR />Thanks Fri, 10 Jan 2003 12:51:29 GMT https://community.hpe.com/t5/operating-system-hp-ux/standby-database/m-p/2878948#M937765 Dallas Blackett 2003-01-10T12:51:29Z https://community.hpe.com/t5/operating-system-hp-ux/standby-database/m-p/2878949#M937766 This sounds like a tuning issue or that your stand-by database is too under powered.<BR /><BR />If you look at your standby database are you getting any bottlenecks?<BR />e.g. does sar -d 10 10 show any hot disks?<BR />Does top sho high processor utilization (or viewed through sar -c 10 10)<BR />or are you seeing bottlenecks with memory sar -m 10 10)<BR /><BR />Can you describe the hardware running on both servers? CPU's, class, RAM, and how the storage is set up? (Fibre, SAN, etc.) Sat, 11 Jan 2003 00:05:45 GMT https://community.hpe.com/t5/operating-system-hp-ux/standby-database/m-p/2878949#M937766 SteveKirby 2003-01-11T00:05:45Z