OraFAQ Forum: Data Guard » MR(fg) WAIT_FOR_LOG why ?

Home » Server Options » Data Guard » MR(fg) WAIT_FOR_LOG why ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

MR(fg) WAIT_FOR_LOG why ? [message #237816]

Tue, 15 May 2007 15:17

asadaslam18
Messages: 16
Registered: May 2007
Location: nine

Junior Member

I am trying to create a 9ir2 Data Guard Physical Standby database with Real-Time apply, when i check the view v$archived_log
SQL> select applied,archived from v$archived_log;

APP ARC
--- ---
YES YES
YES YES
YES YES
YES YES
YES YES
YES YES
YES YES
YES YES
YES YES
YES YES
YES YES

APP ARC
--- ---
YES YES
YES YES
YES YES
YES YES
YES YES
YES YES

17 rows selected.

All the archived logs applying sucessfully but why MP(fg) is showing the state WAIT_FOR_LOG.

PROCESS STATUS SEQUENCE# BLOCK# BLOCKS DELAY_MINS
------- ------------ ---------- ---------- ---------- ----------
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 19 0 0 0
MR(fg) WAIT_FOR_LOG 21 0 0 0
RFS WRITING 21 1599 204800 0
RFS RECEIVING 19 754 754 0
RFS ATTACHED 20 258 258 0

Thanks
Asad

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #237818 is a reply to message #237816]

Tue, 15 May 2007 15:23

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

Not sure, but have u added any datafile recently?

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #237834 is a reply to message #237818]

Tue, 15 May 2007 22:51

asadaslam18
Messages: 16
Registered: May 2007
Location: nine

Junior Member

No i dint i just want to start managed recovery process MRP.

In 10g i started MRP using

Alter database recover managed standby database using current logfile;

Now i want to start the MRP process in 9i so that it can apply the LGWR streams to the standby logfiles.

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #238051 is a reply to message #237816]

Wed, 16 May 2007 08:19

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

michael.goins@hp.com

Do you have Standby Redo Logs configured?

From: http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96653/log_transport.htm#1038486

"During testing, the easiest way to determine if the current standby log configuration is satisfactory is to examine the contents of the RFS process trace file and the database alert log. If messages indicate that the RFS process frequently has to wait for a group because archiving did not complete, add more standby log groups."

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #238120 is a reply to message #238051]

Wed, 16 May 2007 14:30

asadaslam18
Messages: 16
Registered: May 2007
Location: nine

Junior Member

Yes i have standby redo logs properly configured....

I just want to know is their any statement like this in 9i to start reocvery process the below statement i mentioned is for 10g.
"Alter database recover managed standby database using current logfile;"

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #238121 is a reply to message #238120]

Wed, 16 May 2007 14:36

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

michael.goins@hp.com

This command that archives the current online redo log is the best I have, sorry:

>ALTER SYSTEM ARCHIVE LOG CURRENT;

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #238123 is a reply to message #238121]

Wed, 16 May 2007 14:40

asadaslam18
Messages: 16
Registered: May 2007
Location: nine

Junior Member

My question is why is MRP status is Waiting_for_log

PROCESS STATUS SEQUENCE# BLOCK# BLOCKS DELAY_MINS
------- ------------ ---------- ---------- ---------- ----------
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 19 0 0 0
MR(fg) WAIT_FOR_LOG 21 0 0 0
RFS WRITING 21 1599 204800 0
RFS RECEIVING 19 754 754 0
RFS ATTACHED 20 258 258 0

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #238175 is a reply to message #238123]

Thu, 17 May 2007 00:10

asadaslam18
Messages: 16
Registered: May 2007
Location: nine

Junior Member

Is there a way we can create a 9ir2 Data Guard Physical Standby database with Real-Time apply using SQL. Kindly provide a link if there is any.

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #238597 is a reply to message #238175]

Fri, 18 May 2007 12:16

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Hi
I just configured it yesterday itsworking awesome.

Make Sure these changes on Primary pfile

Set up log_archive_dest_2 on the primary with LGWR ASYNC

And 2nd

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #238598 is a reply to message #238175]

Fri, 18 May 2007 12:18

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

asadaslam18 wrote on Wed, 16 May 2007 23:10

Is there a way we can create a 9ir2 Data Guard Physical Standby database with Real-Time apply using SQL. Kindly provide a link if there is any.

Here is the attached file ,from which i configured real time DG

Attachment: Realtime DG.doc
(Size: 38.00KB, Downloaded 2372 times)

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #238670 is a reply to message #238598]

Fri, 18 May 2007 23:17

asadaslam18
Messages: 16
Registered: May 2007
Location: nine

Junior Member

Thanx for the document , i am using oracle 9i to create real time apply.

the statement:

Alter database recover managed standby database using current logfile;

wont work in 9i so which statement should we use. ?

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #238725 is a reply to message #238670]

Sat, 19 May 2007 13:46

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

DID U CHECK DIS PARAMETER
log_archive_dest_2 on the primary with LGWR ASYNC
IS DAT SET IN YA PFILE??

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #238800 is a reply to message #238725]

Sun, 20 May 2007 01:50

asadaslam18
Messages: 16
Registered: May 2007
Location: nine

Junior Member

ya i have checked log_archive_dest_2 on the primary with LGWR ASYNC .

Have u created real time redo in oracle 9i.?

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #238931 is a reply to message #238800]

Mon, 21 May 2007 00:58

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

NO I CREATED IN 10GR2

CAN U PASTE UR INIT FILE SETTING??

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #239049 is a reply to message #238931]

Mon, 21 May 2007 06:09

asadaslam18
Messages: 16
Registered: May 2007
Location: nine

Junior Member

==========================
Primary init.ora file
==========================

aq_tm_processes=1
background_dump_dest='C:\oracle\admin\REAL\bdump'
compatible='9.2.0.0.0'
control_files='C:\oracle\oradata\REAL\CONTROL01.CTL','C:\oracle\oradata\REAL\CONTROL02.CTL','C:\oracle\oradata\REAL\CONTROL03.CTL'
core_dump_dest='C:\oracle\admin\REAL\cdump'
db_block_size=8192
db_cache_size=25165824
db_domain=''
db_file_multiblock_read_count=16
db_name='REAL'
dispatchers='(PROTOCOL=TCP) (SERVICE=REALXDB)'
fast_start_mttr_target=300
hash_join_enabled=TRUE
instance_name='REAL'
java_pool_size=33554432
job_queue_processes=10
large_pool_size=8388608
log_archive_dest_1='LOCATION=C:\oracle\archive'
log_archive_start=TRUE
open_cursors=300
pga_aggregate_target=25165824
processes=150
query_rewrite_enabled='FALSE'
remote_login_passwordfile='EXCLUSIVE'
shared_pool_size=50331648
sort_area_size=524288
star_transformation_enabled='FALSE'
timed_statistics=TRUE
undo_management='AUTO'
undo_retention=10800
undo_tablespace='UNDOTBS1'
user_dump_dest='C:\oracle\admin\REAL\udump'
log_archive_dest_2='SERVICE=standby LGWR ASYNC'
log_archive_dest_state_1='enable'
log_archive_dest_state_2='enable'
FAL_CLIENT=REAL
FAL_SERVER=REAL
standby_archive_dest='C:\oracle\archive'
standby_file_management=AUTO
remote_archive_enable=TRUE
log_archive_format=log%d_%t_%s.arc

==================================
Standby init.ora file
=================================

aq_tm_processes=1
background_dump_dest='C:\oracle\admin\REAL\bdump'
compatible='9.2.0.0.0'
control_files='C:\oracle\oradata\REAL\standby.CTL'
core_dump_dest='C:\oracle\admin\REAL\cdump'
db_block_size=8192
db_cache_size=25165824
db_domain=''
db_file_multiblock_read_count=16
db_name='REAL'
dispatchers='(PROTOCOL=TCP) (SERVICE=REALXDB)'
fast_start_mttr_target=300
hash_join_enabled=TRUE
instance_name='REAL'
java_pool_size=33554432
job_queue_processes=10
large_pool_size=8388608
log_archive_dest_1='LOCATION=C:\oracle\archive'
log_archive_start=TRUE
open_cursors=300
pga_aggregate_target=25165824
processes=150
query_rewrite_enabled='FALSE'
remote_login_passwordfile='EXCLUSIVE'
shared_pool_size=50331648
sort_area_size=524288
star_transformation_enabled='FALSE'
timed_statistics=TRUE
undo_management='AUTO'
undo_retention=10800
undo_tablespace='UNDOTBS1'
user_dump_dest='C:\oracle\admin\REAL\udump'
db_file_name_convert=('C:\oracle\oradata\REAL','C:\oracle\oradata\REAL')
log_file_name_convert=('C:\oracle\oradata\REAL','C:\oracle\oradata\REAL')
log_archive_format=log%d_%t_%s.arc
standby_archive_dest=('C:\oracle\archive')
standby_file_management=AUTO
remote_archive_enable=TRUE
FAL_SERVER=REAL
FAL_CLIENT=REAL

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #239179 is a reply to message #239049]

Mon, 21 May 2007 12:29

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

I cant see db_unique_name parameter..and what is REAL...

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #239565 is a reply to message #239179]

Tue, 22 May 2007 12:22

asadaslam18
Messages: 16
Registered: May 2007
Location: nine

Junior Member

REAL is my database name

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #239577 is a reply to message #239565]

Tue, 22 May 2007 12:45

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

and what is your db_unique_name

show parameter db_unique_name

i suggest you to change primary db_unique_name to real1 and standby to real2 and then check.

[Updated on: Tue, 22 May 2007 12:46]

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #239597 is a reply to message #237816]

Tue, 22 May 2007 13:22

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

michael.goins@hp.com

I didn't see anything in the documentation about db_unique_name until reviewing section 3.1.4 in the online documentation. There are a couple of other "seldom seen" parameters there, too, like "LOG_ARCHIVE_CONFIG". You won't see this in the PFILE.

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #239676 is a reply to message #239597]

Wed, 23 May 2007 01:06

asadaslam18
Messages: 16
Registered: May 2007
Location: nine

Junior Member

i dont think so their is an issue of db_unique_name or log_archive_config . The same steps i performed on 10g its working fine, for starting MRP0 process i use this statement in 10g database,

alter database recover managed standby database using current logfile;

when i am trying to issue the same statement on 9i its not working and giving error. Is there any statement like this in 9i so that we can start MRP0 process.
Earlier response will highly appreciated.

Thanks to all.

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #239912 is a reply to message #239676]

Wed, 23 May 2007 11:23

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

db_unique_name=’PRIMARY’
FAL_Client=’to_primary’
FAL_Server=’to_standby’
Log_archive_config=’DG_CONFIG=(primary,standby)’
Log_archive_dest_1=’Location=c:\oracle\backup
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
db_unique_name=primary’
Log_archive_dest_2=’Service=to_standby
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
db_unique_name=standby’
Log_archive_dest_state_1=ENABLE
Log_archive_dest_state_2=DEFER
Service_names=’primary’
Standby_File_Management=’AUTO’

Report message to a moderator

Re: MR(fg) WAIT_FOR_LOG why ? [message #239965 is a reply to message #239912]

Wed, 23 May 2007 14:33

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Real time is not applicable According to this document..

Attachment: dg_pres1.ppt
(Size: 669.00KB, Downloaded 3321 times)

Report message to a moderator

Previous Topic:	Multiple Listerners setup
Next Topic:	problem with Next log sequence

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 07 02:23:19 CST 2024