Home » Server Options » Data Guard » DATA TRANSFER FROM PRIMARY TO STANDBY
DATA TRANSFER FROM PRIMARY TO STANDBY [message #241347] Tue, 29 May 2007 05:51 Go to next message
rrajesh_jain
Messages: 13
Registered: May 2007
Junior Member
HI I am Fresher dba. I want to know that if i have insert some records on primary database then whether they will transfer immideatly on standby location or not. if not then whether the changes will apply only after log switch on primary database then after applying the log to standby database. please help me
Re: DATA TRANSFER FROM PRIMARY TO STANDBY [message #241398 is a reply to message #241347] Tue, 29 May 2007 08:08 Go to previous messageGo to next message
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
Senior Member

What gets transferred WHEN depends on how you have configured you transport services (LGWR or ARCH). Also, when the data gets APPLIED depends on what version of Data Guard you are running. Beginning with DG 10.1, "real-time apply" is an option where the Standby Database applies the transactions received via LGWR as they arrive. In 9.2 and earlier, logs are applied when a log switch occurs.

M
Re: DATA TRANSFER FROM PRIMARY TO STANDBY [message #241549 is a reply to message #241398] Wed, 30 May 2007 00:03 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi M

Real Time means it will update the standby database as we make any change in particular ROW in Primary database or it will wait to receive the redo log or it will directly read the primary redo log and update that particular row.

One more thing i want to ask my database generate 800M of redo log in peak hrs will the data gaurd support it yes then how the redo log manage in real time


Kindly Help and Suggest


Tarun Mittal
Re: DATA TRANSFER FROM PRIMARY TO STANDBY [message #241594 is a reply to message #241347] Wed, 30 May 2007 02:22 Go to previous messageGo to next message
rrajesh_jain
Messages: 13
Registered: May 2007
Junior Member
Hi M
What do u mean by real time? pls explain in details M. this question has been asked me in a interview so it will be very helpful for me if u will explain in details.

Regards M
Re: DATA TRANSFER FROM PRIMARY TO STANDBY [message #241747 is a reply to message #241347] Wed, 30 May 2007 09:43 Go to previous messageGo to next message
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
Senior Member

The difference between "Real Time Apply" and other configurations is that Real Time Apply (RTA) does perform transactions on the Standby Database as they are written to the Online Redo Log file on the Primary Database. Normally (without RTA), the transactions are not applied until a log switch occurs on the Primary Database (which triggers a log switch of the Standby Redo Logs on the Standby Database).

Re: DATA TRANSFER FROM PRIMARY TO STANDBY [message #241763 is a reply to message #241747] Wed, 30 May 2007 10:21 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
As we commited changes on primary its reflect to our standby.
Not before commit.
Re: DATA TRANSFER FROM PRIMARY TO STANDBY [message #241805 is a reply to message #241347] Wed, 30 May 2007 11:47 Go to previous message
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
Senior Member

Precisely, thanks!
Previous Topic: Standby not applying archived redo logs / fixed
Next Topic: Switchover Stuff
Goto Forum:
  


Current Time: Tue Jul 29 20:51:05 CDT 2014

Total time taken to generate the page: 0.13242 seconds