Dataguard: MRP Process not applying

[Orako]

Windows 2003
Oracle 10g R2
Primary:tcjolts2
Standby: tcjolts3
Type: Physical Standby database

I am having problems configuring dataguard, the logs are shipping to my standby server but they are not being applied. This is the MRP error:

MRP0: Background Managed Standby Recovery process started
*** 2007-11-20 11:15:22.947 1011 krsm.c
Managed Recovery: Initialization posted.
*** 2007-11-20 11:15:22.947 60680 kcrr.c
Managed Standby Recovery not using Real Time Apply
*** 2007-11-20 11:15:23.182 60680 kcrr.c
MRP0: Background Media Recovery terminated with error 1110
ORA-01110: data file 2: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TCJOLTS2\UNDOTBS01.DBF'
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TCJOLTS2\UNDOTBS01.DBF'
ORA-01110: data file 2: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TCJOLTS2\UNDOTBS01.DBF'
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TCJOLTS2\UNDOTBS01.DBF'
*** 2007-11-20 11:15:23.260 60680 kcrr.c
MRP0: Background Media Recovery process shutdown
I thought the MRP process applies logs from the standby redo logs or the archived logs from the standby node. Why am I getting errors about accessing datafiles on the primary node (tctolts2)?

Here are my init file setup:


Primary init File setup:
tcjolts2.__db_cache_size=444596224
tcjolts2.__java_pool_size=4194304
tcjolts2.__large_pool_size=4194304
tcjolts2.__shared_pool_size=142606336
tcjolts2.__streams_pool_size=8388608
*.audit_file_dest='D:\oracle\product\10.2.0/admin/TCJOLTS2/adump'
*.background_dump_dest='D:\oracle\product\10.2.0/admin/TCJOLTS2/bdump'
*.compatible='10.2.0.1.0'
*.control_files='D:\oracle\product\10.2.0\oradata\TCJOLTS2\control01.ctl','D:\oracle\product\10.2.0\ oradata\TCJOLTS2\control02.ctl','D:\oracle\product\10.2.0\oradata\TCJOLTS2\control03.ctl'
*.core_dump_dest='D:\oracle\product\10.2.0/admin/TCJOLTS2/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert = 'd:\oracle\product\10.2.0\oradata\tcjolts3','d:\oracle\product\10.2.0\oradata\tcjolts2'
*.db_flashback_retention_target=2160
*.db_name='TCJOLTS2'
*.db_recovery_file_dest='D:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=32212254720
*.db_unique_name=atljolts2
*.dg_broker_start=TRUE
*.log_archive_config='dg_config=(atljolts2,atljolts3)'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TCJOLTS2XDB)'
*.fal_client=atljolts3_dg
*.fal_server=atljolts2_dg
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=D:\oracle\product\10.2.0\flash_recovery_area\TCJOLTS2 MANDATORY REOPEN=300 valid_for=(all_logfiles,all_roles) db_unique_name=atljolts2'
*.log_archive_dest_2='SERVICE=atljolts3_dg LGWR SYNC AFFIRM valid_for=(online_logfiles,primary_role) db_unique_name=atljolts3'
*.log_archive_dest_10='LOCATION=USE_DB_RECOVERY_FILE_DEST REOPEN=300'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_max_processes=30
*.log_archive_format='JOLTS%S_%R.%T'
*.log_file_name_convert = 'd:\oracle\product\10.2.0\oradata\tcjolts3','d:\oracle\product\10.2.0\oradata\tcjolts2'
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=612368384
*.standby_file_management=auto
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:\oracle\product\10.2.0/admin/TCJOLTS2/udump'


Standby File setup:
tcjolts3.__db_cache_size=444596224
tcjolts3.__java_pool_size=4194304
tcjolts3.__large_pool_size=4194304
tcjolts3.__shared_pool_size=142606336
tcjolts3.__streams_pool_size=8388608
*.audit_file_dest='D:\oracle\product\10.2.0/admin/tcjolts3/adump'
*.background_dump_dest='D:\oracle\product\10.2.0/admin/tcjolts3/bdump'
*.compatible='10.2.0.1.0'
*.control_files='D:\oracle\product\10.2.0\oradata\tcjolts3\JLTS_SBCNTL01.CTL','D:\oracle\product\10. 2.0\oradata\tcjolts3\JLTS_SBCNTL02.CTL','D:\oracle\product\10.2.0\oradata\tcjolts3\JLTS_SBCNTL03.CTL '
*.core_dump_dest='D:\oracle\product\10.2.0/admin/tcjolts3/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert = 'd:\oracle\product\10.2.0\oradata\tcjolts2','d:\oracle\product\10.2.0\oradata\tcjolts3'
*.db_flashback_retention_target=2160
*.db_name='tcjolts2'
*.db_recovery_file_dest='D:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=32212254720
*.db_unique_name=atljolts3
*.dg_broker_start=TRUE
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(atljolts2,atljolts3)'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=tcjolts3XDB)'
*.fal_client=atljolts2_dg
*.fal_server=atljolts3_dg
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=D:\oracle\product\10.2.0\flash_recovery_area\tcjolts3 MANDATORY REOPEN=300 valid_for=(all_logfiles,all_roles) db_unique_name=atljolts3'
*.log_archive_dest_2='SERVICE=atljolts2_dg LGWR SYNC AFFIRM valid_for=(online_logfiles,primary_role) db_unique_name=atljolts2'
*.log_archive_dest_10='LOCATION=USE_DB_RECOVERY_FILE_DEST REOPEN=300'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_max_processes=30
*.log_archive_format='JOLTS3_%s_%t_%r.arc'
*.log_file_name_convert = 'd:\oracle\product\10.2.0\oradata\tcjolts2','d:\oracle\product\10.2.0\oradata\tcjolts3'
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=612368384
*.standby_file_management=auto
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'

[walterflavio]

Hi Orako,

Did you try to execute the command "alter database recover managed standby database"

Use the ALTER DATABASE statement to enable the real-time apply.
I use the "alter database recover managed standby database" that it is starts a detached server process and immediately returns control to the user.