primary configured with max performance (all defaults), yet creator still shows LGWR
- From: fmhabash <fmhabash@xxxxxxxxx>
- To: Oracle L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 15 Jun 2011 10:05:11 -0400
Hi all,
Using RDBMS 11.2, I configured my primary remote destination as follows ...
log_archive_dest_2 SERVICE=BostonStby DB_UNIQUE_NAME=BostonStby
If the process is not specified, it defaults to ARCH.
However, when I examine primary v$archived_log I see
creator/registerar=LGWR not ARCH.
What is it showing LGWR instead of ARCH?
THREAD# SEQUENCE# CREATOR REGISTR
---------- ---------- ------- -------
2 12181 LGWR LGWR
1 20061 LGWR LGWR
1 20062 LGWR LGWR
2 12182 LGWR LGWR
1 20063 LGWR LGWR
1 20064 LGWR LGWR
2 12183 LGWR LGWR
1 20065 LGWR LGWR
2 12184 LGWR LGWR
1 20066 LGWR LGWR
1 20067 LGWR LGWR
Also, v$managed_standby shows client_process (last row)
PROCESS STATUS THREAD# SEQUENCE# STATUS DELAY_MINS CLIENT_P
--------- ------------ ---------- ---------- ------------ ----------
--------
ARCH CONNECTED 0 0 CONNECTED 0 ARCH
ARCH CONNECTED 0 0 CONNECTED 0 ARCH
ARCH CONNECTED 0 0 CONNECTED 0 ARCH
ARCH CONNECTED 0 0 CONNECTED 0 ARCH
RFS IDLE 0 0 IDLE 0 UNKNOWN
RFS IDLE 0 0 IDLE 0 UNKNOWN
RFS IDLE 2 12214 IDLE 0 LGWR
--
//www.freelists.org/webpage/oracle-l
Other related posts:
