Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What does "Media Recovery" lock (MR) means?

ADanielJun 8 2012 — edited Jun 9 2012

Hi,

I have a lot of "Media Recovery" locks in dba_locks view, held by db writer background process. Currently I have no active RMAN backup and as far as I know there was no crush on the database that would require media recovery.

select count(*) from v$lock where type='MR';
392 rows;

I checked the active sessions, locks, etc, and everything looks "normal" with the database.

What is the Media Recovery lock held by DBWR?

Thanks
Daniel

This post has been answered by Aman.... on Jun 8 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 7 2012

Added on Jun 8 2012

#general-database-discussions

7 comments

3,569 views