Question, Do you have standby logfiles configured? If not then real time apply cannot function since it's waiting for the EOF marker on the current logfile. Richard Goulet Senior Oracle DBA/Na Team Leader -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc Sent: Tuesday, August 16, 2011 2:16 PM To: oracle-l@xxxxxxxxxxxxx Cc: oracle-db-l@xxxxxxxxxxxxxxxxxxxx Subject: ORACLE 11G data guard "real time apply " not work? we have a database original on ORACLE 10.2.0.4 and we upgrade it to 11.1.0.7. after that we create standby database and tried to use "real time apply" feature. Primary database can transfer log files to standby database and standby database also can apply logs. The problem is it can NOT work on "real time apply". Ant ideal what wrong? === procedures ====== (standby database) SQL> startup mount; ORACLE instance started. Total System Global Area 2087780352 bytes Fixed Size 2161272 bytes Variable Size 1795163528 bytes Database Buffers 251658240 bytes Redo Buffers 38797312 bytes Database mounted. SQL> alter database open read only; Database altered. SQL> alter database recover managed standby database using current SQL> logfile disconnect; Database altered. SQL> select PROTECTION_MODE, PROTECTION_LEVEL, DATABASE_ROLE, SQL> SWITCHOVER_STATUS, OPEN_MODE, GUARD_STATUS from v$database; PROTECTION_MODE PROTECTION_LEVEL DATABASE_ROLE SWITCHOVER_STATUS -------------------- -------------------- ---------------- -------------------- OPEN_MODE GUARD_S ---------- ------- MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE PHYSICAL STANDBY NOT ALLOWED MOUNTED NONE SQL> select process, status from v$managed_standby; PROCESS STATUS --------- ------------ ARCH CONNECTED ARCH CONNECTED ARCH CONNECTED ARCH CONNECTED RFS IDLE MRP0 APPLYING_LOG 6 rows selected. ========== Primary database init.ora file setup ===== ### for DG use db_unique_name = DBPMY log_archive_config='dg_config=(DBPMY,DBSBY)' log_archive_dest_1='LOCATION=/Archive/DBPMY/arch/arch MANDATORY' log_archive_dest_2='service=DBSBY valid_for=(online_logfiles,primary_role) db_unique_name=DBSBY LGWR ASYNC=20480 OPTIONAL REOPEN=15 NET_TIMEOUT=30' *.log_archive_format='DBPMY_%r_%t_%s.arc' log_archive_dest_state_1 = enable log_archive_dest_state_2 = enable -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l