OraFAQ Forum: Data Guard » set time delay sending log file

Home » Server Options » Data Guard » set time delay sending log file (rdbms 9.2)

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

set time delay sending log file [message #338504]

Tue, 05 August 2008 04:42

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

Report message to a moderator

Re: set time delay sending log file [message #338518 is a reply to message #338504]

Tue, 05 August 2008 05:07

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ARCHIVE_LAG_TARGET

Regards
Michel

Report message to a moderator

Re: set time delay sending log file [message #338778 is a reply to message #338518]

Tue, 05 August 2008 23:00

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

Report message to a moderator

Re: set time delay sending log file [message #338787 is a reply to message #338504]

Tue, 05 August 2008 23:19

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?

Report message to a moderator

Re: set time delay sending log file [message #338791 is a reply to message #338778]

Tue, 05 August 2008 23:23

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

The use of standby redo log file applies changes (near?) real time.

Report message to a moderator

Re: set time delay sending log file [message #338908 is a reply to message #338791]

Wed, 06 August 2008 04:24

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

Report message to a moderator

Previous Topic:	Replica of DataBase
Next Topic:	remote standby database behind firewall

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 21 14:45:55 CDT 2025