Home » Server Options » Data Guard » set time delay sending log file (rdbms 9.2)
set time delay sending log file [message #338504] Tue, 05 August 2008 04:42 Go to next message
dendi_rm
Messages: 3
Registered: August 2008
Junior Member
Hi all,

how to set time delay sending log file from production server to DRC site ?

Thanks.

Best regards,
dendi
Re: set time delay sending log file [message #338518 is a reply to message #338504] Tue, 05 August 2008 05:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ARCHIVE_LAG_TARGET

Regards
Michel
Re: set time delay sending log file [message #338778 is a reply to message #338518] Tue, 05 August 2008 23:00 Go to previous messageGo to next message
dendi_rm
Messages: 3
Registered: August 2008
Junior Member
I think this parameter to make sure oracle to switch a log every n seconds.
Does oracle have a parameter to set time delay to sending archived log to standby database ?

I need this to make minimum time limit archived log transport.

Thank you.

Regards,
dendi
Re: set time delay sending log file [message #338787 is a reply to message #338504] Tue, 05 August 2008 23:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above


What problem are you REALLY trying to solve?
Re: set time delay sending log file [message #338791 is a reply to message #338778] Tue, 05 August 2008 23:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle send it as soon as possible unless you defined a delay.

Regards
Michel

[Updated on: Tue, 05 August 2008 23:23]

Report message to a moderator

Re: set time delay sending log file [message #338794 is a reply to message #338504] Tue, 05 August 2008 23:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
The use of standby redo log file applies changes (near?) real time.
Re: set time delay sending log file [message #338908 is a reply to message #338791] Wed, 06 August 2008 04:24 Go to previous message
dendi_rm
Messages: 3
Registered: August 2008
Junior Member
Ok ...thanks all for your help.

i make a delay in applying log in standby using DELAY='n minutes' in parameter.

Kind regards,
dendi
Previous Topic: Replica of DataBase
Next Topic: remote standby database behind firewall
Goto Forum:
  


Current Time: Thu Mar 28 15:19:40 CDT 2024