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

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Tue, 16 Aug 2011 11:15:50 -0700 (PDT)
Message-ID: <1313518550.55754.YahooMailClassic_at_web120527.mail.ne1.yahoo.com>

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

Received on Tue Aug 16 2011 - 13:15:50 CDT