DBA Hub

📋Steps in this guide1/3

MRP0: Background Media Recovery Terminated With Error 1274

Media Recovery Log /data/app/prod/arch/1_68815_799031040.arch

oracle configurationintermediate
by OracleDba
12 views
1

Overview

Media Recovery Log /data/app/prod/arch/1_68815_799031040.arch File #382 added to control file as ‘UNNAMED00382’ because the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL The file should be manually created to continue. Errors with log /data/app/prod/arch/1_68815_799031040.arch MRP0: Background Media Recovery terminated with error 1274
2

Section 2

Errors in file /apps/oracle/admin/prod/diag/rdbms/prodstby/prod/trace/prod_pr00_19983.trc: [STANDBY]Find the unnamed file in standby. As per the alert log, the problem is with FILE#382

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
SQL> show parameter standby

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest string ?/dbs/arch
standby_file_management string MANUAL

SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Database altered.

SQL> select file#,name from v$datafile where name like '%UNNAMED%';

FILE#
----------
NAME
--------------------------------------------------------------------------------
382
/apps/oracle/product/11.2.0.2.2013Q4/dbs/UNNAMED00382
3

Section 3

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
SQL> select name from v$datafile where file#382;
NAME
--------------------------------------------------------------------------------
/uv1019/u340/app/prod/oradata/prodmsc20.tbl

SQL> alter database create datafile '/apps/oracle/product/11.2.0.2.2013Q4/dbs/UNNAMED00382'
as '/uv1019/u340/app/prod/oradata/prodmsc20.tbl';

Database altered.

SQL>alter database set standby_file_management = 'auto'; scope=spfile;

SQL> shutdown immediate;

SQL> startup mount

SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> select PROCESS,CLIENT_PROCESS,THREAD#,SEQUENCE#,BLOCK# from v$managed_standby where process = 'MRP0' or client_process='LGWR';

PROCESS CLIENT_P THREAD# SEQUENCE# BLOCK#
--------- -------- ---------- ---------- ----------
RFS LGWR 1 69136 610754
MRP0 N/A 1 68815 693166

Comments (0)

Please to add comments

No comments yet. Be the first to comment!