Oracle Suppport is not Field Support, I would ask to speak to someone
in field support who was familiar with data unloader.
the tech who came to our offices told me that they could recover
without the system tablespace, it would be more difficult but do-able.
- Regina Harter <rharter_at_emc-inc.com> wrote:
> Well, we already had Oracle Support tell us there was NO WAY to get
> at that
> data. Really, I expect how hard we work at getting it will be
> directly
> proportional to how may users call moaning about how hard it will be
> to
> redo the data they entered last week. I will pass this information
> along,
> however.
>
> At 02:10 PM 10/29/01 -0800, you wrote:
> >data unloader WILL work without a system tablespace, although
> obviously
> >it's easier if it exists.
> >
> >in my case we lost the online redo logs and could not force the
> >database to open no matter WHAT we did (and yes, I spent two hours
> on
> >the phone with Oracle Support trying to force it open).
> >
> >we had the system tablespace. we were lucky. ask Tech Support about
> >Data Unloader and get a number for Field Support.
> >
> >There are about 5 or 6 techs in the country who know how to use it.
> >Three on the East Coast, we forced Oracle to pull someone in from
> >vacation. Since he was getting quintuple time at that point, he
> didn't
> >really care :)
> >
> >
> >--- Regina Harter <rharter_at_emc-inc.com> wrote:
> > > Yes, you are absolutely right, we have everything except the
> system
> > > tablespace. The two disks that crashed contained all the program
> > > files,
> > > including unix and oracle, and the system tablespace. The disks
> > > containing all the other datafiles were untouched. However, I
> did
> > > forward
> > > Randy's solution to our DBA, even though I have my own doubts
> about
> > > it
> > > being sufficient.
> > >
> > > At 08:45 AM 10/29/01 -0800, you wrote:
> > > >Yes, but she said that she everything EXCEPT the system
> tablespaces.
> > > If
> > > >this is true then they're SOL, except for Data Unloader.
> > > >
> > > >
> > > >
> > > >
> > > > Randy
> > > >
> > > > Kirkpatrick To: Multiple
> > > recipients of
> > > > list ORACLE-L
> > > > <randywk <ORACLE-L_at_fatcity.com>
> > > >
> > > > @usa.net> cc:
> > > >
> > > > Sent by: root Subject: RE: New
> > > Oracle
> > > > Install and Old Data
> > > > Files
> > > >
> > > >
> > > >
> > > > 10/29/2001
> > > >
> > > > 10:50
> > > > AM
> > > > Please
> > > >
> > > > respond
> > > > to
> > > > ORACLE-L
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >The datafiles contain the tablespaces which contain the data for
> the
> > > >tables,
> > > >indexes, etc. If she has all the datafiles, then she'll have
> access
> > > to all
> > > >the data. I haven't tried it, but this should work for the
> system
> > > >tablespace
> > > >as well.
> > > >
> > > >Randy Kirkpatrick
> > > >
> > > >-----Original Message-----
> > > >tday6_at_csc.com
> > > >Sent: Monday, October 29, 2001 7:00 AM
> > > >To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > >But does she just want the old tablespaces or does she want the
> > > tables and
> > > >indexes that were in those tablespaces? I don't think that
> simply
> > > >recovering the tablespaces will recover the tablespace contents,
> > > though it
> > > >is the way to start.
> > > >
> > > >Doesn't Oracle have a recovery tool -- pay big bucks, they come
> in
> > > and
> > > >recover your database and then remove the tool -- that will do
> this?
> > > >
> > > >
> > > >
> > > >
> > > > Randy
> > > > Kirkpatrick To: Multiple
> > > recipients of
> > > >list
> > > >ORACLE-L
> > > > <randywk <ORACLE-L_at_fatcity.com>
> > > > @usa.net> cc:
> > > > Sent by: root Subject: RE: New
> > > Oracle
> > > >Install
> > > >and Old Data
> > > > Files
> > > >
> > > > 10/26/2001
> > > > 09:00 PM
> > > > Please
> > > > respond to
> > > > ORACLE-L
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >Regina,
> > > >
> > > >Yes there is - but you probably don't want to do it yourself if
> > > you're not
> > > >a
> > > >DBA ...
> > > >
> > > >do a backup control file to trace:
> > > >
> > > >alter database <database> backup controlfile to trace;
> > > >
> > > >shut down the database and modify the sql in the file you
> created so
> > > it
> > > >contains the information for the tablespaces you need.
> > > >
> > > >use the sql file to start up the database
> > > >
> > > >hopefully everything starts ok. Can't guarantee what happens to
> > > integrity,
> > > >etc. if you don't have all the tablespaces.
> > > >
> > > >
> > > >Randy Kirkpatrick
> > > >
> > > >
> > > >
> > > >-----Original Message-----
> > > >Harter
> > > >Sent: Friday, October 26, 2001 5:10 PM
> > > >To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > >Okay People,
> > > >
> > > >I am not the DBA and don't have all the details but this is our
> > > situation
> > > >the way it was explained to me:
> > > >
> > > >We had a server crash to the point where Unix and Oracle had to
> be
> > > >reinstalled, however the disks containing our data tablespaces
> (that
> > > is,
> > > >everything but the system tablespaces) are still good, and
> > > apparently for
> > > >several reasons, we have not had a good backup for at least a
> week.
> > > Is
> > > >there anyway to get a new Oracle install to recognize old
> > > tablespaces?
> > > >
> > > >TIA, Regina
> > > >
>
=== message truncated ===
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Oct 29 2001 - 20:58:37 CST