FAQs
How I can get K2Tor?
Why do I need K2Tor?
What data objects can be extracted using K2Tor?
What do I have to know to extract an object?
What can be extracted if a datafile(s) has been corrupted?
Will the data I’m extracting be consistent if some part of my data is corrupted?
Can K2Tor solution be replacement of my current back up and recovery strategy I use?
How I can get K2Tor?K2Tor exists in two different releases: K2Tor Edu and K2Tor Pro. The former is free tool and can be downloaded directly from the website; to receive the latter - please send us the request to suppor@k2tor.com. In the request, please include with your name, your company name and the purpose of request. Why do I need K2Tor?K2Tor is a tool to extract the data out of Oracle datafiles without the use of Oracle database engine. It reads the data directly form datafiles. It also has a set of features to extract the data out of corrupted datafiles. Besides it gives you an ability to look at Oracle datafile block structures to have better understanding how Oracle structures data inside of its datafiles. So, you need K2Tor if you: - Want to learn Oracle internal block structures to improve the space management of your database;
- Want to look inside the Oracle datafiles for the purpose of reviewing or fixing corrupted blocks;
- Have a set of oracle datafiles and have no ability to mount them to oracle services and open the database to review data;
- The database is corrupted and you do not have other options for the database recovery;
- Want to get an Oracle internal descriptions not available in other sources.
What data objects can be extracted using K2Tor?Using K2Tor you can extract a standalone table, a table that a part of a cluster, a partitioned table, or a separate partition/sub-partition. K2Tor does not support: - extraction data using synonym of the table;
- extraction logical objects such as functions, procedures, packages, triggers etc. To extract these objects you have to extract tables that keep the objects;
- extraction of indexes.
What do I have to know to extract an object?To extract an object you have to identify it in the database. There are few ways how an object can be identified for extraction. It can be identified by an object name (OBJ$.NAME), a user name and object name (USER$.NAME, OBJ$.NAME), an object id (OBJ$.OBJ#) or by segment id (OBJ$.DATAOBJ#). OBJ$.NAME represents the table name. If K2Tor finds more than one object with this name in your database it will stop the extraction process. USER$.NAME and OBJ$.NAME – these two names unambiguously identify an object for extraction. OBJ$.OBJ# - you can use this unique object number to extract an object. OBJ$.DATAOBJ# - this number is a segment number where you object is in the database, you will most likely need to use this type of object identification in case your system tablespace has gone and you unable to use any other type of an object identification.
What can be extracted if a datafile(s) has been corrupted?The lowest level K2Tor works on is an oracle block. The tool will identify all corrupted blocks that belong to extracted object and data from them will not be extracted automatically, but might be extracted manually later depends on the type of corruption. If a row from the object spreads out, due to of chaining or migration between corrupted and not corrupted blocks, it will not be extracted.
Will the data I’m extracting be consistent if some part of my data is corrupted?NO. K2Tor is a tool that does dirty block reads and does not rely on any data or information besides the datafile(s) you provide. It’s a tool that helps you to get you data back when nothing else can help.
Can K2Tor solution be replacement of my current back up and recovery strategy I use?The answer is NEGATIVE. K2Tor is not a backup and recovery solution and we strongly suggest you to have at least one backup and recovery solution. K2Tor it’s an emergency data extractor. It’s a tool that helps you to get you data back when nothing else can help
© 2009. k2tor.com
| |
|