Home » Server Options » Data Guard » importance of standby_archive_dest in dataguard/Real time log application in Oracle9i
importance of standby_archive_dest in dataguard/Real time log application in Oracle9i [message #288704] Tue, 18 December 2007 06:53 Go to next message
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/
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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 Go to previous message
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..
Previous Topic: Run an EXPORT against a standby database.
Next Topic: problem in achive log destination -2 after switchover
Goto Forum:
  


Current Time: Sat Dec 03 16:07:07 CST 2016

Total time taken to generate the page: 0.24616 seconds