| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ora-1172 on personal oracle - crashed database.
The disk may be O.k but the files on it may not be.
The database tried to do instance recovery and it failed - therefore you need to go back to older datafiles and reapply changes made to them. This is generally only possible if you were running in ARCHIVELOG mode.
Was the datbase running in ARCHIVELOG mode (i.e. was it systematically copying online redo logs to another destination before overwriting them)?
The database default is NOARCHIVELOG mode so if you didn't change anything you won't have been running in ARCHIVELOG mode.
If you have a support contract with Oracle, start speaking to them.
If the data is absoultely critical, you may be able to persuade Oracle to send one of their specialists - this may be exceptionally expensive though. You need to judge whether it would be worth it.
If you were not running in ARCHIVELOG mode, you might not even be able to restore an older version of all your datafiles - generally the type of backup that should be done here is a 'full offline backup' - so the last backup that you did - what did you backup?. You should backup all datafiles, control files, online redo log files and the initialisation (parameter) file while the database is shutdown.
If you have the time, read the Oracle Documenation about Backup and Recovery - it should give you an idea pretty quickly what your options are. (P.S. 'Instance Recovery' is what Oracle has already tried to do here but it didn't work - you are now needing to perform 'Media Recovery')
Before you go trying any recovery or restoration operations, backup what you currently have as well (twice - to different locations). This is in case anything you do makes things worse.
Also, study the Documentation about an Oracle program called Server Manager - if you are going to try and do media recovery (at the suggestion of the documenation) then you may well need to use this program.
Time is your friend here - if you have it, you'll be able to study enough of the documenation to make the best decisions possible. Only you know the exact history and configuration of your database - armed with the right knowledge, you are also the best person to be able to fix the problem. Anyone can give generalised advice, but there's no guarantee that it will work because each databas installation and history is different.
Lastly - if you are short of any Oracle documenation - go to
There you can access lots of documentation, although you may have to create a Technet account (free) first).
David P. OCP (DBA) MCP (TCP/IP)
Glasgow, Scotland.
Yoav Itzcovitch wrote:
>
> Hi all,
>
> I was working on the database when suddenly I had a voltage breakdown, when
> the computer restarted and I tried opening the DB I got the ora-1172 without
> the required details such as: thread num, block num, and file name.
>
> ORA-01172 recovery of thread num stuck at block num of file name
>
> Cause: Crash recovery or instance recovery could not apply a change to a
> block because it was not the next change. This can happen if the block was
> corrupted and then repaired during recovery.
>
> Action: Perform a RECOVER datafile for the file containing the block. If
> this does not resolve the problem, then restore the file from a backup and
> recover it again.
>
> I tried using the Recovery Manager which asked me to start the database, a
> thing I can't do.
>
> I already check for physical problems on the disk and the disk is ok.
>
> I can restore from backup but I don't want to lose the data from the last
> backup...
>
> Thanks in advance.
>
> Yoav.
Received on Tue Jun 06 2000 - 00:00:00 CDT
 |
 |