OraFAQ Forum: Data Guard » DATA TRANSFER FROM PRIMARY TO STANDBY

Home » Server Options » Data Guard » DATA TRANSFER FROM PRIMARY TO STANDBY

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

DATA TRANSFER FROM PRIMARY TO STANDBY [message #241347]

Tue, 29 May 2007 05:51

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

Report message to a moderator

Re: DATA TRANSFER FROM PRIMARY TO STANDBY [message #241398 is a reply to message #241347]

Tue, 29 May 2007 08:08

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

Report message to a moderator

Re: DATA TRANSFER FROM PRIMARY TO STANDBY [message #241549 is a reply to message #241398]

Wed, 30 May 2007 00:03

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

Report message to a moderator

Re: DATA TRANSFER FROM PRIMARY TO STANDBY [message #241594 is a reply to message #241347]

Wed, 30 May 2007 02:22

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

Report message to a moderator

Re: DATA TRANSFER FROM PRIMARY TO STANDBY [message #241747 is a reply to message #241347]

Wed, 30 May 2007 09:43

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).

Report message to a moderator