Home » Server Options » Data Guard » Real-time Redo Apply (Oracle 9.0.2.0.0 Windows Server 2003)
Real-time Redo Apply [message #283156] Mon, 26 November 2007 03:56 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
DEar all,

I had successfully configured dataguard with physical standby ,i also added standby redolog files at standby DB for real time redo apply and everything working fine
but its not real-time apply
once i made some trannsactions DDL/DML at Primary DB and then goto standby DB to confirm whether the transactions are also applied at Standby DB because we had configured real-time apply but the transactions are not applied until the archivelogs generated from primary DB ,transferred and successfully applied at Standby DB

what could be the reasons?
please suggest!
Re: Real-time Redo Apply [message #283169 is a reply to message #283156] Mon, 26 November 2007 04:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on your configuration.
For introduction, see:
Data Guard Concepts and Administration
Part I Concepts and Administration
Chapter 1 Introduction to Oracle Data Guard
Section 1.4 Data Guard Protection Modes

Then:
Chapter 5 Redo Transport Services
Section 5.6 Setting Up a Data Protection Mode

Regards
Michel
Re: Real-time Redo Apply [message #283278 is a reply to message #283169] Mon, 26 November 2007 10:27 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Post the archiving parameters list like

SQL>  show parameter log_archive_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
Re: Real-time Redo Apply [message #283391 is a reply to message #283278] Tue, 27 November 2007 00:35 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
At primary DB

NAME TYPE VALUE
------------------------------------ ----------- -----------------------------
log_archive_dest string
log_archive_dest_1 string LOCATION=d:\archive_primarylog_archive_dest_10 string
log_archive_dest_2 string SERVICE=STDY LGWR SYNC AFFIRM
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string

NAME TYPE VALUE
------------------------------------ ----------- -----------------------------
log_archive_dest_state_1 string ENABLE
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable

At Standby DB

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string LOCATION=d:\archive_standby
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_9 string
log_archive_dest_state_1 string ENABLE
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable

But i came to know that Real-time redo apply is not possible in 9i
just find an article at http://www.dbasupport.com/oracle/ora10g ... er02.shtml

Oracle 10g Availability Enhancements, Part 4: LogMiner and Data Guard
Real-Time Application of Standby Redo Logs. The transmission and application of archived redo logs is at the heart of a Data Guard configuration. Oracle 9iR2 added the capability to write redo entries to the primary database's online redo logs and simultaneously to a set of standby redo logs that are set up on the standby database server. Standby redo logs therefore help to limit data loss because normally a standby database waits for the transmission of a complete archived redo log from the primary database before the redo entries stored within are readied for application against the standby database.

Oracle 10g significantly increases the availability of the standby database with the new Real-Time Apply feature. As redo entries are written to the standby redo logs, Real-Time Apply automatically applies the changes immediately to the standby database. This insures that the time required for activation, switchover, and switchback of the standby database is significantly reduced. This feature is activated by specifying the USING CURRENT LOGFILE directive when the Log Apply service is started on the standby database:

-- Start Real-Time Apply
RECOVER MANAGED STANDBY DATABASE DISCONNECT USING CURRENT LOGFILE;

thats what i was asking about but one last thing please
i had 3 Redolog files at primary DB named as
Redo01
Redo02
Redo03
and also added 3-New Standby Redolog files at Primary DB just for switchover purpose ,from prim1 to stdy and again from stdy to prim1

ALTER DATABASE
ADD STANDBY LOGFILE GROUP 4 ('D:\oracle\oradata\testdb\REDO04.ORA')
SIZE 50M;
SQL>ALTER DATABASE
ADD STANDBY LOGFILE GROUP 5 ('D:\oracle\oradata\testdb\REDO05.ORA')
SIZE 50M;
ALTER DATABASE
ADD STANDBY LOGFILE GROUP 6 ('D:\oracle\oradata\testdb\REDO06.ORA')
SIZE 50M;

Redo04
Redo05
Redo06

and while i was setting up Physical Standby Db i added standby 3-Redolog files at standby DB
ALTER DATABASE
ADD STANDBY LOGFILE GROUP 7 ('D:\oracle\oradata\stdy\REDO07.ORA')
SIZE 50M;
SQL>ALTER DATABASE
ADD STANDBY LOGFILE GROUP 8 ('D:\oracle\oradata\stdy\REDO08.ORA')
SIZE 50M;
ALTER DATABASE
ADD STANDBY LOGFILE GROUP 9 ('D:\oracle\oradata\stdy\REDO09.ORA')
SIZE 50M;

My Question Is :
Should i need to copy Online Redolog Files named as
Redo01
Redo02
Redo03
from primary DB to standby DB with Datafiles and standby control files

please suggest!
Re: Real-time Redo Apply [message #283400 is a reply to message #283391] Tue, 27 November 2007 00:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Primary and physical standby redo logs are uncorrelated.
They don't need to match in any way.

Regards
Michel
Re: Real-time Redo Apply [message #283401 is a reply to message #283156] Tue, 27 November 2007 01:00 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
SO i don't need to copy online redolog files
REDO01
REDO02
REDO03
from primary DB to Standby DB
Standby DB will use its standby redolog files instead
Am i Right Sir?
Re: Real-time Redo Apply [message #283404 is a reply to message #283401] Tue, 27 November 2007 01:11 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

SO i don't need to copy online redolog files

Correct.

Quote:

Standby DB will use its standby redolog files instead

Standby don't use redo logs when in recovery mode.
It will use its own redo logs if you open it.

Regards
Michel
Previous Topic: help implementation ORACLE DATA GUARD 10G
Next Topic: ora-00314 after "alter system switch logfile"
Goto Forum:
  


Current Time: Thu Mar 28 05:37:59 CDT 2024