- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Very bad ORACLE recovery scenario .....
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2002 08:18 AM
тАО01-24-2002 08:18 AM
Re: Very bad ORACLE recovery scenario .....
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2002 08:30 AM
тАО01-24-2002 08:30 AM
Re: Very bad ORACLE recovery scenario .....
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2002 08:44 AM
тАО01-24-2002 08:44 AM
Re: Very bad ORACLE recovery scenario .....
Very good work, Volker.. Congrats..
And good luck again,
[N/A] Please.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2002 08:47 AM
тАО01-24-2002 08:47 AM
Re: Very bad ORACLE recovery scenario .....
Would you mind detaling what exact steps you took to do your recovery?
I wouldn't mind having in my oh-#$%# file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2002 09:13 AM
тАО01-24-2002 09:13 AM
Re: Very bad ORACLE recovery scenario .....
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2002 01:15 PM
тАО01-24-2002 01:15 PM
Re: Very bad ORACLE recovery scenario .....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-25-2002 04:56 AM
тАО01-25-2002 04:56 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2002 01:06 AM
тАО01-30-2002 01:06 AM
Re: Very bad ORACLE recovery scenario .....
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
- « Previous
-
- 1
- 2
- Next »