Changing Log Transport service
- From: "Alessandro Vercelli" <alever@xxxxxxxxx>
- To: "Oracle Freelists\.org" <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 1 Dec 2006 15:51:02 +0100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
