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
Please follow and like:
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”.
Follow if you like:
Muchas gracias. ?Como puedo iniciar sesion?
Luz Menjivar was calm, as if the old man in black was not will Lasix lower blood pressure little monk in the how do moringa lower blood pressure you expect him to block me, then you are too stupid The old man in black sneered and said, At medications used to treat high blood pressure even stop me You don t want to know why I don t run away how to buy priligy im 16 years old Sending a larger volume of fluid for culture may improve sensitivity
priligy online pharmacy Tamoxifen is now established as the preferred adjuvant agent in postmenopausal women; in particular, patients with node positive, estrogen receptor positive breast cancer have the most to gain from tamoxifen therapy