RE: ORACLE 11G data guard "real time apply " not work?

Also, have you checked your alert log for errors and looked at

 select * from V$DATAGUARD_STATUS order by TIMESTAMP;

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Goulet, Richard
Sent: Wednesday, August 17, 2011 10:33 AM
To: mccdba1@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Cc: oracle-db-l@xxxxxxxxxxxxxxxxxxxx
Subject: RE: ORACLE 11G data guard "real time apply " not work?

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

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


Other related posts: