DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, December 29, 2016

MRP0: Background Media Recovery terminated with error 448

MRP0: Background Media Recovery terminated with error 448

Recently encountered ORA-00448: normal completion of background process Managed Standby Recovery not using Real Time Apply due to ORA-00600 on standby Database. 

After executing "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT";.

Standby database starts throwing following error into the alert log when try to enable MRP.

Wed Dec 21 15:19:19 2016
Dumping diagnostic data in directory=[cdmp_20161221151919], requested by (instance=1, osid=22962 (PR2L)), summary=[incident=2760999].
Errors in file /u01/app/oracle/diag/rdbms/PROD_dgp/PROD/trace/PROD_mrp0_22684.trc  (incident=2760247):
ORA-00600: internal error code, arguments: [3020], [93], [327813], [390398085], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 93, block# 327813, file offset is 2685444096 bytes)
ORA-10564: tablespace PROD_DATA
ORA-01110: data file 93: '/u03/oradata/PROD/PROD_DATA_48.dbf'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 204854
Incident details in: /u01/app/oracle/diag/rdbms/PROD_dgp/PROD/incident/incdir_2760247/PROD_mrp0_22684_i2760247.trc
Wed Dec 21 15:19:19 2016
Archived Log entry 103378 added for thread 1 sequence 92576 ID 0x22d0a3c8 dest 1:
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Recovery Slave PR2L previously exited with exception 600
Wed Dec 21 15:19:21 2016
MRP0: Background Media Recovery terminated with error 448
Errors in file /u01/app/oracle/diag/rdbms/PROD_dgp/PROD/trace/PROD_pr00_22768.trc:
ORA-00448: normal completion of background process
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Wed Dec 21 15:19:21 2016
Sweep [inc][2760999]: completed
Sweep [inc][2760247]: completed
Sweep [inc2][2760999]: completed
Sweep [inc2][2760247]: completed
Dumping diagnostic data in directory=[cdmp_20161221151921], requested by (instance=1, osid=22684 (MRP0)), summary=[incident=2760247].
Recovered data files to a consistent state at change 593576225741
Wed Dec 21 15:19:23 2016
MRP0: Background Media Recovery process shutdown (PROD)


Steps to resolve this issue:

Primary Database::

alter database begin backup;

Take backup of data file 93: '/u03/oradata/PROD/PROD_DATA_48.dbf' 

alter database end backup;


Standby Database:

shutdown the database.

Physically drop the datafile
rm /u03/oradata/PROD/PROD_DATA_48.dbf

Copy the backup of datafile# 93 from Primary to Standby database server.


Mount the database.

Restart the managed recovery operations.
alter database recover managed standby database  using current logfile disconnect;

select process,status from v$managed_standby;


Check the alert log:
Media Recovery Log and real-time apply successful

Thank you !!

Happy Reading… 





No comments: