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

Just for completeness' sake -- as it has been mentioned more than once in this thread (and wrong every time) :)

The parameter in question is probably _allow_resetlogs_corruption... there is no _allow_log_corruption parameter in oracle.

Cheers

Stefan

On Thu, May 1, 2008 at 7:44 PM, Jared Still <jkstill_at_gmail.com> wrote:

> 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_at_gmail.com> 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_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
>
>
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

-- 
=========================

Stefan P Knecht
Senior Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

OCP 9i/10g SCSA SCNA
=========================

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