There's more to using the _Allow_LOG_Corruption parameter than just setting it to true. You really need to work with Oracle Support to get it to work. On Mon, Apr 28, 2008 at 9:32 PM, Srinivas Chintamani < srinivas.chintamani@xxxxxxxxx> wrote: > Hi All, > I am extremely delighted at the number of responses I got to my question. > I have tried most everything suggested, including setting the > _Allow_LOG_Corruption parameter to true. It pains me to report that, it > didn't solve my problem. Anyways, I guess its a lesson - learnt the hard > way; Not having a tested backup. I guess I will be more careful in future. > > Thank you all for your helpful comments / suggestions. > > Regards, > Srinivas. > > > On Tue, Apr 29, 2008 at 4:59 AM, Robert Freeman <robertgfreeman@xxxxxxxxx> > wrote: > > > The OP does not seem to have a valid backup. > > > > RF > > > > Robert G. Freeman > > Author: > > 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 Feature > > Blog: http://robertgfreeman.blogspot.com (Oracle Press) > > > > > > ----- Original Message ---- > > From: Josh Collier <Josh.Collier@xxxxxxxxxxxx> > > To: "srinivas.chintamani@xxxxxxxxx" <srinivas.chintamani@xxxxxxxxx> > > Cc: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> > > Sent: Monday, April 28, 2008 5:11:32 PM > > Subject: RE: Is it possible to add existing datafiles to an oracle > > database? > > > > Restore a good copy of the datafile from a backup and perform recovery > > as needed. > > > > > > > > still no mention of > > 1. your db version > > 2. your os > > 3. the contents of your alert log when the system crashed. > > 4. your pfile contents > > 5. your control file statement. > > > > your recovery would have been simple if you had a tested recovery > > strategy. Of the two words in the phrase "backup and recovery"; recovery is > > the more important. > > > > Where you trying to resize the undo tablespace and hit control-c? > > > > you could try putting the db in manual undo and starting it with the > > default rollback seg in the system tablespace. > > > > > > > > ------------------------------ > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Jared Still > > *Sent:* Monday, April 28, 2008 2:40 PM > > *To:* srinivas.chintamani@xxxxxxxxx > > *Cc:* oracle-l@xxxxxxxxxxxxx > > *Subject:* Re: Is it possible to add existing datafiles to an oracle > > database? > > > > On Fri, Apr 25, 2008 at 6:31 AM, Srinivas Chintamani < > > srinivas.chintamani@xxxxxxxxx> wrote: > > > > > > > > Earlier when working with SQL Server, it was simple to backup / > > > restore the db. Just take a backup, dump the backup file anywhere on the > > > filesystem and point to SQL Server, where the backup file is at and it > > > happily recovered the db, all in a few seconds. > > > > > > Wonder why restoring an oracle db is such a pain ... > > > > > > > Comparing a tool you know to one you don't know is not really a fair > > comparison. > > > > I'm somewhat familiar with backing up and restoring SQL Server and > > Oracle. > > Backing up an oracle database is more comparable to backing up an entire > > SQL Server instance, not a single SQL Server database. > > > > Try this on SQL Server: set the log file to unlimited growth. Let the > > log fill > > the disk. Try reopening the database following that. It's a lot of fun. > > > > No database is perfect. If you are responsible for backups of a > > database, the first > > thing you should make sure you can do is restore said backups. > > > > Now that you've (hopefully) learned that lesson, perhaps someone can > > help you > > with your down database. > > > > Further down in the thread it appears that the UNDO tbs is corrupt, > > correct? > > > > IIRC there may be a way to open this db, though some corruption may > > occur. > > > > Have you escalated the SR? This is not the same as setting a severity > > level. > > > > Search for 'escalation' on MetaLink. > > > > > > -- > > Jared Still > > Certifiable Oracle DBA and Part Time Perl Evangelist > > > > > > -- > Regards, > Srinivas Chintamani -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist