ORA-01172: recovery of thread 1 stuck at block 61437 of file 1

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01172: recovery of thread 1 stuck at block 61437 of file 1
ORA-01151: use media recovery to recover block, restore backup if needed


SQL> ORA-01172: recovery of thread 1 stuck at block 61437 of file 1
ORA-01151: use media recovery to recover block, restore backup if needed
SP2-0734: unknown command beginning "ORA-01172:..." - rest of line ignored.
SQL> SP2-0734: unknown command beginning "ORA-01151:..." - rest of line ignored.
SQL>
FrankluoAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
Error is pretty self-explanatory as is the solution:

http://ora-01172.ora-code.com/

From the sqlplus prompt try:
recover datafile 1;

If that fails, restore the datafile from a backup then try recovery.
0
 
schwertnerCommented:
Try

SQL> SELECT name FROM v$datafile WHERE file#=1;


SQL>RECOVER  <put the above file name here>

After recovery try to open the database.
0
 
FrankluoAuthor Commented:
SQL> recover datafile 1;
ORA-00283: recovery session canceled due to errors
ORA-12801: error signaled in parallel query server P006
ORA-10562: Error occurred while applying redo to data block (file# 1, block#
61341)
ORA-10564: tablespace SYSTEM
ORA-01110: data file 1: '/orap/u01/app/oracle/oradata/lawp/system01.dbf'
ORA-10561: block type 'TRANSACTION MANAG
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
sventhanCommented:
Now tell the story what you're trying to do.

" alter database open;"

Are you cloning a DB from backup, etc?
0
 
FrankluoAuthor Commented:
I got report this morning, I found the database was down, so I type startup open, then error come  out.
I have 3/11 rman full datbase backup (online), database is in archive mode.
0
 
slightwv (䄆 Netminder) Commented:
from http:#a37710307:  "If that fails, restore the datafile from a backup then try recovery."


If the RMAN backups are there, perform a database recovery.

From the RMAN prompt:

recover database;


If that fails try:
restore database;

then recover.
0
 
FrankluoAuthor Commented:
the  problem was happened on 1:00am 3/12, should I do an imcomplete recover? thanks.
0
 
slightwv (䄆 Netminder) Commented:
I would try a full recovery and only resort to a point-in-time recovery if forced.

If you are unfamiliar with recovery I would open an SR with Oracle Support to make sure things go the way they should.
0
 
FrankluoAuthor Commented:
Before I do that, I'd like to show you the alert.log file.
Mon Mar 12 01:18:55 2012
Read from controlfile member '/orap/u01/app/oracle/oradata/lawp/control01.ctl' has found a fractured block (blk# 15, seq# 309742)
Mon Mar 12 01:18:55 2012
Errors in file /orap/u01/app/oracle/admin/lawp/bdump/lawp_arc1_872620.trc:
ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [309753], [309742], [0x000000000], [], [], [], []
Mon Mar 12 01:19:45 2012
Errors in file /orap/u01/app/oracle/admin/lawp/bdump/lawp_arc1_872620.trc:
ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [309753], [309742], [0x000000000], [], [], [], []
Mon Mar 12 01:19:45 2012
Errors in file /orap/u01/app/oracle/admin/lawp/bdump/lawp_arc1_872620.trc:
ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [309753], [309742], [0x000000000], [], [], [], []
Mon Mar 12 01:19:45 2012
Errors in file /orap/u01/app/oracle/admin/lawp/bdump/lawp_arc1_872620.trc:
ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [309753], [309742], [0x000000000], [], [], [], []
Mon Mar 12 01:19:45 2012
Errors in file /orap/u01/app/oracle/admin/lawp/bdump/lawp_arc1_872620.trc:
ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [309753], [309742], [0x000000000], [], [], [], []
0
 
slightwv (䄆 Netminder) Commented:
Looks like you had a pretty severe disk issue happen.

I strongly encourage you to work directly with Oracle Support.

That said:
Take a backup (cold from OS) of what you have right now so you can at least get back to this point.

Then I would try a complete RMAN recovery as long as you are sure your backups are good.
0
 
FrankluoAuthor Commented:
problem fixed! thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.