Skip to content

Data Archiving

Data Archiving is a way of moving data from a production database to a specified data archive destination. The main purpose is to reach better performance by moving data from tables with large amount of data to a data archive destination.

Data archiving set up is made by defining data archive objects and data archive orders. Data archive objects hold information about which database tables to archive and how to archive the data. Data archive orders hold information about when to execute data archive orders and which data archive objects to be executed at a certain time. Data archiving also consists of a log for viewing what has been executed and the result of the execution. If the archive destination is Oracle table in the same database, it is possible to view archived data and restore them accordingly.

As of today there is no way of viewing the archived data in the normal client forms. To view the archived data you need to design special client forms.

Read more about the concept Data Archiving

Note: If the archive destination is Oracle table it is possible to view the data with SQL*Plus or a similar tool. If the archive destination is SQL File one must rely on an editor or similar tools maintained by the operating system to view the data.

Contents

Discusses considerations, upgrades and backups.
Here you find the instructions on how to get the Data Archiving installed and configured.
You need to prepare and structure Archive Objects to let the system know what and how to archive things. Here you learn the details about the Data Archive Packages, Destinations, Archive Types, and get the reference on the Data Archive Object Window.
 To get your Data Archive Objects archived, you will have to make orders to schedule them.
Restoring data from the archives is possible by either running insert scripts that were generated by the archiving process. If the data were archived to oracle tables you can use the form Restore Archive Data to make selections on what to restore.
You find the status of the execution of data archive orders are found in the log.