ORACLE 10GR2 data guard real time apply did NOT work??

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Mon, 5 Jan 2009 07:24:14 -0800 (PST)
Message-ID: <270953.32251.qm_at_web65714.mail.ac4.yahoo.com>



We have ORACLE 10.2.0.4 on two Redhat LINUX. I tried to setup "real time apply" on standby database, there is No error but data NOT update.

Anyone know why:


%sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jan 5 10:15:03 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup mount pfile=initT102.ora
ORACLE instance started.

Total System Global Area 595591168 bytes

Fixed Size                  1268824 bytes
Variable Size             482345896 bytes
Database Buffers          104857600 bytes
Redo Buffers                7118848 bytes
Database mounted.
SQL> alter database recover managed standby database using current logfile disconnect;

Database altered.

SQL> select process, status from v$managed_standby;

PROCESS STATUS
--------- ------------

ARCH      CONNECTED
ARCH      CONNECTED
MRP0      WAIT_FOR_LOG      <====




      
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 05 2009 - 09:24:14 CST

Original text of this message