I have just started trying to catch up my standby database and applying
the arcive logs.
Below is the alert log from the standby server. It apparently 'sees' a
few logs, copies them from the primary, applies them, then moves on....
most of the time. OFTEN I get long pauses when a fetch fails.
Why would a fetch fail? How can I improve the fetch rate?
Media Recovery Log /oracle/PRD/saparch/PRDarch1_121154.dbf
Media Recovery Log /oracle/PRD/saparch/PRDarch1_121155.dbf
Error opening /oracle/PRD/saparch/PRDarch1_121155.dbf
Attempting refetch
Media Recovery Waiting for thread 1 seq# 121155
Fetching gap sequence for thread 1, gap sequence 121155-121155
Trying FAL server: prd.world
Tue Nov 14 16:38:18 2006
Failed to request gap sequence. Thread #: 1, gap sequence:
121155-121155
All FAL server has been attempted.
Media Recovery Log /oracle/PRD/saparch/PRDarch1_121155.dbf
Media Recovery Log /oracle/PRD/saparch/PRDarch1_121156.dbf
Error opening /oracle/PRD/saparch/PRDarch1_121156.dbf
Attempting refetch
Media Recovery Waiting for thread 1 seq# 121156
Fetching gap sequence for thread 1, gap sequence 121156-121156
Trying FAL server: prd.world
Tue Nov 14 16:40:22 2006
Failed to request gap sequence. Thread #: 1, gap sequence:
121156-121156
All FAL server has been attempted.
Media Recovery Log /oracle/PRD/saparch/PRDarch1_121156.dbf
Media Recovery Log /oracle/PRD/saparch/PRDarch1_121157.dbf
Error opening /oracle/PRD/saparch/PRDarch1_121157.dbf
Attempting refetch
Media Recovery Waiting for thread 1 seq# 121157
Fetching gap sequence for thread 1, gap sequence 121157-121157
Trying FAL server: prd.world
Tue Nov 14 16:43:47 2006
Failed to request gap sequence. Thread #: 1, gap sequence:
121157-121157
All FAL server has been attempted.
Media Recovery Log /oracle/PRD/saparch/PRDarch1_121157.dbf
Media Recovery Log /oracle/PRD/saparch/PRDarch1_121158.dbf
Error opening /oracle/PRD/saparch/PRDarch1_121158.dbf
Attempting refetch
Media Recovery Waiting for thread 1 seq# 121158
Fetching gap sequence for thread 1, gap sequence 121158-121158
Trying FAL server: prd.world
Tue Nov 14 16:46:54 2006
Failed to request gap sequence. Thread #: 1, gap sequence:
121158-121158
All FAL server has been attempted.
Both servers are HP-UX11i running Oracle 9i (9.2.0.4). I get <1ms ping
times and ALWAYS get a good response using TNSPING. Ideas?
Thanks!
Vince
Received on Tue Nov 14 2006 - 16:50:45 CST