Dataguard: MRP Process not applying
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Dataguard: MRP Process not applying

Threaded View

  1. #1
    Join Date
    Jan 2005
    Posts
    10

    Dataguard: MRP Process not applying

    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'
    Last edited by Orako; 11-20-2007 at 03:11 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width