Does anyone have any experience or recommendations for recovering data from an Oracle database that was running in NOARCHIVE mode while it was backed up?
Oracle's standard support service is unable to help me. Which is understandable since this is something they are quite clear about not supporting. They tried, but just can't do anything for me. They have said that there is an expensive option. They do offer a data recovery service through their consulting. Does anyone have any experience with that?
Does anyone know of other companies that provide that type of service?
ActionFront appears to be one. Has anyone here dealt with them?
http://www.actionfront.com/os_sql.asp
Here's the long story:
I knew what I was doing when I set this database up. (Honest, I really did) We setup this database to store a recent copy of production data to be queried for reporting. Based on that assumption, all of the data was reproducible, and based on that assumption we didn't need backups. If we ever had a system crash, we could always just build a new database and copy the production data over and we were up and running again. Great plan. Oh, if only it were that simple.
So I went about setting up the database and ran it in NOARCHIVE mode. For those of you that don't know, running an Oracle database in NOARCHIVE mode means you can't back the database up while it is running. However, it uses less diskspace. Which is great, when your management refuses to buy disk space. Especially when they find out you can do things like this. Which just means more work for the DBA when it comes to restoring things, but no money spent right now. Great plan. Oh, if only it were that simple.
Somewhere along the way, a business user that had access to this database was granted the CREATE TABLE privilege This is great, she thought. What a convenient place to store all my data. Well, it would be a great place to store her data, if it wasn't the only copy of that data OR if it wasn't all that important. Great plan. Oh, if only it were that simple.
Well, if only she knew what I knew. Or of I knew what she knew. Well, obviously you can guess that wasn't the case. Because, I knew that that database was unrecoverable if the system crashed; and she knew that data was unrecoverable if that database disappeared. And, as you can guess by know, Mr. Murphy paid us a visit and we are in the predicament that we are in now. And management says, find a way to get that data back and do it! Great plan. Oh, if only it were that simple.
--- Send mail for the `bblisa' mailing list to [EMAIL PROTECTED]'. Mail administrative requests to [EMAIL PROTECTED]'.
