Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: backup disk format

Re: backup disk format

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 14 Aug 2003 16:23:29 +0100
Message-ID: <3f3ba972$0$18488$ed9e5944@reading.news.pipex.net>


At least in the case of Oracle and Microsoft you will find that their lawyers jump on you if you are at all successful. The binary formats they use are proprietory.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
"Peter Nunn" <pnunn_at_pncomputing.net> wrote in message
news:b1nmjv4tjadutoj6abt7o3sd4dsu6i7skl_at_4ax.com...

> Thanks Billy for this information (and all others too naturally).
>
> I'm after the backup format because I'm thinking about producing a
> product that can open backup files from all the major database
> manufacturers, view their structure and report on that (sort of an
> integrity scanner if you like).
>
> I've come to the conclusion that the native formats are going to be
> hard, but am wondering if the backup formats would be worth a look.
>
> I'm going to try and do a binary dump of a backup, but if someone has
> already cracked it, it would save a lot of time.
>
> Thanks.
>
> Peter.
>
> vslabs_at_onwe.co.za (Billy Verreynne) wrote:
>
> >Peter Nunn <pnunn_at_pncomputing.net> wrote
> >
> >> I've been given the task of looking at the disk format (on Windows)
> >> for oracle backups. We need this format to write a porting tool of
> >> sorts.
> >
> >What you are indirectly asking for, is the internal Oracle format for
> >all its binary files. And that you will not get, not matter the
> >temperature in hell.
> >
> >You can not take an Oracle datafile from one platform and "port" it to
> >another. Period.
> >
> >If that is not what you're after Peter, then we will need more
> >details.
> >
> >The basics.
> >
> >Porting data from one Oracle platform to another. Oracle Export and
> >Import. Or a dblink. Or replication.
> >
> >Porting data from Oracle to any other platform and/or database. CSV
> >spool files (easily done with SQL*Plus). These files can be loaded
> >using bcp for SQL-Server or SQL*Loader for Oracle. Alternatively using
> >Oracle Transparent Gateways - which means you can push the data to
> >SQL-Server/Informix/etc from Oracle via the Gateway.
> >
> >What I really would like to know is the business reason behind this
> >request and what business benefits this will result in.
>
Received on Thu Aug 14 2003 - 10:23:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US