OraFAQ Forum: Data Guard » importance of standby_archive_dest in dataguard/Real time log application in Oracle9i

Home » Server Options » Data Guard » importance of standby_archive_dest in dataguard/Real time log application in Oracle9i

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

importance of standby_archive_dest in dataguard/Real time log application in Oracle9i [message #288704]

Tue, 18 December 2007 06:53

pankajkmeena
Messages: 46
Registered: September 2007

Member

Can some one help abt

1) Is it possible to configure real time log application in Oracle 9i .I come to know abt using current logfile option .But wont work in 9i . I configured standby redo log file

2) Is standby_archive_dest parameter is of any importance in databa guard configuration (manual switch over). because i am getting my archived log getting tranported location pointed by this parameter.
If Possible Plz see my post
http://www.orafaq.com/forum/t/94369/111918/

Report message to a moderator

Re: importance of standby_archive_dest in dataguard/Real time log application in Oracle9i [message #288763 is a reply to message #288704]

Tue, 18 December 2007 10:59

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Real time was 1st introduced in 10g.prior to 10g there was no such a option .But you can do it by using manual switch of log file.

Check other thread for answer.

Report message to a moderator

Re: importance of standby_archive_dest in dataguard/Real time log application in Oracle9i [message #289172 is a reply to message #288763]

Wed, 19 December 2007 23:36

pankajkmeena
Messages: 46
Registered: September 2007

Member

===ORACLE9i=======
Thankx
So it is not possible to do real time log transport
I tried to use value VALID_FOR but it is not working. However values like LGWR SYNC NET_TIMEOUT=30 are applicable to LOG_ARCHIVE_DEST_n parameter. Can u tell me when to use LGWR instead of ARC process for redo transport.

[Updated on: Wed, 19 December 2007 23:36]

Report message to a moderator

Re: importance of standby_archive_dest in dataguard/Real time log application in Oracle9i [message #289296 is a reply to message #289172]

Thu, 20 December 2007 10:39

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

So it is not possible to do real time log transport

Only one way after every transaction manually switch log file no other option..

There's no such a functionality in 9i which provide REAL TIME LOG apply services..

Report message to a moderator

Previous Topic:	Run an EXPORT against a standby database.
Next Topic:	problem in achive log destination -2 after switchover

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 21:49:34 CDT 2024