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

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Wed, 17 Aug 2011 16:32:53 +0000
Message-ID: <7642C3D639A75E4284658CAA38BF60A40145F0_at_US-BOS-VEX001.eu.pxl.int>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Tuesday, August 16, 2011 2:16 PM
To: oracle-l_at_freelists.org
Cc: oracle-db-l_at_Groups.ITtoolbox.com
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

Received on Wed Aug 17 2011 - 11:32:53 CDT