Home » RDBMS Server » Server Administration » Archiving redo log on standby (Oracle 12.2.0.1.0 )
Archiving redo log on standby [message #672492] Tue, 16 October 2018 09:25 Go to next message
Mdumala
Messages: 2
Registered: October 2018
Junior Member
Hello Guys

I have question about archiving logs in standby database.

My current config is

Primary database (SID = prod)
Standby database (SID = prodstb)


Primary have params like :

log_archive_dest_1		     string	 LOCATION=use_db_recovery_file_
						 dest VALID_FOR=(ALL_LOGFILES,A
						 LL_ROLES) DB_UNIQUE_NAME=prod

log_archive_dest_2		     string	 service="prodstb", ASYNC NOAFF
						 IRM delay=0 optional compressi
						 on=disable max_failure=0 max_c
						 onnections=1 reopen=300 db_uni
						 que_name="prodstb" net_timeout
						 =30, valid_for=(online_logfile
						 ,all_roles)

And standby : 

log_archive_dest_1		     string	 LOCATION=use_db_recovery_file_
						 dest VALID_FOR=(ALL_LOGFILES,A
						 LL_ROLES) DB_UNIQUE_NAME=prods
						 tb


Everything works fine with transport and applying but when i look in v$archived log on standby database i see things like :


1	ARCH	13
2	LGWR	14
1	ARCH	15
1	ARCH	16
1	ARCH	17
1	ARCH	18
1	ARCH	19
1	ARCH	20
1	ARCH	21
2	LGWR	22
1	ARCH	23
2	LGWR	24
1	ARCH	25
1	ARCH	26
2	LGWR	27
1	ARCH	28
2	LGWR	29
1	ARCH	30
2	LGWR	31
1	ARCH	32
2	LGWR	33
1	ARCH	34
2       LGWR	35
1	ARCH	36
2	ARCH	37
1	ARCH	38
1	ARCH	39
1	ARCH	40

The question is why the heck i'm seeing LWGR as process which creating my archive logs?

Regards
Re: Archiving redo log on standby [message #672493 is a reply to message #672492] Tue, 16 October 2018 09:30 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Mdumala wrote on Tue, 16 October 2018 07:25


Everything works fine with transport and applying but when i look in v$archived log on standby database i see things like :


1	ARCH	13
2	LGWR	14
1	ARCH	15
1	ARCH	16
1	ARCH	17
1	ARCH	18
1	ARCH	19
1	ARCH	20
1	ARCH	21
2	LGWR	22
1	ARCH	23
2	LGWR	24
1	ARCH	25
1	ARCH	26
2	LGWR	27
1	ARCH	28
2	LGWR	29
1	ARCH	30
2	LGWR	31
1	ARCH	32
2	LGWR	33
1	ARCH	34
2       LGWR	35
1	ARCH	36
2	ARCH	37
1	ARCH	38
1	ARCH	39
1	ARCH	40

The question is why the heck i'm seeing LWGR as process which creating my archive logs?

Regards
What SQL produces results above?

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read


Re: Archiving redo log on standby [message #672494 is a reply to message #672493] Tue, 16 October 2018 09:35 Go to previous messageGo to next message
Mdumala
Messages: 2
Registered: October 2018
Junior Member
select dest_id,creator,sequence# from v$archived_log
order by sequence# asc;

And another question how its possible that it shows dest_id = 2.
When i dont have that parameter on standby database.

[Updated on: Tue, 16 October 2018 09:53]

Report message to a moderator

Re: Archiving redo log on standby [message #672495 is a reply to message #672492] Tue, 16 October 2018 10:20 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Your log_archive_dest_n parameters are not set correctly. For example, if you do a switch over it will stop working. Your best option would be to set log_archive_dest_2 to null in your primary and then to enable the Data Guard Broker, which will set all the relevant parameters correctly.

[Updated on: Tue, 16 October 2018 11:04]

Report message to a moderator

Re: Archiving redo log on standby [message #672502 is a reply to message #672495] Tue, 16 October 2018 15:27 Go to previous message
JPBoileau
Messages: 88
Registered: September 2017
Member
Your environment is not set currently. This is what I get in my case, for one Primary + 2 Standby's:

DEST_ID	CREATOR	SEQUENCE#
1	ARCH	31900
2	LGWR	31900
3	LGWR	31900
1	ARCH	31899
2	LGWR	31899
3	LGWR	31899

1 gets archived locally on the Prod server, the 2 other are being written to by Log Writer to the standby DB's.

JP

[Updated on: Tue, 16 October 2018 15:27]

Report message to a moderator

Previous Topic: installtion problem pl/sql v11g xe
Next Topic: Is there any benefits of using one PDB?
Goto Forum:
  


Current Time: Thu Mar 28 17:28:44 CDT 2024