Re: Urgent, please: what are my options???
Date: Sat, 24 Jan 2009 10:37:14 -0200
CT is not always right, that is something DBAs really need to understand. SPECIALLY when backup policies are involved. I've had to open databases in really messy states because CT wouldn't invest in a proper backup architecture, even after I pointed out the possible dangers of having a weak backup, specially in this particular system, which was Oracle8i on Windows NT4, all of which was unsupported by Oracle. Of course, after a whole lot of effort, time and way more resources than the CT paid for, we were able to get the database in a somewhat consistent state.
Interestingly enough, after recover, CT kept using the same weak backup architecture, even though, yet once again, I pointed out the possible dangers and proposed a low cost alternative that would work better and would be safer. So, in this case the only option left is for the database to crash and the data to be unrecoverable at all and CT to learn the lesson for the next time... hopefully.
Anyway, that is in fact a business decision and does not lie with the DBA (thankfully)
And this discussion is far off topic and more of a flamewar than a discussion at this point.
And one more thing, Oracle Certifications certify your expertise in Oracle, not you relationship with CT... perhaps you were thinking of Microsoft certifications :-D
Oracle Certified Associate
On Sat, Jan 24, 2009 at 7:47 AM, Howard Latham <howard.latham_at_gmail.com> wrote:
> Can you be an Oracle Certified Associate and let the CT BURN? Glad I'm
> not certified!
> 2009/1/24 Guillermo Alan Bort <cicciuxdba_at_gmail.com>:
>> I seem to remember that it is possible to open a corrupt database,
>> *only* for export. However data corruption may occur. I would suggest,
>> yet again, that you contact Oracle Support, but I'm not certain they
>> will help you. On one hand they don't like to suggest hidden
>> parameters just for the heck of it, and usually first and second level
>> support won't know them well enough, so perhaps you could open the SR
>> with an escalation request.
>> Other than that, create a test environment and perform *everything*
>> oracle suggests on that environment (thus leaving a backup of the
>> original environment).
>> Again, why no backups? the only valid reason to have a database
>> without backup is that you can obtain all the information from other
>> sources, if this is the case, you should rebuild the database from
>> other sources instead of messing around with a corrupt db. If CT
>> refused to have backup of a database solely based on cost, then this
>> is what they deserve, and as a DBA I urge you not to solve the issue
>> and let them burn (though I understand it's not always possible).
>> I know this isn't of much help, but the situation is a rather hopeless one.
>> I have recovered databases in worse conditions, but data loss was
>> significant, and Functional Analysts spent a *LOT* of time making sure
>> the data was valid (and correcting inconsistencies). (a 'cold' backup
>> taken with db up... luckily it was archivelog on, db was fuzzy
>> Alan Bort
>> Oracle Certified Associate
>> On Fri, Jan 23, 2009 at 7:39 PM, Robert Freeman
>> <robertgfreeman_at_yahoo.com> wrote:
>>> I'm not about to touch this question with a 10 foot pole.
>>> A google search for things like Oracle force open database might provide
>>> some help and suggestions.
>>> If you get it back up, understand that it's inconsistent.... there is no
>>> assurance that the data is in any state that is usable.
>>> I have to ask... why no backup?
>>> Robert G. Freeman
>>> OCP: Oracle Database 11g Administrator Certified Professional Study Guide
>>> Oracle Database 11g New Features (Oracle Press)
>>> Portable DBA: Oracle (Oracle Press)
>>> Oracle Database 10g New Features (Oracle Press)
>>> Oracle9i RMAN Backup and Recovery (Oracle Press)
>>> Oracle9i New Features (Oracle Press)
>>> Other various titles out of print now...
>>> Blog: http://robertgfreeman.blogspot.com
>>> The LDS Church is looking for DBA's. You do have to be a Church member in
>>> good standing. A lot of kind people write me, concerned I may be breaking
>>> the law by saying you have to be a Church member. It's legal I promise! :-)
>>> From: Eugene Pipko <eugene.pipko_at_unionbay.com>
>>> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
>>> Sent: Friday, January 23, 2009 1:31:14 PM
>>> Subject: Urgent, please: what are my options???
>>> Hi all,
>>> I have a 9i on Windows2003 with no backup.
>>> Database was open while drive where redo logs resided was gone. So I lost
>>> all redo logs.
>>> I shutdown d/b, mounted it, backed up controlfile to trace.
>>> Recreated control file, but when I try to open resetlogs d/base I receive an
>>> ORA-01194: file 1 needs more recovery to be consistent
>>> ORA-01110: data file 1: 'D:\ORACLE_SAN\DATA\SYSTEM\REPD_SYSTEM_01.DBF'
>>> What are my options besides rebuilding d/base???
>>> P Please consider the environment before printing this e-mail.
> Howard A. Latham