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.
SQL> alter database recover managed standby database using current logfile disconnect;
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 bytesDatabase 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-lReceived on Mon Jan 05 2009 - 09:24:14 CST