Re: data extraction from dead database

From: <jo_holvoet_at_amis.com>
Date: 23-Mar-2006 09:01:18 CET
Message-id:
Message-Id: <1143102601.12580@server1.orafaq.com>

We used the following once with good success :

http://www.anysql.net/en/aul.html

Documentation is, however, sparse to say the least. Can create files in Oracle 8.1.7 export format to easily import somewhere else.

mvg/regards

                                                                           
             "Fedock, John                                                 
             (KAM.RHQ)"                                                    
             <John.Fedock_at_us.k                                          To 
             line.com>                 <oracle-l_at_freelists.org>            
             Sent by:                                                   cc 
             oracle-l-bounce_at_f                                             
             reelists.org                                          Subject 
                                       data extraction from dead database  
                                                                           
             22-03-06 22:31                                                
                                                                           
                                                                           
             Please respond to                                             
             John.Fedock_at_us.kl                                             
                  ine.com

If I recall, Oracle has a tool that can read datafiles and assemble the data is some type of useable format, from a crashed database.

We have a 8.1.7.4 database that we may need this type of tool for. Can anyone offer any information on this? And, yes the database was backed up nightly, but the tapes were not rotated and checked.

Thanks all.

John Fedock
K Line America, Inc.
john.fedock_at_us.kline.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 23 2006 - 02:01:18 CST