Return Codes in the Central Log reorg<DBSID>.log
Definition
This section contains the return codes for the central log
reorg<DBSID>.log .Use
You can use the return codes to find out how database operations completed.
Structure
Reorganization or Restart
Possible values:
<15|14|12|11|...2|1|0>The return code indicates the last script that was processed successfully during the operation.
Return code |
Termination occurred in script |
15 |
nam<TSP>.sql |
14 |
alt<TSP>.sql |
13 |
drc<TSP>.sql |
12 |
exp<TSP>[_<n>].sh (also exc<TSP>[_<n>].sh ) |
11 |
imx<TSP>.sh |
10 |
swi<TSP>.sql |
9 |
dro<TSP>.sql |
8 |
del<TSP>.sh |
7 |
tsp<TSP>.sql |
6 |
tab<TSP>.sql |
5 |
imp<TSP>[_<n>].sql (also imc<TSP>[_<n>].sh ) |
4 |
ind<TSP>.sql |
3 |
con<TSP>.sql |
2 |
grants.sql or cssv<DIS>.sql |
1 |
ren<TSP>.sql |
0 |
No termination; all scripts were processed successfully. |
Extension/Creation of a Tablespace
Possible values:
<1|0>Return code |
Meaning |
1 |
Extension/creation terminated |
0 |
Extension/creation successful |
Resetting the Database
Possible values:
<40|35|30|25|20|15|5|0>RC |
Explanation (when error occurred) |
Database status |
40 |
Start of operation. Search for offline backups. |
unchanged |
35 |
BRBACKUP run selected. Reading the header information of the logs. |
unchanged |
30 |
Control file and online redo log files saved. |
unchanged |
25 |
Setting and listing the restore parameters, deleting the data files, online redo log files and control files. |
changed |
20 |
Database was closed. The sapdata<n> directories were cleaned up. |
changed |
15 |
Restore of the whole backup (and re-creating the mirrors) was done. |
changed |
5 |
Database was opened. |
consistent |
0 |
All operations successful. |
consistent |
Restore and Recovery of the Database (Point in Time or Restore until Now)
Possible values:
<40|35|30|25|20|15|10|0>RC |
Explanation (when error occurred) |
Database status |
40 |
Operation started. Control file and online redo log files were backed up. All tablespaces restored. |
changed |
35 |
Old data files deleted. |
changed |
30 |
Database was closed. If a control file had to be restored, this was done here. |
changed |
25 |
Restore parameters set and listed. Data files restored. |
changed |
20 |
Database mounted. Current control file restored (if necessary). New data files created. |
changed |
15 |
Archived redo logs were checked and found. Restore parameters were checked and set. The first archived redo log files were restored. |
changed |
10 |
Point-In-Time-Recovery. Backup recommended. |
consistent |
0 |
All operations successful. The database was opened ( RESETLOGS or NORESETLOGS ). |
consistent |