E-mail:chf.dba@gmail.com
Title: Oracle Extreme Recovery Support
Author: DATABASE SOS©All rights reserved [without my consent, it may not be reproduced in any form, otherwise there is the right to further legal responsibility.]
All Oracle database recovery work that can be done by similar dul tools (including original and third-party tools), we can provide recovery support through the service, and it is charged after the data is successfully restored, and it is not charged if the recovery is not successful
- Bypass Oracle’s database engine, extracting data directly at the block level.
- Supports ASM can unload data directly from ASM disks even all the diskgroups are dismounted.
- Supports extract files of any type directly from ASM disks even all the diskgroups are dismounted, including datafile, redo log, archive log, etc.
- In severe ASM disk corruption cases (for example, file directory is totally corrupted), can scan ASM disks, extract all the datafiles which are not overwritten, and then recover all the data.
- Supports Oracle RDBMS versions 7, 8i, 9i, 10g, 11g, 12c, 18c, 19c
- Supports multiple database platforms, including AIX, LINUX, HPUX, SOLARIS, WINDOWS and so on. Supports cross-platform unloading, for example unloading AIX based datafiles on a Windows host.
- Supported data types: NUMBER, CHAR, VARCHAR2, NCHAR, NVARHCAR2, LONG, DATE, RAW, LONG RAW, BLOB, CLOB, TIMESTAMP (9i +), BINARY FLOAT, BINARY DOUBLE (10g +), XMLTYPE
- Fully support LOB:
- Supports CLOB, NCLOB and BLOB
- Supports CLOB big endian and little endian byte order
- Supports partitioned and subpartioned LOBs
- Supports different chunk sizes of different LOB columns in the same table
- CLOB data can be exported to the same file with other columns, or stored in a separate file
- LOBs are still be able to export even the SYSTEM tablespace is not available
- LOBs are still be able to export even the associated lob index is corrupted
- Supports recover SecureFile LOB in Oracle 11g and above versions (currently does not support compression, deduplication and encryption SecureFile LOB)
- Supports various types of tables, including ordinary HEAP table, IOT table, CLUSTER table.
- Supports IOT, supported IOT types are:
- Ordinary IOT
- Compressed IOT
- IOT with overflow segments
- Partitioned and subpartitioned IOT
- IOT’s are only supported when SYSTEM is available
- Supports compressed table.
- Supports data recovery after truncate table.
- Supports data recovery after drop table.
- Automatic acquisition of data dictionary information if SYSTEM tablespace is not totally corrupted.
- Supports data recovery in the absence of SYSTEM tablespace and data dictionary corruption. If data dictionary is not available, can automatically determine the data type of a data column.
- Supports BigFile tablespace in Oracle 10g and above.
- Fully support for 64-bit systems, supports more than 4G size of the datafiles.
- Supports bad file copy even the operating system command (for example, cp) can not copy successfully.
- Supports different block size of datafiles in the same database.
- Supports conversion between various character sets, can convert CLOB, NCLOB, NVARCHAR2 column type of data to the specified character set correctly.
- Auto detection of tablespace number, file number and block size of datafiles.
- Exported data formats include plain text, exp dmp and expdp dmp files. When exporting in plain text, you can automatically generate SQL statements for building tables and control files required for SQL * Loader import
- Simulated dump block function of the Oracle, can dump data blocks from datafiles.
- Supports DESC command to a table to display the column definition.
- Supports list all table partitions and subpartions.
- Supports recover accidentally deleted data, even if the table where the data is deleted has LOB columns, even if all the deleted rows’ offsets in corresponding row directory are completely cleared by Oracle.
- Supports table creation statements, stored procedures, views, functions, packages, indexes, constraints, and other non-data recovery