Oracle database recovery

Oracle database recovery software is software used for emergency repair of Oracle databases. It can directly read and parse Oracle data files. When the database cannot be opened due to various reasons or there is no backup after data deletion, Eor can be used to rescue the data and minimize the data loss. lost. The table data required by the user can be extracted from damaged or normal Oracle data files.

Product functions are as follows:

1. There is no need to run Oracle database software, EOR directly reads the database file and parses the data. Supports ASM and can export data directly from ASM disks, even if the related disk group cannot be successfully mounted.

2. Supports the direct extraction of data files and any other files stored in ASM (including control files, log files and archive logs, etc.) from ASM, even if the related disk group cannot be successfully mounted.

3. When the ASM disk is seriously damaged, EOR can scan the ASM disk, extract the data files that have not been overwritten, and then extract and restore the data.

4. Supported Oracle database versions include 7, 8i, 9i, 10g, 11g, 12c, supporting cross-platform operation, aix, hpux, linux, windows, etc.

5. Supported data types include: NUMBER, CHAR, VARCHAR2, NCHAR, NVARHCAR2, LONG, DATE, RAW, LONG RAW, BLOB, CLOB, TIMESTAMP (9i+), BINARY FLOAT, BINARY DOUBLE (10g+)

6. Fully supports LOB fields: supports CLOB, NCLOB and BLOBCLOB, supports Big Endian and Little Endian byte order

7. Support LOB partition and sub-partition

8. Supports the case where different LOB columns use different CHUNK SIZE in the same table.

9.CLOB data can be exported to the same file as other columns, or stored to a separate file

10.LOB columns can still be exported without the SYSTEM table space

11.LOB columns can still be exported even if the related lob index is damaged.

12. Able to restore Oracle 11g and above SecureFile LOBs (currently compression, deduplication and encryption of SecureFile LOBs are not supported). Supports various tables, including ordinary HEAP tables, IOT tables and cluster (CLUSTER) tables

13.Support IOT table:

14. Support the export of ordinary IOT tables

15.Support export of compressed IOT table

16.Support IOT table overflow segment

17. Support IOT table partitions (including sub-partitions). The IOT table can only be exported when there is a SYSTEM table space.

18.Support compressed table

19. Support data recovery after the table is truncated

20. Support data recovery after the table is dropped

21. Automatically obtain data dictionary information when there is a SYSTEM table space

22. Supports data recovery without damage to the SYSTEM table space and data dictionary. When no data dictionary is available, EOR can automatically determine the type of data.

23. Supports large file (BigFile) table spaces of 10g and above

24. Fully supports 64-bit systems and supports data files exceeding 4G in size.

25. Support copying bad files that cannot be copied by operating system commands

26. Support data files with different block sizes in the same library.

27. Supports conversion between multiple character sets, and can correctly convert data of CLOB, NCLOB, and NVARCHAR2 column types to the specified character set.

28. Automatically detect the table space number and file number of the data file

29. The exported data formats include plain text and DMP files. When exporting in plain text, it can automatically generate SQL statements for table creation and control files required for SQL*Loader import.

30. Support DESC tables to display column definitions of tables. Support listing partitions and sub-partitions of tables.

31. Supports the recovery of accidentally deleted data. Even if there are LOB columns in the table where the deleted data is deleted, even if the offsets of all records in the row directory corresponding to the deleted data table have been completely cleared by Oracle.

Updates:

1. Fixed the problem of Chinese column names and table names being garbled after being exported.

2. Add support for IOT compression table analysis and export

3. Add block fmt recognition such as 0x82, 0xC2 etc.

4. Fixed some bugs and display problems.