Perform a parallel restore

If you have a fragmented table that resides in separate dbspaces, you can perform a physical table-level restore in parallel by executing multiple archecker commands with different schema command files for each dbspace.

During a level-0 archive, there cannot be any open transactions that would change the schema of the table. The table or table fragments being recovered must exist in the level-0 archive. The table or fragment cannot be created or added during the logical recovery. Tables created or fragments added during the logical recovery are ignored.

Because a detached fragment is no longer part of the original table, the applier does not process the detached fragment log record or any other log records for this fragment from this point forward. A message in the archecker message log file indicates a detach occurred.

In this example, the table is fragmented across three dbspaces. The corresponding schema command files are named cmdfile1, cmdfile2, cmdfile3. The following commands delete previous restores and then perform physical restores on each dbspace in parallel:
  • archecker -DX
  • archecker -bvs -f cmdfile1 -lphys
  • archecker -bvs -f cmdfile2 -lphys
  • archecker -bvs -f cmdfile3 -lphys

You cannot perform a logical restore in parallel.