Re: Is it possible to add existing datafiles to an oracle database?

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_at_yahoo.com> 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_at_banfield.net>
> To: "srinivas.chintamani_at_gmail.com" <srinivas.chintamani_at_gmail.com>
> Cc: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Jared Still
> *Sent:* Monday, April 28, 2008 2:40 PM
> *To:* srinivas.chintamani_at_gmail.com
> *Cc:* oracle-l_at_freelists.org
> *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_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l