oracle

The main functional points of the V3 oracle disaster recovery system:

There is no need to run Oracle database software, the V3 oracle disaster recovery system 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 mounted successfully. Supports direct extraction of data files and any other files stored in ASM (including control files, log files, archive logs, etc.) , even if the related disk group cannot be mounted successfully. The supported Oracle database versions include 7, 8i, 9i, 10g, and 11g. It supports databases on multiple platforms, including AIX, LINUX, HPUX, SOLARIS, WINDOWS, etc. Ability to export data from other platforms on one platform, such as on Windows 32-bit systems, using data files on the AIX system to export data.

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

Supports CLOB, NCLOB and BLOBCLOB Supports Big Endian and Little Endian byte order Supports LOB partitioning, sub-partitioning supports the same table, different LOB columns use different CHUNK SIZE CLOB data can be exported to the same file as other columns, or Store LOB columns in separate files. LOB columns can still be exported even if there is no SYSTEM table space. LOB columns can still be exported even if the related lob index is damaged. Supports various tables, including ordinary HEAP tables, IOT tables and clusters (CLUSTER). ) table supports IOT table:

Supports the export of ordinary IOT tables. Supports the export of compressed IOT tables. Supports IOT table overflow segments. Supports IOT table partitions (including sub-partitions). IOT tables can only be exported when there is a SYSTEM table space. Supports compressed tables. Supports data recovery after tables are truncated. Data recovery after a table is dropped automatically obtains data dictionary information when there is a SYSTEM table space. It supports large files (BigFile) of 10g and above. The table space fully supports 64-bit systems and supports data files exceeding 4G in size.

Supports copying bad files that cannot be copied by operating system commands. Supports data files with different block sizes in the same library.

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

Automatically detect the table space number and file number of the data file. 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 to simulate Oracle's dump block function. It can dump data blocks in data files to support DESC tables to display column definitions of tables and support columns. Partitions and subpartitions of the table.