Operating System - HP-UX
1748195 Members
2736 Online
108759 Solutions
New Discussion юеВ

Re: Very bad ORACLE recovery scenario .....

 
Carlos Fernandez Riera
Honored Contributor

Re: Very bad ORACLE recovery scenario .....

Well ... you will say i am mad...

Once upon a time my DBA changed something inside a datafile ( i supose SCN) using a hex editor on the header of a datafile ( maybe adb should be used).

If you are pretty sure that database is not enough corrupted yo you this would be a way...

I can tell any more....

Best of lucks.
unsupported
Volker Borowski
Honored Contributor

Re: Very bad ORACLE recovery scenario .....

Hi Carlos,

hopefully I will never be that desperate in any case :-)

Update: Recovery ist finished !

Oracle claimed two aspects:
- database needed to be "open resetlogs"
- datafile "..the one missing...." will be lost because offline
No suprise so far.

Since very recent, we got the information, that there might be a chance that we need to recover until 12:00, we did not open the database yet, but take an additional filesystem backup now.

Open Resetlogs tomorrow !

Volker
Carlos Fernandez Riera
Honored Contributor

Re: Very bad ORACLE recovery scenario .....

The only good thing of this type of work is all the knowledge you get.

Very good work, Volker.. Congrats..

And good luck again,


[N/A] Please.
unsupported
Krishna Prasad
Trusted Contributor

Re: Very bad ORACLE recovery scenario .....

If you are only missing a index you should be able to recreate it later.

Would you mind detaling what exact steps you took to do your recovery?

I wouldn't mind having in my oh-#$%# file.
Positive Results requires Positive Thinking
Volker Borowski
Honored Contributor

Re: Very bad ORACLE recovery scenario .....

Of course friends,

when I am through this, I'll do a detailed documentation of this job, be sure :-)

I am not so sure, if all Oracle-guys will be able to use this, because some steps might sound Omniback or SAP specific (I'll do my best to translate these steps to Oracle-language :-).

So long
Volker
Krishna Prasad
Trusted Contributor

Re: Very bad ORACLE recovery scenario .....

Great, my environment is SAP/Oracle
Positive Results requires Positive Thinking
Volker Borowski
Honored Contributor

Re: Very bad ORACLE recovery scenario .....


I am going to have a big scotch tonight :-)

- Recovery OK
- OPEN RESETLOGS did work after drop of missing file
- Required data was accessible
( 500K compressed export *smile* )
- Rebuild of index tablespace is on the way

I guess I am a very happy fellow today :-)
I hope I can do a documentation next week.

Have a nice weekend everyone
Volker
Volker Borowski
Honored Contributor

Re: Very bad ORACLE recovery scenario .....

Hi friends,

this is the final message, closing this thread.
As an attachment, I put a short documentation, of what was done to recover this situation.

In addition to the header of the document, I have to repeat here, that the SQL-statements of that document are specific to the recovery-situation. Executing these statements against a database may lead to inconsistencies or loss of data if not used in the proper context.
Of course I take no warranty for anything in this document.

If anyone is in a similar situation, I am available for consulting :-)
Volker