Restart File for Reorganizations (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Restart File for Reorganizations

Definition

The restart file contains the scripts required for performing the corresponding reorganization of the Oracle database, that is, a subset of the following scripts:

alt<TSP>.sql, drc<TSP>.sql, exp<TSP>.sh, exc<TSP>.sh, unl<TSP>.sh, swi<TSP>.sql, dro<TSP>.sql, del<TSP>.sh, ren<TSP>.sql, tsp<TSP>.sql, tab<TSP>.sql, imc<TSP>.sh, imp<TSP>.sh, ldr<TSP>.sh, ind<TSP>.sql, imx<TSP>.sh, inx<TSP>.sql, con<TSP>.sql, grants.sql

Structure

Restart files are named as follows:

<SAPDATA_HOME>/sapreorg/<timestamp>/restart.<ext>

The extension <ext> indicates the SAPDBA function of the restart file:

File Extensions for a Reorganization

Extension	Meaning
rsi	Reorganization of single tables or indexes
rli	Reorganization of a list of tables or indexes
rtc	Reorganization of tablespaces
rtd	Reorganization of tablespaces with data files
rmv	Change the data file allocation for a tablespace (move/rename data files of a tablespace)

These values are identical with the extension of the corresponding log, <SAPDATA_HOME>/sapreorg/<timestamp>.<ext> .

For a complete overview of the scripts that are written and used by SAPDBA, refer to SAPDBA Scripts and Files.

See also:

Reorganization of a Single Object

Reorganization of a List of Objects

Reorganization of a Tablespace

Reorganization of a Tablespace with Data Files

Moving/Renaming the Data Files of a Tablespace.

Use

When a reorganization is started, the scripts in the restart file are processed in sequence. The indicator before each script indicates whether it was successfully processed or not.

Script Indicators in the Restart Files for Reorganization

Script indicator	Meaning
Y	Script processed successfully
N	Script not yet processed or failed. Before a reorganization is started, all scripts have this indicator.
S	The data import has already been started but SAPDBA could not process the import script properly due to an external error (for example, import interrupted by user or power failure). SAPDBA terminated. Scripts indicated with S will automatically be newly processed in the event of a restart.

During a reorganization, all the scripts indicated with N are processed, and are changed to Y once the respective operation has been completed. The exception to this is the script imp<TSP>.sh : N ® S ® Y, in error condition N ® S ® N.

If the import did not run correctly the indicator of the corresponding script remains S. When restarting the reorganization in this case the contents of all the tables which were already imported are deleted, the indicator is reset to N and the script imp<TSP>.sh is processed again. SAPDBA deletes the contents of tables found in the script exp<TSP>.par (with the Oracle command TRUNCATE ).

If several export dump files are generated during export or import, SAPDBA only deletes the contents of the tables found in script exp<TSP>_<n>.par of the canceled import process ( imp<TSP>_<n>.sh ).

Note

Do not change the sequence of scripts that appears in the restart file. This determines the flow of the corresponding reorganization.

See also:

SAPDBA Scripts and Files