Home » RDBMS Server » Server Administration » MR Lock (oracle 10g)
MR Lock [message #483869] Thu, 25 November 2010 02:33 Go to next message
dbaoracleinin
Messages: 19
Registered: November 2010
Location: abc
Junior Member
Hello Guys

Just noticed MR(media recovery lock ) in our database,further check showd all datafiles had this lock since our database was shutdown abortly but was startup gracefully

Please let me know if this lock is harmful and what actions should be done to resolve this

thanks

Report message to a moderator

Re: MR Lock [message #483875 is a reply to message #483869] Thu, 25 November 2010 03:09 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
This is normal, it is to prevent someone from, recovering the files while they are open.

Report message to a moderator

Re: MR Lock [message #483886 is a reply to message #483875] Thu, 25 November 2010 04:58 Go to previous message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
"Media recovery locks are held for one of two reasons: to prevent anyone from bringing a tablespace online which is under recovery or to prevent someone from attempting recovery on an online tablespace. Thus they are always present in a database as a protection mechanism"

http://esemrick.blogspot.com/2006/03/media-recovery-locks.html

[Updated on: Thu, 25 November 2010 05:02]

Report message to a moderator

Previous Topic: Tablespace issue
Next Topic: broken link
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 08:41:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.