Changing Log Transport service

From: Alessandro Vercelli <alever_at_libero.it>
Date: Fri, 1 Dec 2006 15:51:02 +0100
Message-Id: <J9LNX2$4786C23725E1A63ED7B51B47E3075101@libero.it>

Hi everybody,
in have a physical standby DG configuration with 2 nodes:
- Oracle sever 10.1.0.5 on RHEL ES 3

• reserved internal LAN for Log Transport with dedicated listener
• ARCn is used for redo data archiving, maximum performance mode

In order to enable SRLs, I would like to change ARCn to LGWR for redo data archiving, with the following steps:

• stop recover process on standby (shutdown and mount ?)
• create the standby logfiles on standby
• LOG_ARCHIVE_DEST_STATE_2=DEFER on primary
• modify LOG_ARCHIVE_DEST_2 on primary (on stanndby too for primary role)
• create the standby logfiles on primary
• start recover process on standby (alter database recover managed...)
• LOG_ARCHIVE_DEST_STATE_2=ENABLE

Am I missing something, or hints/caveats to pay attention?

Thanks for your help,

Alessandro

---

Passa a Infostrada. ADSL e Telefono senza limiti e senza canone Telecom http://click.libero.it/infostrada01dic06

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

Received on Fri Dec 01 2006 - 08:51:02 CST