| 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: backup/recovery scenarios/data unloader question
Hum, anonymous works best when you do not send the email to the whole group. I will try hard not to look at the name though;-)
-----Original Message-----
Gopalakrishnan
Sent: Monday, December 24, 2001 6:05 AM
To: Multiple recipients of list ORACLE-L
Joe,
We (I and few want to be anonymous) are trying to build a tool like Data Unloader which converts the data file from one Operating System to another Operating System format.. (i.e. it will convert Oracle datafile from NT to any Unix and vice versa).. If this works well you don't need to export/import the databases to do a cross platform migration. You can run the converter and transfer the datafiles to the target operating system and recreate the control file to bring up the database. Since we know the data block formats and how oracle stores the data inside data blocks we may come up with a tool, which reads the oracle datafiles and gives you an ASCII text datafile. Something similar to Data Unloader. Jeremiah (of Amazon.com) has an enhancement request with oracle for similar tool and not sure about the oracle's stand on that. He may have more details to share.. :)
This tool will be superior to DUL (not sure about Oracle's ***official ** support status of the databases created using this converter) and will try to address the current limitations of DUL.
Best Regards,
K Gopalakrishnan
(408) 934 9310
-----Original Message-----
Sent: Monday, December 24, 2001 5:10 AM
To: Multiple recipients of list ORACLE-L
Well yours truly is doing a 3 hr backup/reocvery presetation on a geek cruise in may(2002). Those of you who've had backup/recovery problems(more like recovery problems), if you'd like to share some of the scenarios/problems you've run into, the more bizarre the better, corrupted redo logs, etc. If you'd kindly email them to me, i'll include then in the lesson(and will send you a copy of the slides when completed).
Also, there is at least one person(the goddess) who has dealt with oracle support on this, my question is(as my inquiring mind would like to know), has anyone attempted to write the tool to so that(the unloader thing), reading the raw data blocks from a data file and dump out the data in simple insert statements.
IF no one has, is anyone interested in trying it out?
joe
--
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
INET: teci_at_the-testas.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: K Gopalakrishnan
INET: kaygopal_at_yahoo.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: Kimberly Smith
INET: ksmith2_at_myfirstlink.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). Received on Mon Dec 24 2001 - 11:38:30 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |