| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: New Oracle Install and Old Data Files
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
<randywk <ORACLE-L_at_fatcity.com>
@usa.net> cc:
Sent by: root Subject: RE: New Oracle
Install
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Regina Harter
INET: rharter_at_emc-inc.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Randy Kirkpatrick
INET: randywk_at_usa.net
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: tday6_at_csc.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Randy Kirkpatrick
INET: randywk_at_usa.net
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: tday6_at_csc.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 - 11:06:48 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |