Stopping an archival or restore process

Use the stop_archive_restore.nsh script in any of the following scenarios:

Stopping a long-running archival or restore process: The stop_archive_restore.nsh script stops the archival or restore process that is in progress. Before stopping the process, it waits for the process to complete the archival or restore of the table that is being worked on to avoid inconsistency in the database.
Recovering from an archival or restore process that has terminated abruptly: If an archival or restore process terminates abruptly, you might encounter an error while starting a new process. You can use the stop_archive_restore.nsh script to reset the required flags in the reports data warehouse and resolve this error.

To run the stop_archive_restore script

Log on to the reports server.
Navigate to the BDS_HOME/shared/odi/bin directory.
Run the stop_archive_restore.nsh script as follows:
```
nsh stop_archive_restore.nsh
```
Type one of the following options:
- 1: Stops the currently running archival or restore process
- 2: Recovers from a process that has terminated abruptly and resets the required flags in the reports data warehouse
- 3: Exits from the utility