Re: Is it possible to add existing datafiles to an oracle database?
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: Josh.Collier@xxxxxxxxxxxx
- Date: Mon, 28 Apr 2008 16:29:35 -0700 (PDT)
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
Other related posts:
