Hi all,
I have a Oracle 9.2.0.1.0 RAC system that I'm trying to set up a logical standby for. All was working well until the standby archive log destination filled up. I add space and the archive logs began coming in again but I noticed the changes were not being applied to the standby database. Oracle told me to
ALTER DATABASE ABORT LOGICAL STANDBY APPLY;
ALTER DATABASE START LOGICAL STANDBY APPLY;
..didn't work. The trace and alert messages say......
anybody see this before??????
*** 2002-10-03 15:21:04.475
WARNING: the following transaction makes no progress
WARNING: in the last 300 seconds for the given message!
WARNING: xid = 0x0009.02a.00001859 cscn = 197642182, message# = 2, slavid = 1