All entries for Tuesday 17 March 2009

March 17, 2009

logical standby failed to re–start

It only give the following error messages.

krvxerpt: Errors detected in process 52, role LOGICAL STANDBY COORDINATOR.
Tue Mar 17 10:00:05 2009
krvsqn2s: unhandled failure 604

This happened when you set logical standby to skip some schemas.

The workaround is documented in metalink 748208.1

set echo on 
set pagesize 100 
spool workaround.log 
select * from system.logstdby$skip; 
select distinct nvl(esc, 'NULL') from system.logstdby$skip; 
select * from system.logstdby$skip where esc is null; 
update system.logstdby$skip 
set esc = '\' 
where esc is NULL; 

-- Following should return no rows (due to update above) 
select * from system.logstdby$skip where esc is null; 
-- should no longer see any NULL in output 
select distinct nvl(esc, 'NULL') from system.logstdby$skip; 
-- Capture a snapshot of the final results 
select * from system.logstdby$skip; 

-- commit changes 

Search this blog

Search Warwick Blogs



Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
Not signed in
Sign in

Powered by BlogBuilder