RE: question on standby (LGWR, ASYNC)

Hi Yerong,
What version are you on? What are your ARCHIVE_LOG_DEST_n settings? Any clues in alertSID.log or SID_lns.*trc files in your bdump directory?

You can create a fresh lns process by changing your ARCHIVE_LOG_DEST_n for the standby with the ALTER SYSTEM command, (e.g. switch from LGWR to ARCH), perform a log switch, revert to the old ARCHIVE_LOG_DEST_n settings and perform another logswitch.

Hope this helps,

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Tue, 2004-09-21 at 01:27, Yerong He wrote:

> Hi,
> Not exactly related to the original post, Is there a way to just reset
> the LNS process? sometimes , it looks to me the LNS hang, the log can't
> transfer to the physical, "alter system switch logfile" didn't work.
> After bounce the primary database, everything became OK. so I wonder is
> there a way to just reset the LNS process ? or even reset the LNS would
> n't help in my case ?
>
> Thanks/Yerong
>
>
>
>
> This email and any files transmitted with it are intended for the named recipient only. The information contained in this message may be confidential, legally privileged or commercially sensitive. If you are not the intended recipient you must not reproduce or distribute any part of the email, disclose its contents to any other party, or take any action in reliance on it. If you have received this email in error, please contact the sender immediately by return email and delete this message from your computer.
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l