OraFAQ Forum: Data Guard

Home » Server Options » Data Guard » Redo apply (Oracle 10.2.0.1.0 - Linux)

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

Redo apply [message #349037]

Thu, 18 September 2008 11:55

danyromimd
Messages: 73
Registered: August 2008

Member

Hi!
I'm using Data Guard with a phisical standby DB.
First I execute the command 'ALTER SYSTEM SWITCH LOGFILE;'
Then I make an insert in a table, and execute the command 'ALTER SYSTEM ARCHIVE LOG CURRENT;'
Redo logs are transfered from principal to standby and they seem to be applied ...

Principal DB
SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIM NEXT_TIME
---------- --------- ---------
74592 18-SEP-08 18-SEP-08
74592 18-SEP-08 18-SEP-08
74593 18-SEP-08 18-SEP-08
74593 18-SEP-08 18-SEP-08
74594 18-SEP-08 18-SEP-08

Standby DB
SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG;

SEQUENCE# APP
---------- ---
74592 YES
74593 YES

... but when I query in the standby DB the table where I made the insert, it doesn't seem to have received any new data.
Which might be the problem?

Thanks in advance.

Report message to a moderator

Re: Redo apply [message #349038 is a reply to message #349037]

Thu, 18 September 2008 11:58

danyromimd
Messages: 73
Registered: August 2008

Member

.. I forgot to mention the standby DB is working with real time apply...

Report message to a moderator

Re: Redo apply [message #349049 is a reply to message #349038]

Thu, 18 September 2008 12:54

macdba
Messages: 27
Registered: May 2005
Location: US

Junior Member

Wait till you apply log 74594 and then check....

regards
--Mak

Report message to a moderator

Re: Redo apply [message #349249 is a reply to message #349037]

Fri, 19 September 2008 09:00

danyromimd
Messages: 73
Registered: August 2008

Member

How much time does it pass between a modification in the Primary DB and its application in the Standby DB, having real time apply?
I've read it doesn't wait for the log to get full to send data... so I thought it would be applied instantly.

Thanks!

Report message to a moderator

Re: Redo apply [message #349251 is a reply to message #349037]

Fri, 19 September 2008 09:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Then I make an insert in a table, and execute the command 'ALTER SYSTEM ARCHIVE LOG CURRENT;'

When was the COMMIT issued?

Report message to a moderator

Re: Redo apply [message #349254 is a reply to message #349251]

Fri, 19 September 2008 09:17

danyromimd
Messages: 73
Registered: August 2008

Member

Oh! Sorry I didn't mention it...
1)INSERT...
2)COMMIT...
3)ALTER SYSTEM...

Do I always have to execute an "Alter system..." to make the data go to the Standby DB instantly?

Report message to a moderator

Re: Redo apply [message #350649 is a reply to message #349254]

Thu, 25 September 2008 15:50

Khurram Siddiqui
Messages: 5
Registered: March 2004

Junior Member

Read this thread

http://oraware.blogspot.com/2008/09/how-standby-redo-apply.html

HTH

Khurram

[Updated on: Fri, 26 September 2008 01:18] by Moderator

Report message to a moderator

Previous Topic:	Logical standby database set up
Next Topic:	Standby Problem in 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 01 11:47:17 CDT 2025