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

haven't set up an active data guard myself until now, but what I can see from the documentation is that there, the "alter database open" is specified without the read only. might give that a try. reference: http://download.oracle.com/docs/cd/E11882_01/server.112/e17022/manage_ps.htm#CHDGJEFF

Best regards,
Robert
http://robertvsoracle.blogspot.com

On Tue, Aug 16, 2011 at 8:15 PM, dba1 mcc <mccdba1_at_yahoo.com> wrote:
> 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 logfile disconnect;
>
> Database altered.
>
> SQL> select PROTECTION_MODE, PROTECTION_LEVEL, DATABASE_ROLE, 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