Re: Is it possible to add existing datafiles to an oracle database?
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: jkstill@xxxxxxxxx, srinivas.chintamani@xxxxxxxxx
- Date: Mon, 28 Apr 2008 16:26:47 -0700 (PDT)
I offered the OP some information on trying to get the DB open with UNDO
corruption using hidden/undocumented parameters. Since it's not supported and
quite risky and easy to find if you google .... I opted not to post it here.
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: Jared Still <jkstill@xxxxxxxxx>
To: srinivas.chintamani@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Monday, April 28, 2008 3:40:14 PM
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
Other related posts:
