Recover from ORA-01172 & ORA-01151
This morning I was working on an Oracle Management Repository (OMR) for a test Enterprise Manager that is used by a few consultants I work with. When I logged into the box, I found that the OMR was down. When I went to start the database, I was greeted with ORA-01172 and ORA-01151.
These errors basically say:
ORA-01172 – recovery of thread % stuck at block % of file %
ORA-01151 – use media recovery to recover block, restore backup if needed
So how do I recover from this. The solution is simple, I just needed to perform the following steps:
1. Shutdown the database
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
2. Mount the database
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1.0033E+10 bytes
Fixed Size 2934696 bytes
Variable Size 1677723736 bytes
Database Buffers 8321499136 bytes
Redo Buffers 30617600 bytes
Database mounted.
3. Recover the database
SQL> recover database;
Media recovery complete.
4. Open the database with “alter database”
SQL> alter database open;
Database altered.
At this point, you should be able to access the database (OMR) and then have the EM environment up and running.
Enjoy!
about.me:http://about.me/dbasolved
Current Oracle Certs

Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.

Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?
Inhibition of these enzymes may result in increased plasma levels of certain drugs, including cyclosporine and tacrolimus 7 priligy and viagra combination Im up 15 lbs in 2 days and havent really eaten that much tbh, and didnt use any Diuretics
0129 In parallel, similar experiments in non cancerous Normal Human and Fetal Fibroblasts showed that DRE selectively targets human pancreatic cancer cells, confirming results from previous studies can you buy priligy
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
I am not positive the place you are getting your information, however good topic. I must spend some time studying more or working out more. Thanks for great information I was searching for this information for my mission.
sex nhật hiếp dâm trẻ em ấu dâm buôn bán vũ khí ma túy bán súng sextoy chơi đĩ sex bạo lực sex học đường tội phạm tình dục chơi les đĩ đực người mẫu bán dâm
You made various nice points there. I did a search on the issue and found nearly all people will consent with your blog.