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 
commit;

- 5 comments by 0 or more people Not publicly viewable

  1. Online Consultancy

    yeah, you really know your stuff.

    07 Apr 2009, 12:32

  2. City speed dating

    nice coding you done here, i will try it once,,

    12 Jun 2009, 13:08

  3. John Bergeron

    So what happen City speed dating when you tried this coding once in your PC..
    Please tell me so i am try it once..

    16 Jun 2009, 11:36

  4. robot vacuum

    Thanks for the nice information because from last three days i am stuck on this problem….

    18 Jun 2009, 12:52

  5. anemia

    “logical standby failed to re–start, I am also getting the same error. I have search on internet and I think its because of installation problem in database.

    11 Sep 2009, 11:30


Add a comment

You are not allowed to comment on this entry as it has restricted commenting permissions.

Search this blog

Search Warwick Blogs

 

Tags

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
© MMXXII