ORACLE 10GR2 data guard real time apply did NOT work??
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 5 Jan 2009 07:24:14 -0800 (PST)
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 <====
--
//www.freelists.org/webpage/oracle-l
Other related posts:
