K2 » Products » K2Tor Pro beta

K2Tor Pro is a multi purpose tool for Oracle newbies and professionals as well as for DBA and developers. The tool has simple command line interface and intuitive set of commands. It's specifically designed to extract data out of you database in fast and reliable manner in case of database corruption when standard recovery procedure cannot be used.

It also allows you to view oracle datafiles internals in structured and unstructured forms also providing some helpful functions to work with blocks and their structures. It does dirty block reads and can work either with a datafile(s) that is currently in use by an Oracle service or with “offline” datafiles. K2Tor Pro is a standalone application written in C++ and uses Standard Template Library (STL) only, which currently allows it to be run on any of Linux or Windows platforms and supports Oracle 9i, 10g datafiles.

The more things we do the more we rely on the information we have. It can be true for both individuals and companies. Some of us keep the information in the databases and call it data. Data requires to be taken care of and have such things as managing system, known as DBMS, and a system administrator to manage the managing system. And the managing system occurs to crush and corrupt your data and system administrator occurs not to be able recover or restore your data. There can be a number of cases why both these things happened, but we think you will be more interested to get you data back and do it quickly and only after this is done to look for this “number”.

Certainly, such well-known vendor as Oracle provides recovery solutions for their databases, but all of them require one or more steps to be done before a system crush: install standby system, store archives of log files, do periodical backup of the database. They do their job pretty well and we strongly suggest you to deploy at least one of them for your database. Despite the solutions are well know and steps to deploy them relatively simple there is always a chance that a small required piece such as a archive logfile is missed, or moreover an administrator forgot to create a backup of the database. Such small mistakes can cause, in case of system crash or data corruption, to situation, when you are not able to open the database and read the data from it. And here is when the hard times come - how to get back your data out of oracle datafiles and have your business up and running?

The answer will be you have to extract you data into simple readable format and then upload it into newly-created database. And this is exactly what K2Tor Pro does - extracts the data out of Oracle datafiles.

Oracle DBMS version supported: 10g, 9i
Platforms supported: Windows, Linux, Sun (SPARC);
Easy portability to other platforms. Written in C++ using Standard Template Library (STL);
Extracts data into CSV file ready to be loaded by Oracle SQL*Loader utility;
Extracts table(s) by object id, table/partition/sub-partition name or segment id;
Extracts partitioned table(s) by partition or sub-partition;
Extracts table that are part of a cluster;
Extract tables having compressed blocks;
NEW! Extract IOT tables;
Allows to export data in hexadecimal format;
Detects blocksize and number of blocks of the datafiles;
Supports building of file(s)/extent/segment map;
Checks blocks for validity based on header-tail check and control sum check;
Extracting data with missing system tablespace with restrictions: columns are extracted in physical order; columns types are guessed; intra-segment datatypes are supported only;
SQL Plus like table description;
Datatypes supported: NUMBER, BINARY_FLOAT, BINARY_DOUBLE, DATE, TIMESTAMP(s), INTERVALS, CHAR, VARCHAR2, RAW, BFILE, CLOB, BLOB (with restrictions);
Row chaining and migration;
Low level block viewer;
Built-in Oracle types converter.

NOTE: k2tor does not support cross-platform unloading, which means data from datafiles that has been created under Solaris SPARC can not be unloaded with k2tor installed under Linux or Windows platforms.