MRP进程报1111错误：Recovery Slave PR00 previously exited with exception 1111-CSDN博客

本文链接：https://blog.csdn.net/jisen_huang/article/details/105080427

本文详细记录了一次Oracle数据库Guard故障的排查过程，包括错误信息解析、db_file_name_convert参数调整、数据文件手动创建及DG状态恢复步骤，为遇到类似问题的DBA提供解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

查看dg报错

select dest_name,status,error from v$archive_dest;
FACILITY                 SEVERITY      ERROR_CODE TIMESTAMP MESSAGE
------------------------ ------------- ---------- --------- --------------------------------------------------------------------------------
Log Transport Services   Informational          0 24-MAR-20 ARC0: Archival started
Log Transport Services   Informational          0 24-MAR-20 ARC1: Archival started
Log Transport Services   Informational          0 24-MAR-20 ARC2: Archival started
Log Transport Services   Informational          0 24-MAR-20 ARC1: Becoming the 'no FAL' ARCH
Log Transport Services   Informational          0 24-MAR-20 ARC2: Becoming the heartbeat ARCH
Log Transport Services   Informational          0 24-MAR-20 ARC2: Becoming the active heartbeat ARCH
Log Apply Services       Informational          0 24-MAR-20 Managed Standby Recovery starting Real Time Apply
Log Transport Services   Informational          0 24-MAR-20 ARC3: Archival started
Log Apply Services       Control                0 24-MAR-20 Attempt to start background Managed Standby Recovery process
Log Apply Services       Control                0 24-MAR-20 MRP0: Background Managed Standby Recovery process started
Log Apply Services       Informational          0 24-MAR-20 Managed Standby Recovery starting Real Time Apply

FACILITY                 SEVERITY      ERROR_CODE TIMESTAMP MESSAGE
------------------------ ------------- ---------- --------- --------------------------------------------------------------------------------
Log Apply Services       Error               1111 24-MAR-20 MRP0: Background Media Recovery terminated with error 1111
Log Apply Services       Informational          0 24-MAR-20 Managed Standby Recovery not using Real Time Apply
Log Apply Services       Control                0 24-MAR-20 MRP0: Background Media 
Recovery process shutdown

强制开启还是会宕

SQL> recover managed standby database using current logfile disconnect from session;  
Media recovery complete.
SQL> select process,client_process,sequence#, THREAD# ，status from v$managed_standby;  

PROCESS   CLIENT_P  SEQUENCE#   ??STATUS
--------- -------- ---------- ----------
ARCH      ARCH          15894          2
ARCH      ARCH          14999          1
ARCH      ARCH              0          0
ARCH      ARCH          15000          1
RFS       UNKNOWN           0          0
RFS       UNKNOWN           0          0
RFS       UNKNOWN           0          0
RFS       UNKNOWN           0          0
RFS       UNKNOWN           0          0
RFS       LGWR          15001          1
RFS       LGWR          15895          2

PROCESS   CLIENT_P  SEQUENCE#   ??STATUS
--------- -------- ---------- ----------
RFS       UNKNOWN           0          0

12 rows selected.

alert日志报错


Managed Standby Recovery starting Real Time Apply
MRP0: Background Media Recovery terminated with error 1111
Errors in file /u01/app/oracle/diag/rdbms/hisdg2/hisdb/trace/hisdb_pr00_7650.trc:
ORA-01111: name for data file 50 is unknown - rename to correct file
ORA-01110: data file 50: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00050'
ORA-01157: cannot identify/lock data file 50 - see DBWR trace file
ORA-01111: name for data file 50 is unknown - rename to correct file
ORA-01110: data file 50: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00050'
Managed Standby Recovery not using Real Time Apply
Recovery Slave PR00 previously exited with exception 1111
MRP0: Background Media Recovery process shutdown (hisdb)

mrp0进程宕

SQL> select process,status,sequence# from v$managed_standby;

PROCESS   STATUS        SEQUENCE#
--------- ------------ ----------
ARCH      CONNECTED             0
ARCH      CONNECTED             0
ARCH      CONNECTED             0
ARCH      CLOSING           14997
RFS       IDLE                  0
RFS       IDLE                  0
RFS       WRITING           14999

解决办法：

设置db_file_name_convert，将原有的未加入的转换加入

alter system set db_file_name_convert='+DATA/hisdb3/','/oradata/hisdb/hisDB/datafile/','+DATA/hisdb/hgoa/','/oradata/hisdb/hisDB/datafile/hgoa/','+DATA/hisdb/hisdata/','/oradata/hisdb/hisDB/datafile/hisdata/','+DATA/hisdb/hisdatabi/','/oradata/hisdb/hisDB/datafile/hisdatabi/','+DATA/hisdb/hissms/','/oradata/hisdb/hisDB/datafile/hissms/' ,'+DATA/hisdb/datafile/','/oradata/hisdb/hisDB/datafile/' scope=spfile;

设备手动
ALTER SYSTEM SET standby_file_management='MANUAL' SCOPE=MEMORY;

将转换失败文件手工创建
SQL> alter database create datafile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00050' as '/oradata/hisdb/hisDB/datafile/undotbs2_03191.dbf';

Database altered.

SQL> alter database create datafile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00051' as '/oradata/hisdb/hisDB/datafile/undotbs2_031951.dbf';

Database altered.


设置DG成自动

SQL>  ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO scope=both;

System altered.
开启应用

SQL> alter database recover managed standby database using current logfile disconnect;

Database altered.
完成解决

SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#,BLOCK#,BLOCKS,PID FROM V$MANAGED_STANDBY;

PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS        PID
--------- ------------ ---------- ---------- ---------- ---------- ----------
ARCH      CLOSING               1      15002      67584       1668      23285
ARCH      CLOSING               1      15003          1        218      23287
ARCH      CONNECTED             0          0          0          0      23289
ARCH      CLOSING               2      15897          1        119      23291
RFS       IDLE                  0          0          0          0      23296
RFS       IDLE                  0          0          0          0      23298
RFS       IDLE                  0          0          0          0      23300
RFS       IDLE                  0          0          0          0      23302
RFS       WRITING               2      15898       8416          1      23304
RFS       IDLE                  0          0          0          0      23306
RFS       WRITING               1      15004       8254          5      23308

PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS        PID
--------- ------------ ---------- ---------- ---------- ---------- ----------
RFS       IDLE                  0          0          0          0      23311
MRP0      APPLYING_LOG          1      13792     381294     822544      23318

13 rows selected.