Re: Is it possible to add existing datafiles to an oracle database?
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: srinivas.chintamani@xxxxxxxxx
- Date: Thu, 1 May 2008 10:44:08 -0700
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
Other related posts:
