Re: Urgent, please: what are my options???
Date: Sat, 24 Jan 2009 09:33:09 -0800 (PST)
You have to be an OCP before you actually care about the customer. ;-)
Seriously, I understand Alan's sentiment, and frustration. I've had more than one client that insisted that they didn't need backups. The *good* DBA will be able to communicate the volumes of reasons why.
There are a few times that a no backup strategy can be justified in my opinion (such as a case where a duplication of Dev from Test or Production is truly acceptable and workable), but even there a backup is often a faster restore method than a duplication.
At the end of the day though, if you accept the charge for the DB with or without backup, you also accept the responsiblity to do your best to support the customer in as much as they are willing to pay for the hours it will require. At the end of the day if you are billing 80 hours to restore a database and the customer is surprised... then you didn't do your job as the DBA at the begining of the day (or during the day). Of course, if you come on the scene in an emergency capacity then all bets are off.
Robert G. Freeman
OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) 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! :-)
- Original Message ---- From: Howard Latham <howard.latham_at_gmail.com> To: cicciuxdba_at_gmail.com Cc: robertgfreeman_at_yahoo.com; eugene.pipko_at_unionbay.com; "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Saturday, January 24, 2009 2:47:15 AM Subject: Re: Urgent, please: what are my options???
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 -- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 24 2009 - 11:33:09 CST