OraFAQ Forum: Data Guard » Real Time Apply -- does it apply to DG 9.2?

Home » Server Options » Data Guard » Real Time Apply -- does it apply to DG 9.2?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Real Time Apply -- does it apply to DG 9.2? [message #239914]

Wed, 23 May 2007 11:29

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

Real-time apply is documented in Oracle 10g, and no mention of it in Oracle 9.2; however, the use of Standby Redo Logs IS mentioned in Oracle 9.2. My question is:

If I am using Standby Redo Logs (and LGWR on a Physical Standby Database), is Real-Time Apply an option?

My guess is that it is NOT (and relates directly to a question by a colleague about the statement "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE", which probably does NOT work in DG 9.2).

Mike

Report message to a moderator

Re: Real Time Apply -- does it apply to DG 9.2? [message #239954 is a reply to message #239914]

Wed, 23 May 2007 13:47

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

"ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE",

is that necessary for realtime Dg??or can we use these commands as well?

•	SQL> Alter Database Recover Managed Standby Database;•	SQL> Alter Database Recover Managed Standby Database Disconnect;

Report message to a moderator

Re: Real Time Apply -- does it apply to DG 9.2? [message #239964 is a reply to message #239954]

Wed, 23 May 2007 14:31

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

OMG!!!
Real time is applicable through oracle 10gR1,According to this document there was no Real time in 9I.

Attachment: dg_pres1.ppt
(Size: 669.00KB, Downloaded 3061 times)

Report message to a moderator

Re: Real Time Apply -- does it apply to DG 9.2? [message #239976 is a reply to message #239964]

Wed, 23 May 2007 15:36

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

As I suspected...crap. Thanks!

Report message to a moderator

Re: Real Time Apply -- does it apply to DG 9.2? [message #240465 is a reply to message #239976]

Thu, 24 May 2007 23:59

asadaslam18
Messages: 16
Registered: May 2007
Location: nine

Junior Member

Ya its confirmed that real time apply is not part of oracle 9i its introduced in oracle 10g.

Now here is a problem how we will be able to configure MAXIMUM AVAILABILITY mode in oracle 9i?

Sad

Report message to a moderator

Re: Real Time Apply -- does it apply to DG 9.2? [message #240672 is a reply to message #239914]

Fri, 25 May 2007 08:31

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

In 9i rel 2, Maximum Protection and Maximum Availability only ensure that the data is written to a Standby Database before it is applied on the Primary Database (not that it is applied on the Standby Database). Because there is no Real-Time Apply, the transactions are applied when the next log file is switched.

The difference is that the Standby data is not applied "Real Time".

Report message to a moderator

Previous Topic:	problem with Next log sequence
Next Topic:	Change the location of archive file to new location for Primary DB.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 16:50:29 CST 2025