Home » Server Options » Data Guard » Redo apply (Oracle 10.2.0.1.0 - Linux)
Redo apply [message #349037] Thu, 18 September 2008 11:55 Go to next message
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.



Re: Redo apply [message #349038 is a reply to message #349037] Thu, 18 September 2008 11:58 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
.. I forgot to mention the standby DB is working with real time apply...
Re: Redo apply [message #349049 is a reply to message #349038] Thu, 18 September 2008 12:54 Go to previous messageGo to next message
macdba
Messages: 27
Registered: May 2005
Location: US
Junior Member
Wait till you apply log 74594 and then check....

regards
--Mak
Re: Redo apply [message #349249 is a reply to message #349037] Fri, 19 September 2008 09:00 Go to previous messageGo to next message
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!
Re: Redo apply [message #349251 is a reply to message #349037] Fri, 19 September 2008 09:13 Go to previous messageGo to next message
BlackSwan
Messages: 25039
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?
Re: Redo apply [message #349254 is a reply to message #349251] Fri, 19 September 2008 09:17 Go to previous messageGo to next message
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?
Re: Redo apply [message #350649 is a reply to message #349254] Thu, 25 September 2008 15:50 Go to previous message
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:
  


Current Time: Mon Dec 05 21:06:06 CST 2016

Total time taken to generate the page: 0.08134 seconds