Home » Server Options » Data Guard » MR(fg) WAIT_FOR_LOG why ?
MR(fg) WAIT_FOR_LOG why ? [message #237816] Tue, 15 May 2007 15:17 Go to next message
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
Re: MR(fg) WAIT_FOR_LOG why ? [message #237818 is a reply to message #237816] Tue, 15 May 2007 15:23 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Not sure, but have u added any datafile recently?
Re: MR(fg) WAIT_FOR_LOG why ? [message #237834 is a reply to message #237818] Tue, 15 May 2007 22:51 Go to previous messageGo to next message
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.
Re: MR(fg) WAIT_FOR_LOG why ? [message #238051 is a reply to message #237816] Wed, 16 May 2007 08:19 Go to previous messageGo to next message
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
Senior Member

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."
Re: MR(fg) WAIT_FOR_LOG why ? [message #238120 is a reply to message #238051] Wed, 16 May 2007 14:30 Go to previous messageGo to next message
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;"


Re: MR(fg) WAIT_FOR_LOG why ? [message #238121 is a reply to message #238120] Wed, 16 May 2007 14:36 Go to previous messageGo to next message
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
Senior Member

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

>ALTER SYSTEM ARCHIVE LOG CURRENT;

Re: MR(fg) WAIT_FOR_LOG why ? [message #238123 is a reply to message #238121] Wed, 16 May 2007 14:40 Go to previous messageGo to next message
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
Re: MR(fg) WAIT_FOR_LOG why ? [message #238175 is a reply to message #238123] Thu, 17 May 2007 00:10 Go to previous messageGo to next message
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.
Re: MR(fg) WAIT_FOR_LOG why ? [message #238597 is a reply to message #238175] Fri, 18 May 2007 12:16 Go to previous messageGo to next message
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;
Re: MR(fg) WAIT_FOR_LOG why ? [message #238598 is a reply to message #238175] Fri, 18 May 2007 12:18 Go to previous messageGo to next message
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
Re: MR(fg) WAIT_FOR_LOG why ? [message #238670 is a reply to message #238598] Fri, 18 May 2007 23:17 Go to previous messageGo to next message
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. ?
Re: MR(fg) WAIT_FOR_LOG why ? [message #238725 is a reply to message #238670] Sat, 19 May 2007 13:46 Go to previous messageGo to next message
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??
Re: MR(fg) WAIT_FOR_LOG why ? [message #238800 is a reply to message #238725] Sun, 20 May 2007 01:50 Go to previous messageGo to next message
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.?
Re: MR(fg) WAIT_FOR_LOG why ? [message #238931 is a reply to message #238800] Mon, 21 May 2007 00:58 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
NO I CREATED IN 10GR2


CAN U PASTE UR INIT FILE SETTING??
Re: MR(fg) WAIT_FOR_LOG why ? [message #239049 is a reply to message #238931] Mon, 21 May 2007 06:09 Go to previous messageGo to next message
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

Re: MR(fg) WAIT_FOR_LOG why ? [message #239179 is a reply to message #239049] Mon, 21 May 2007 12:29 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I cant see db_unique_name parameter..and what is REAL...


Re: MR(fg) WAIT_FOR_LOG why ? [message #239565 is a reply to message #239179] Tue, 22 May 2007 12:22 Go to previous messageGo to next message
asadaslam18
Messages: 16
Registered: May 2007
Location: nine
Junior Member

REAL is my database name
Re: MR(fg) WAIT_FOR_LOG why ? [message #239577 is a reply to message #239565] Tue, 22 May 2007 12:45 Go to previous messageGo to next message
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 Go to previous messageGo to next message
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
Senior Member

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.
Re: MR(fg) WAIT_FOR_LOG why ? [message #239676 is a reply to message #239597] Wed, 23 May 2007 01:06 Go to previous messageGo to next message
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.
Re: MR(fg) WAIT_FOR_LOG why ? [message #239912 is a reply to message #239676] Wed, 23 May 2007 11:23 Go to previous messageGo to next message
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’
Re: MR(fg) WAIT_FOR_LOG why ? [message #239965 is a reply to message #239912] Wed, 23 May 2007 14:33 Go to previous message
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 1453 times)
Previous Topic: Multiple Listerners setup
Next Topic: problem with Next log sequence
Goto Forum:
  


Current Time: Wed Oct 22 19:05:38 CDT 2014

Total time taken to generate the page: 0.05593 seconds