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;
Hongfeng Sun
17 Mar 2009 10:37
| 
Tags: Oracle-Availability
| 
Comments (5)
| 
Report a problem
Online Consultancy
yeah, you really know your stuff.
07 Apr 2009, 12:32
City speed dating
nice coding you done here, i will try it once,,
12 Jun 2009, 13:08
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
robot vacuum
Thanks for the nice information because from last three days i am stuck on this problem….
18 Jun 2009, 12:52
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.